Blogs

What is the Difference between a Junior and Senior DBA?

What is the Difference between a Junior and Senior DBA?

on April 26, 2016

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.

Continue reading

Managing Statistics in SQL Server for DBAs (videos)

Managing Statistics in SQL Server for DBAs (videos)

on April 21, 2016

Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.

Continue reading

Updating Statistics in SQL Server: Maintenance Questions & Answers

Updating Statistics in SQL Server: Maintenance Questions & Answers

on April 18, 2016

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.

Continue reading

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

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

on April 14, 2016

About This Webcast

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!

Continue reading

Change Management Template for SQL Server DBAs and Developers

Change Management Template for SQL Server DBAs and Developers

on April 12, 2016

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.

Continue reading

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

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

on April 7, 2016

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.

Continue reading

Links and Notes from SQL Server Index Formulas, Huntington Beach

Links and Notes from SQL Server Index Formulas, Huntington Beach

on April 5, 2016

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.

Continue reading