40-Confidence-After-Mistakes-square-screenshot

How Does a DBA Build Confidence After Making Mistakes? (Dear SQL DBA Episode 40)

Ever had a database change go horribly wrong? It can feel awful in the moment, then eat away at your confidence for days afterward. In this 20 minute episode Kendra gives you practical steps that help you cope with change over the course of your DBA career. Option 1: Listen to or download the audio […]

39-Dear-SQL-DBA-Thumbnail-Square

Are Bad Statistics Making My Query Slow? (Dear SQL DBA Episode 39)

An important query is suddenly slow. Is it because statistics are out of date? This is tricky to figure out, and updating statistics right away can make troubleshooting even harder. Learn how to use query execution plans to get to the heart of the question and find out if stats are really your problem, or […]

38-Index-Maintenance-and-Performance-square

Index Maintenance and Performance (Dear SQL DBA Episode 38)

They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index maintenance have harmed performance? In this 29 minute episode… 00:50 Thinking about plan freezing in Query Store and multi-team process 03:15 This week’s question about index maintenance and query performance Subscribe to my YouTube channel, or check out […]

ssms-shortcuts-new-session-use-database-execute-query-show-hide-results

Poster in the works: SSMS Shortcuts Explained by Cats

I had a fun highlight recently that I wanted to share. I’ve got a new poster idea I’m crazy about. SQL Server Management Studio Shortcuts, Explained by Cats I’m working through this iteratively: I’m doing drawings for select lessons in my free course, SSMS Shortcuts & Secrets. Here’s the first two that I’ve done: When I get […]

37-Lock-Timeouts-and-Memory-Square

Lock Timeouts & Memory (Dear SQL DBA Episode 37)

The dev server got bogged down during a deployment and lock timeouts were everywhere. Was the perfmon counter way off about how much memory was being used just for locks? In this 19 minute episode… 00:33 What’s new @ SQL Workbooks: Down the Rabbit Hole 03:00 This week’s question about lock timeouts & memory in […]

time-tracking-technology

Reviving Healthy Work Habits: Toggl and Weekly Highlights

As I’ve gotten back into the swing of a more-or-less regular work schedule after the initial launch of SQL Workbooks, I’ve revived some of my favorite work habits and free tools. Tracking time with Toggl I’m a big fan of the time-tracking tool Toggl.  Their tools are easy to use, and even the free version […]