Part 2: When the AI Code Reviewer Finds Bugs the Optimizer Didn’t
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
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…
RegEx Replace in SSMS
Refactoring Transact-SQL code can be a time-consuming and frustrating affair for the trusty code-reviewing Database Developer. This post shows several techniques I use to refactor code via the little-understood RegEx Replace functionality found in SQL…
Cleanup WSUS Synchronization Events
Cleanup Windows Server Update Services Synchronization History with this script. Windows Server Update Services provides a great way to cleanup things like old computers, unneeded updates, and update files from the Windows Server Update Services…
Directory Listing in SSMS
Get a complete directory listing of the contents of folders and subfolders with the below script. This is useful if you don’t have direct access to the server operating system where SQL Server is installed,…
Search SSRS Reports for Keywords
Microsoft’s SQL Server Reporting Services, colloquially known as SSRS, provides a great way to expose data from SQL Server in human-consumable form, typically via a web site. Generally, it’s a good idea to use a…