senior-dba-characteristics-square

What’s the Difference between a Junior and Senior DBA?

  I got a great question from a student recently: In your opinion, where is the distinction between Junior DBA and Senior DBA? I’ve always worked on small teams, so sometimes it’s hard to tell where I fit. This question makes so much sense to me. On small teams, or where you have funky job […]

Kendra-Updating-Statistics-Hangouts

Managing Statistics in SQL Server for DBAs (videos)

Want to learn more about managing statistics updates in SQL Server? Watch my free 27 minute presentation on managing statistics: You can also watch 12 minutes of audience Q&A on statistics from when I presented this on a live Hangout on Air. Questions include: Should I create single column statistics for non-leading key columns in […]

Aristotle

Updating Statistics in SQL Server: Maintenance Questions & Answers

I’ve been asked a lot of questions about updating statistics in SQL Server over the years. And I’ve asked a lot of questions myself! Here’s a rundown of all the practical questions that I tend to get about how to maintain these in SQL Server. I don’t dig into the internals of statistics and optimization in this […]

Google-Hangout-On-Air-Theme-Dino

Free Webcast! Updating Statistics in SQL Server: Questions and Answers

What are statistics? How often should you update them? Do you need a trace flag to make this easier? What are duplicate statistics, and do you need to drop them? Join me for a live Hangout on Monday, April 18 at 8:30 AM Pacific / 11:30 AM Eastern to up your maintenance game! Register for the […]

"Yeah, so... the SQL Server keeps crashing..."

Change Management Template for SQL Server DBAs and Deveopers

I learned to do Change Management from some really smart people. When I first became a DBA, I worked at a small software company where changes were released with increasing frequency over the years. Our team was really great at planning and deploying changes, because we constantly worked at improving. Good Change Management makes your team […]

plan-zoom

New SSMS Features: Click + Drag and Click + Mouse Scroll

The best features are the ones that you use all the time. SQL Server 2016 Management Studio’s bringing improvements in navigating around execution plans. Click + Mouse Scroll: Zooming! You can now make your plans bigger and smaller with this combo. It will zoom into the region where you have the mouse. Click + Drag lets […]

Index-Formulas-Problems-Solutions-SQL-Saturday-Huntington-Beach

Links and Notes from “SQL Server Index Formulas”, Huntington Beach

I gave a day long session, “SQL Server Index Formulas, Problems and Solutions” in Huntington Beach, CA on April 1. The class was a great group of students, and we had a lively discussion and lots of questions. Here’s a topic we diagrammed in class, as well as links to extra resources What are the […]

Query-Store-Force-Plan-But-Not-The-One-I-Want

Can I Force A Hinted Plan with Query Store in SQL Server 2016?

SQL Server 2016’s Query Store feature promises to be better than Plan Guides ever were. The Query Store lets  you track query performance, collect execution plans, and force a specific plan if you notice that a query is sometimes fast, and sometimes slow. But what if we want to hint a query? Can Query Store […]