Monitoring SQL Server Agent Job Failures with SolarWinds DPA Custom Alerts
DPA’s built-in job failure alert fires on every step failure including intentional ones. These two custom SQL alert queries filter to step_id = 0, catching only genuine job-level failures.
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.
A Junior DBA’s Field Guide to This Series: What Your Mentor Forgot to Explain
A companion guide for junior DBAs navigating the ALTER DBA ADD AGENT series. Maps the vocabulary walls, production safety gaps, and confidence calibration challenges that experienced readers won’t even notice.
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.
AI-Generated Availability Group Failover Runbook
Generate a complete AG failover runbook with AI pre-flight checks, failover, validation, and rollback in PowerShell.