DAG Failover Toolkit: Scripted Distributed AG Failovers with Validation Gates
In a previous post, we looked at how Distributed Availability Groups work, why the failover syntax says FORCE_FAILOVER_ALLOW_DATA_LOSS, and what a scripted runbook should cover. This post introduces the toolkit that puts all of that…
Schedule Jobs in Azure SQL Database with Azure Functions
You don’t get SQL Server Agent in Azure SQL Database. If you’ve been a DBA for any length of time, that sentence probably made you twitch. Agent is the workhorse that runs your index maintenance,…
The psqlODBC Driver Is Eating Your RAISE NOTICE Messages
I just spent two days debugging a problem where my PowerShell script was logging 900 lines of output instead of 150. The script worked fine for months. Then someone added more tables to the process,…
I Shaved 156 MB Off My Blog by Converting PNGs to WebP
I just shaved 156 MB off my blog. Not the database, not the theme, not some plugin audit. The images. The Problem Nobody Talks About If you use AI to generate featured images for your…
SQL Server Patching Pre/Post Checks with AI
Generate matched pre-patch and post-patch validation scripts with AI for safe SQL Server patching.
Smart DBCC CHECKDB Scheduling with AI
Build intelligent CHECKDB scheduling with AI size-based estimates, window optimization, and corruption alerting.