What Reaches Outside Your Database? sys.dm_db_uncontained_entities

· by · in

Every database likes to pretend it is self-contained. Then you restore it onto another instance and discover the stored procedure that queries a sister database, the synonym pointing at a linked server, the login-mapped user…

Part 2: When the AI Code Reviewer Finds Bugs the Optimizer Didn’t

· by · in , ,

In Part 1, I walked through an interactive session with GitHub Copilot CLI where we optimized a production T-SQL function – cutting memory grants by 80% and logical reads by 73%. I thought we were…

Can GitHub Copilot Optimize Your T-SQL? I Put It to the Test

· by · in , ,

I’ve been curious about how well AI coding assistants handle real-world T-SQL optimization – not textbook examples, but production code with system DMVs, Availability Groups, and windowed functions. So I pointed GitHub Copilot CLI at…

Missing Index DMVs have a limited capacity. How can I work around that?

· by · in ,

The system dynamic-management-views for tracking index suggestions are limited to displaying 500 indexes at most. In a busy system with either a lot of databases or a lot of tables, this can be substantially limiting….