Tag: availability-groups

PostMuch Ado About DNS

SQL Server Availability Groups have been around for a while. But not a lot of organizations have implemented them yet mainly because they haven’t upgraded their database platforms to SQL Server 2012/2014. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much more common. And […]

PostWhy Active Directory Domain Services Authentication Matters

SQL Server Availability Groups have been around for a while. But not a lot of organizations have implemented them yet mainly because they haven’t upgraded their database platforms to SQL Server 2012/2014. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much more common. And […]

PostThe US$ 50,000 Nested Parenthesis

In a previous blog post, I talked about the new SQL Server 2016 Availability Groups Load Balancing of Read-Only Replicas feature (I know that’s a mouthful but it’s how I understand the concept.) I explained how the precedence rules in defining how the read-only workload is balanced across multiple readable secondary replicas using nested parenthesis. One […]

PostHow To Enable Transparent Data Encryption In An Existing SQL Server Always On Availability Group

I’ve deployed several SQL Server Always On Availability Groups in the past with high availability being the primary requirement. In some environments, there is a requirement to protect sensitive data for security and compliance reasons. Back in 2013, I had a customer who wanted to implement Always On Availability Groups for their databases. They were moving their […]

PostEnd-to-End SQL Server High Availability and Disaster Recovery

High Availability and Disaster Recovery (HA/DR) is an area that every SQL Server DBA needs to be comfortable with, especially when dealing with mission-critical database systems. One cannot wait until a real disaster strikes before learning how to deal with it. This advanced, deep-dive course is designed for SQL Server DBAs and system administrators to […]

PostSo, You Think Your SQL Server Always On Availability Group Is Really Highly Available?

This is a question that I regularly ask those attending my high availability and disaster recovery presentations: is your SQL Server Always On Availability Group really highly available? Now, don’t get me wrong. I love the Always On Availability Groups feature in SQL Server (except for the price tag of an Enterprise Edition license.) But there’s […]

PostGot A “Validating WSFC quorum vote configuration” warning when you create a SQL Server Always On Availability Group?

I bet a lot of IT professionals who are really serious about their work are like me. When they see an error or warning message like this, their first instinct is to find out what the problem is and fix it. That’s what I did when I saw this error while configuring a SQL Server […]

PostCreating a SQL Server 2012 Availability Group Article on CanITPro.net

I’ve been wanting to write for the CanITPro.net website for quite sometime now, primarily because there hasn’t been any new content on SQL Server on the site lately. The Canadian IT Pro and developer communities are very vibrant and active, thanks to the effort of Canadian Microsoft MVPs Jean-René Roy (blog) (DevTeach/SQLTeach) and D’Arcy Lussier (Twitter | […]

Copyright © 2019 Learn SQL Server High Availability & Disaster Recovery

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close