• Server applying automatic software patches with network monitoring and threat detection

    How I Use Python To Automatically Download And Stage SQL Server CUs And GDRs

    Patching is such an important part of ensuring your MS SQL Servers are secure, reliable, and resilient. As important as it is, it’s still a tedious process. You have to chronically check for patches (hopefully you don’t have your servers running SQL to auto download and apply patches via Windows Update), look at breaking changes…


  • Database Crash Recovery Takes Forever After Planned Manual Failover

    Weekend Patching, Business As Usual Today I was patching a bunch of servers at a client as Microsoft released their most recent Security Patch for SQL Server that addresses an exploit / vulnerability found after patch Tuesday. Read more on it here. I went through the normal patching routine for an AG; working through all…