Compatibility Level Audit: Finding Databases Stuck in the Past
Audit database compatibility levels with AI and find databases missing intelligent query processing improvements.
Diagnosing Parameter Sniffing with AI
Use AI to analyze execution plan XML, identify sniffed values, and evaluate RECOMPILE, OPTIMIZE FOR, and PSP optimization.
Eliminating Cursors with AI-Generated Set-Based Alternatives
Feed a cursor-based procedure to AI and get a set-based rewrite with honest advice about when cursors are still right.
Writing Window Functions with an AI Partner
AI agents write complex window functions faster than you can look up the frame clause syntax.
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.
Wait Stats, Deadlocks, and Blocking Chains: AI-Assisted Diagnosis
Use AI to interpret wait stats, analyze deadlock graphs, and diagnose blocking chains. Turn raw diagnostic data into actionable remediation steps.