2 min read
Welcome — and what to expect here
- personal
- meta
Hi, I'm Keith. This is the first post on a site I've meant to start for a while.
I'm a SQL Server DBA. I work with a farm of instances — not one or two boxes, but enough that doing anything by hand thirty times in a row stops being "tedious" and starts being "irresponsible." So I lean on PowerShell.
I call myself a PowerShell-first DBA, and that's mostly the lens I'll be writing through here.
What you'll find here
- Scripts — patterns I reach for over and over: inventorying instances, running ad-hoc queries fleet-wide, validating backups, checking jobs.
- Notes from the trenches — things I learned the hard way managing many instances at once. The kind of thing SSMS doesn't show you until it's too late.
- Opinions — when the GUI is fine, when it lies to you, and when it's time to put the mouse down and write a function.
Why a blog at all
Mostly because I keep solving the same problems and forgetting the solutions. Writing them down forces me to understand them well enough to explain them — and the next time I need that exact script, I'd rather find it on my own site than dig through a chat log.
If any of it helps you too, even better.