Inspecting SQL Server TLS Certificates Without Credentials
If you’ve ever needed to check the TLS certificate on a SQL Server instance — whether it’s expired, misconfigured, missing SANs, or just plain self-signed — you’ve probably had to connect with SSMS, run some…
Teaching GitHub Copilot Your T-SQL Coding Standards
If you’re a DBA or database developer using GitHub Copilot CLI, you’ve probably noticed it generates functional T-SQL — but not necessarily T-SQL that matches your team’s coding standards. After several weeks of working with…
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…