AlwaysOn Availability Groups

Top 10 Tips for Availability Groups

May 1, 2017

/

I have enjoyed working with Availability Groups ever since they were released with SQL Server 2012. Each major version since, the feature has improved…

Connecting your Azure regions

January 24, 2017

/

Derik Hammer

In this post, I am going to demonstrate how to configure virtual network gateways in Azure using Resource Manager. This is important for connecting…

Measuring Availability Group Synchronization Lag

September 1, 2016

/

Derik Hammer

With all of the high-availability (HA) and disaster recovery (DR) features, the database administrator must understand how much data loss and downtime is possible…

Availability Group Architecture – DR on the Cheap

February 16, 2016

/

Derik Hammer

Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will…

Availability Group Architecture – Adding a Second Site

February 2, 2016

/

Derik Hammer

Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture,…

Availability Group Architecture – High-Availability Only

January 19, 2016

/

Derik Hammer

Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features…

T-SQL Tuesday #74 – Be the change (MERGE static data)

January 12, 2016

/

Derik Hammer

Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then…

Availability Group fail-over test with PowerShell

December 3, 2014

/

Derik Hammer

I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency…