Dear SQL DBA

Dear SQL DBA


Latest Episodes

Training Resources for SQL Noobs
June 13, 2018

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are...

Dealing With a Lack of Control as a DBA
May 17, 2018

This week I discuss a question that I've gotten in many forms over the years - a lot of the scenarios are so specific that it's hard to keep them anonymous, but they can be generalized as a bigger problem: how do I deal with being responsible for...

Do DBAs Need College Degrees?
May 03, 2018

Our question this week comes from someone who's excited to be on a healthy career path, building their work experience as a DBA. They're worried: will lacking a college degree block their career growth down the line? I talk about my experience and...

How Do I Prepare for Certification Exams?
April 23, 2018

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

I Want to Work for Myself
April 05, 2018

Our question this week comes from an IT pro who would like to be self-employed. In this episode, I talk about three big things you need to think about to start working for yourself, and two possible paths to get there.

Auto-Tuning and the #1 Mindset Problem I had as a DBA
December 01, 2017

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server? In this week's episode, I talk about why I'm excited about those features rather than afraid of them. Digging into this problem, I...

Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers
November 17, 2017

Are you worried that you talk too fast when you give a speech, talk, or presentation? Is fear being a fast-talker one of the concerns that keeps you from getting started with public speaking? In this episode, I give you simple, practical tips that...

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(
November 07, 2017

In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions -- and there's at least one curse word. I don't talk...

The Death of SQL Server Service Packs
October 05, 2017

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server.

Love and Hate for SSMS
September 28, 2017

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week's episode, I talk about why people have such conflicting feelings about SSMS, and how to work it all out.