“Can I just test it in Prod?” Build a Local SQL Server 2022 AG with Docker and PowerShell We all know developing/testing in Prod is frowned upon, and none of us have ever done it. The temptation is always there, Read More » October 22, 2026
“Is anyone still using this database?” How to find stagnant databases “Is anyone still using this database?” I have been asked this question a surprising number of times lately. The answer Read More » July 14, 2026
Why use PowerShell when you can use T-SQL? Why use PowerShell? I’ve lost count of how many times I have been asked this question. Most of the time, Read More » March 11, 2026
Track Database File Sizes with PowerShell: A Quick Guide for DBAs Database files (mdf, nds, ldfs, etc.) can get out of hand quickly and easily, leading to issues down the road. Read More » December 29, 2025
A Common Misconception About SQL Server Backups The misconception about SQL Server backups: file-level backups are the same thing or as good as a native SQL Server backup of the database. Read More » July 14, 2025