Technical Blog
Notes on SQL Server performance troubleshooting, AWS architecture, PowerShell automation, and AI-assisted DBA work. More articles are on the way.
Cell-Level Encryption in SQL Server: What I Use for HIPAA/PCI Columns, and the Key Recovery Problem That Bit Us
A practical walkthrough of cell-level encryption for protecting sensitive columns like name, email, and phone number - plus the real problem I ran into managing encryption keys across 300+ databases, and how newer SQL Server versions finally fixed it.
Tracking Database Growth Over Time: The Daily Snapshot Method I Use
How I log daily database file sizes into a history table to spot abnormal growth trends before they turn into a disk-space emergency - plus where I'd take this further with window functions, autogrowth event tracking, and proper alerting.
Shrinking a Data File in Chunks Without Locking Everything Up
A safer way to reclaim disk space from a large .mdf file when you're in an emergency and can't add storage - shrinking gradually in small steps instead of one large DBCC SHRINKFILE call, plus the cleanup work it creates afterward.
Reading SQL Server Wait Statistics Without Guessing
A practical starting point for using wait statistics to figure out what SQL Server is actually waiting on, instead of guessing based on CPU or disk graphs alone.