“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 podcast where I answer questions from (and about) SQL Server DBAs.

Got a Question?

That’s awesome! Ask your question here.

Subscribe to Dear SQL DBA

Pick your favorite way to get the content:

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

54) Slowing Down Your Motor Mouth – Presentation Tips for Fast Talkers

53) I Thought I Was An Introvert. Turns Out I Was Anxious as F*@*!

52) The Death of SQL Server Service Packs

51) Love and Hate for SSMS

50) How Do I Analyze a SQL Server Execution Plan?

49) Do I Need to Master PowerShell?

48) SQL PASS Summit 2017: Why I’m Excited, and Tips on Attending

47) How Do You Stay Motivated?

46) “I faked my resume… now what?”

45) Interview Patterns & Anti-Patterns (This episode is also part of #tsql2sday)

44) Finding Queries that Cause Wait Stats in SQL Server

43) Removing Query Hints with Plan Guides

42) Batch Mode Hacks for Rowstore Queries in SQL Server

41) Should I Get Certified as a DBA?

40) How Does a DBA Build Confidence After Making Mistakes?

39) Are Bad Statistics Making My Query Slow?

38) Index Maintenance & Performance

37) Lock Timeouts & Memory

36) Why is My Transaction Log Growing in My Availability Group?

35) When SQL Server Does NOT Use Write Ahead Logging

34) Using a Tail Log Backup in a SQL Server Migration

33) Stack Dumps in SQL Server (the “Taking a Dump” episode)

32) Write Ahead Log: The Concept that Makes Recovery Models and Backups Make Sense

31) Will the Cloud Eat My DBA Job?

30) Confused by sp_who2

29) Should I Learn Fulltext Indexing?

28) Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes

27) What’s that Garbage in My Execution Plan?

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