SQL Server Availability Groups have been around for a while. A lot of organizations are still in the process of implementing them as they upgrade their database platforms to the latest version of SQL Server. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much […]
SQL Server Availability Groups have been around for a while. A lot of organizations are still in the process of implementing them as they upgrade their database platforms to the latest version of SQL Server. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much […]
SQL Server Availability Groups have been around for a while. A lot of organizations are still in the process of implementing them as they upgrade their database platforms to the latest version of SQL Server. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much […]
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. […]
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 […]
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 […]
NO, that is certainly not a typo. I really did intend to say SQL Server 2005 and SQL Server 2008. Note that a previous blog post mentioned that you only have less than a year before SQL Server 2005 is out of extended support. So, why, you might ask, would I still be talking about features […]
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 […]
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 […]
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 | […]
