When I started working with virtual machines on Microsoft Azure last year, one of the first test that I did was to configure SQL Server Availability Groups in a hybrid configuration. The configuration consists of a failover clustered instance on production data center for local high availability and an Availability Group replica on Microsoft Azure […]
Failing to plan is planning to fail Designing and deploying high availability solutions takes a lot of preparation and planning. Whenever I do presentations that involve demos of creating SQL Server failover clustered instances (FCIs) and Availability Groups (AGs,) I emphasize that while the demo only takes less than 20 minutes to complete, it takes […]
One of the demos that I show when I talk about AND dependencies in a Windows Server Failover Cluster is moving a SQL Server resource group (or role as of Windows Server 2012 and higher) to a different cluster node. During the failover, I highlight that the SQL Server cluster resource will not come online until […]