database mirroring

Feature Request – Expand MSX/TSX Capabilities for HADR

2020-09-16
Life, SQL Server Database Engine, Tools and Scripts

Following my presentation of “How to HADR Your SQL Server Jobs” at the HA/DR PASS Virtual Group yesterday, David Klee (@kleegeek) and I continued chatting for a bit longer after the recording was concluded. During which, the MSX/TSX feature of SQL Server came up, and David suggested that I’d utilize my newly earned MVP status to push a feature request to expand these capabilities.

Control SQL Jobs based on HADR Role – Taking it to the Next Level

2020-05-262024-05-12
SQL Server Database Engine, T-SQL, Tools and Scripts
3 Comments

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!