Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)

A database transaction log is expanding, even though the DBA is running log backups and doesn’t see an open transaction? What’s going on with this Availability Group? Links to timestamps in this 30 minute episode if you want to skip ahead 00:49 What’s new @ SQL Workbooks 03:22 Info on SQLPASS Summit 2017 Content Survey […]


New weekly newsletter: a SQL Server quiz, poll or cartoon each week

I’ve started up a weekly newsletter! Sign up, and each Tuesday you’ll get a link to a quick SQL Server quiz or poll in your inbox. Most weeks there will be a cartoon thrown in there, too. I’ll also give you the scoop on what’s new over at SQLWorkbooks.com. You’ll be the first to know about […]


When SQL Server Does NOT Use Write Ahead Logging (Dear SQL DBA Episode 35)

A few episodes ago, I talked about how learning about Write Ahead Logging was a light bulb moment for me, and helped me learn tons of concepts about backups and recovery. This week, we talk about when SQL Server turns things upside down and doesn’t use write ahead logging: and what it has to do […]


Time for an Interview: What accomplishment are YOU most proud of?

Last week I answered a set of fun interview questions from Mohammad Darab. One question that he asked really jumped out at me: What are you most proud of doing/accomplishing for the SQL Server community so far in your career? I looked at this question and realized that it has been a while since I’ve asked […]


Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)

When you migrate a database, it can be useful to prove that you moved all the data and didn’t miss any transactions. Learn how to use a tail log backup in a migration scenario. Watch this week’s 13 minute video. Subscribe to my YouTube channel, or check out the audio podcast to listen anywhere, anytime. When you restore a […]


Stack Dumps in SQL Server (Dear SQL DBA Episode 33)

Learn what a Stack Dump is in SQL Server and watch a demo where I cause a stack dump against a test SQL Server instance under load. Learn how to find information about stack dumps on your SQL Server, and how to escalate them when required. Watch this week’s 21 minute video, and subscribe to […]