Upgrading Database Compatibility Levels Across a Whole Instance
The instance upgrade went perfectly. You moved from SQL Server 2019 to 2022, the installer turned green, the services came back up, and the application connected on the first try. A week later someone asks…
SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.
AI-Generated Availability Group Failover Runbook
Generate a complete AG failover runbook with AI pre-flight checks, failover, validation, and rollback in PowerShell.
Availability Group Health Monitoring with AI
Build comprehensive AG health monitoring with AI sync state, redo queue, listener health, and failover readiness.
Mapping Availability Group Topology with AI
Query and document your AG topology with AI covering replica roles, sync states, and misconfiguration detection.
Automating Server Health Checks and Inventory Scripts
Generate server health check and inventory scripts with AI backup status, disk space, version audits, AG health, and configuration drift detection.