Tag Archives: high availability

Separate Reads

Posted on November 13, 2024 by way0utwest

Recently I was watching a presentation on how to scale performance in your SQL Server environment and one of the suggestions was setting up Availability Groups (AGs) and having read-intent connections that would query the secondary and not the primary. … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Database Mirroring is Back in Azure SQL Database

Posted on March 30, 2024 by way0utwest

Database mirroring was a cool feature in SQL Server 2005. I guess it’s still a feature, though it’s listed as deprecated in the documentation. There is still a mirroring dialog in the SSMS database properties dialog in more recent versions … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Database Mirroring is Back in Azure SQL Database

Improving Availability Groups

Posted on January 15, 2021 by way0utwest

Availability Groups (AG) were introduced in SQL Server 2012, with the idea that we could dramatically improve (and ease) the burden of dealing with high availability in SQL Server. At the time the (code named) HADRON technology seemed full of … Continue reading →

Posted in Editorial | Tagged | Comments Off on Improving Availability Groups

Have You Deployed an Availability Group?

Posted on April 3, 2020 by way0utwest

The last few weeks have been interesting, to put it mildly, with both more and less engagement online. I see more people holding video calls, both inside and outside of work, but I also see less engagement at SQLServerCentral, blogs, … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Have You Deployed an Availability Group?