Required Testing for Installing SQL Server Cumulative Updates and Service Packs

Microsoft recently updated their policies and recommendations for installing cumulative updates. Now, in the header for each cumulative update, it reads: Microsoft recommends ongoing, proactive installation of CUs as they become available:SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence. Historical data shows that a significant number… (Read Me)
Me in my MidnightDBA shirt in 2010

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 titles, how do you tell how “Senior” your skills are? Here are the “levels” of a DBA: Junior… (Read Me)

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 an index? What is asynchronous statistics update? What are these statistics with… (Read Me)

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 post. If you’re interested in that, head on over and read the fahhhbulous… (Read Me)

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 event by clicking ‘Yes’ on the event page. On Monday, watch the live stream of the event here. I have the Q&A feature… (Read Me)
"Yeah, so... the SQL Server keeps crashing..."

Change Management Template for SQL Server DBAs and Deveopers

“Yeah, so… the SQL Server keeps crashing…” 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 smarter.… (Read Me)

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 you move the plan This is really handy for moving right to left.As you can see from the GIF, I’m… (Read Me)

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 costs/overhead of each nonclustered B tree index? (List made by the class)Inserts, updates, deletes –… (Read Me)