Dear SQL DBA
Latest Episodes
Training Resources for SQL Noobs
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
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?
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?
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
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
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
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 #@*(
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
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
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.