Version Control and CI/CD: Unlocking What the Agent Can Actually Do
AI agents become dramatically more powerful when your database code is in version control. Learn to set up Git repos and CI/CD pipelines for SQL Server.
Building Custom Monitoring Queries and Alerts
Build custom SQL Server monitoring queries and alerts with AI long-running transactions, blocking chains, backup failures, and intelligent thresholds.
AI-Native Monitoring: PerformanceMonitor, PerformanceStudio, and the MCP Revolution
Erik Darling’s PerformanceMonitor and PerformanceStudio bring MCP integration to SQL Server monitoring letting AI query your performance data directly.
Migration Planning: Compatibility Checks and Deprecated Features
Plan SQL Server version upgrades with AI deprecated feature scans, compatibility level analysis, breaking change detection, and migration runbooks.
Security Audits: Finding What You Missed
AI-assisted security audits for SQL Server finding orphaned users, permission sprawl, unencrypted connections, and compliance gaps across your fleet.
Incident Response: Root Cause Analysis with an AI Partner
Walk through a realistic production incident with an AI partner from initial triage through root cause analysis to post-mortem documentation.