Forced Quorum Mode and The Value of Democracy
AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Learn from a real-life scenario involving DR exercises and quorum failures.
Home »
AlwaysOn
What is not contained in contained Availability Groups
While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”.
Read More »What is not contained in contained Availability Groups
Control SQL Jobs based on HADR Role – Taking it to the Next Level
In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for automatically enabling or disabling scheduled jobs in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!
Read More »Control SQL Jobs based on HADR Role – Taking it to the Next Level
Eitan Guest-Stars in SQL Server Radio Episodes 111 and 117
Last week, I called up Matan Yungman, and offered to replace Guy Glantser as a co-host in SQL Server Radio, while Guy is away on… Read More »Eitan Guest-Stars in SQL Server Radio Episodes 111 and 117
Automatically Enable or Disable Jobs Based on HADR Role
Imagine the following: You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn Availability Groups, Database Mirroring,… Read More »Automatically Enable or Disable Jobs Based on HADR Role