Dear SQL DBA cover image

Dear SQL DBA

Latest episodes

undefined
Jul 19, 2018 • 23min

Why Don't You Teach Service Broker?

I've gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I'm planning to make any courses on Service Broker. In this episode, I talk about why I personally haven't become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.
undefined
Jun 13, 2018 • 29min

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 at: https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/
undefined
May 18, 2018 • 35min

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 things that I can't fully control? DBAs have huge responsibilities, so this is a common, frustrating scenario. In this episode, I talk about a few times that I've experienced this in my own life, what techniques didn't work, and what strategies were more effective.
undefined
May 3, 2018 • 31min

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 also check out current job listings to answer the question.
undefined
Apr 23, 2018 • 30min

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.
undefined
Apr 5, 2018 • 32min

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.
undefined
Dec 1, 2017 • 18min

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 share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.
undefined
Nov 17, 2017 • 18min

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've used to successfully improve the way I give presentations. Four years ago, I got frustrated feedback from listeners who had a hard time keeping up with my mouth; now I get congratulations that the pace was great.
undefined
Nov 8, 2017 • 44min

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 tech in this episode. (Don't worry, there's more of that coming in future weeks.)
undefined
Oct 5, 2017 • 12min

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.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode