Build an AlwaysON Availability Group Part 2: Setting up SQL Server and Adding a DatabaseBefore we begin: While the gui/wizard for setting up Availability groups is super easy, I'm going to go through utilizing T-SQL. This...
Build an AlwaysON Availability Group Part 1: Build the Windows Failover ClusterBuild the cluster right so you don't run around frantically like this guy does for a living. So most DBA's know that AlwaysOn...
Deadlock Error HandlingAn elegant function for a more civilized age: Another way to detect deadlocks is to utilize the TRY CATCH block to raise errors in TSQL...