“Dear SQL DBA”: a weekly podcast for SQL Server DBAs and developers

Don't worry, someone else has already asked a weirder question.

Don’t worry, someone else has already asked a weirder question.

“Dear SQL DBA” is a free weekly podcast where I answer questions from (and about) SQL Server DBAs.

Ask a Question

Send me your question here. And thank you!

Subscribe

There’s lots of options to catch the episodes. The episodes are designed to be “listenable.” I publish to YouTube as well as podcast providers. There’s no on-screen demos, so feel free to listen while you drive, walk your dog, fold your laundry, or have adventures.

Pick your favorite way to get the content:

I publish show notes for each episode in a blog post with a detailed show outline and clickable links referenced in the episode (scroll on down for a list). So if you like to listen while making dinner and you want to look up a link at work the next morning, you can always hit up this page to find the episode notes.

Please review Dear SQL DBA on iTunes

Thank you for your support, if you have the time to submit a review! To do so:

  • Click here to get to the iTunes page
  • Click “view in iTunes”
  • Click “Write a Review”

Links to episode blog posts – show notes, links, and embedded YouTube videos

26) Switch in Staging Tables Instead of Renaming Them

25) Limiting Downtime for Schema Changes

24) Is Your SQL Server Running with Scissors?

23) Why is My Query Faster the Second Time It Runs?

22) Should I Upgrade to SQL Server 2016?

21) What is Adaptive Query Processing?

20) Where Do You Get Your Creativity?

19) Should I Rebuild or Reorganize Large Indexes?

18) Can I use Statistics to Design Indexes?

17) Setting up Free Blocking Alerts and Deadlock Monitoring

16) Which is Worse: An Unused Index, or an Un-Indexed Foreign Key?

15) Finding Your Voice as a Speaker

14) Collect and Baseline Wait Statistics

13) Developer Seeks DBA Career

12) Teach Yourself SQL Server Performance Tuning

11) Altering an INT Column to a BIGINT

10) Should I Automate My Windows Updates?

9) Why an Upgrade can Cause Performance Regressions 

8) MAXDOP of Confusion – Setting Max Degree of Parallelism, Cost Threshold for Parallelism, and a Brief Intro to Soft NUMA

7) How to Level Up Your DBA Career

6) Index Usage Stats Insanity – sys.dm_db_index_usage_stats

5) Fail Over Again, Fail Better – Preparing for Disaster Recovery

4) Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server

3) Next Door to Derpton – When Your Fellow DBA is a Danger to Databases

2) Lost in Performance Troubleshooting – Kendra’s Perf Triage for SQL Server

1) Bleeding In Edgeville – When Upgrades Come Too Fast