Add new Databases to a AG Setup with PowerShell

Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.

AG Sync Folders

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.

AlwaysON Availability Group and Jobs Part 1

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.

SQL Server 2016 Just Runs Faster - Redo

AG Failure Conditions

Automatic Seeding

SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

Monitoring Availability Group Replica Synchronization

If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.

Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers.