3.1-Transactions-vs-Batch-Requests-square

SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)

Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing. The Transactions/sec counter has big blind spots Watch a quick 5 minute demo showing that the SQL Statistics\Batch Requests/sec counter sees more of your workload than the Databases(_Total)\Transactions/sec counter does. Want more perfmon tips for SQL Server? Check out my YouTube […]

41-Should-I-Get-Certified-square

Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)

Find out if getting certified will help you land an entry level DBA job. If you do want to get certified, get Kendra’s tips on preparing for the exam in this 17 minute episode. Option 1: Listen to or download the audio podcast episode You can listen on the run by subscribing to the podcast on […]

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 […]