Using the Cluster Preparation Checklist for Deploying SQL Server Failover Clustered Instances and Always On Availability Groups

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 […]

Partition-Level Online Index Operations in SQL Server 2014 and its Impact in HA/DR

One of the cool features introduced in SQL Server 2014 was the ability to perform an online index rebuild of a single partition. Prior to SQL Server 2014, the only way to rebuild indexes for a partitioned table was to do it on all of the partitions (or, simply put, rebuild the entire index on […]

Why We Need To Understand How Active Directory Affects SQL Server High Availability

But I’ll tell you what hermits realize. If you go off into a far, far forest and get very quiet, you’ll come to understand that you’re connected with everything. – Alan Watts – WARNING: There will be a ton of acronyms in this blog post. Make sure to keep your notebook handy for note-taking reference. […]