Production Database Administration

Welcome to the DBA Training Plan.

Foreword: 8 years ago, I launched an email series with a 6-Month DBA Training Plan. I sent one email per week, bringing people up to speed on the most important topics that nobody taught ’em along the way. It’s hard to believe it’s been 8 years! This month, I’m revisiting the emails, updating their content,…
Read More

How to Log Active Queries with sp_BlitzWho

Queries are running when you’re not around. They’re wreaking havoc – maybe they’re filling up your TempDB, or causing blocking, or flushing your buffer pool out. When I wanna see what queries are running, I run sp_BlitzWho: That shows me who’s running the query, what it’s been waiting on over time, memory grants, blocking, and…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}