CXPACKET and CXCONSUMER Waits: AI-Assisted Diagnosis
Use AI to diagnose CXPACKET/CXCONSUMER waits, tune MAXDOP, and avoid setting MAXDOP=1 globally.
Eliminating Legacy Cursors: An AI-Assisted Deep Dive
A deep dive into decomposing complex legacy cursors with AI using the bulk-first, loop-for-side-effects pattern.
Mapping Stored Procedure Dependencies with AI
Use AI to map stored procedure dependencies, table access, and circular references across your codebase.
Dissecting Dynamic SQL with AI
Feed complex dynamic SQL to AI for execution flow explanation, injection risk analysis, and parameterized rewrites.
Compatibility Level Audit: Finding Databases Stuck in the Past
Audit database compatibility levels with AI and find databases missing intelligent query processing improvements.
Mapping Availability Group Topology with AI
Query and document your AG topology with AI covering replica roles, sync states, and misconfiguration detection.