Dear SQL DBA

50 episodes listed below

Listen to the show on

SQL Server shop talk for its victims and accomplices.

The gist

Kendra Little hosts Dear SQL DBA with guests such as Erik Darling, Eugene Meidinger and Michael J Swart. The talk runs from query tuning and optimized locking to Power BI and automated deployments, and the banter is quick and silly while the opinions under it stay specific enough to act on.

PRESS PLAY

Find your next episode

All episodes

About Dear SQL DBA

Dear SQL DBA is a podcast and YouTube show hosted by Kendra Little, and it sounds like colleagues talking shop with the camera on. The openings are part of the entertainment. There is a flubbed hello, a name that fails to appear on screen on cue, and a promise of a 'super official' welcome. Little has pitched the show to the victims and the accomplices of SQL Server, and elsewhere she welcomes anyone who is only database curious. Erik Darling appears in more than one recent episode and introduces himself as someone who makes SQL Server faster in exchange for money. Their conversations mix product judgement with running gags. When the two rate performance tuning techniques, automatic plan correction draws sharp criticism. It runs experiments on queries on top of Query Store, forgets what it learned after a failover or a statistics update, and starts over. It gets one participation star and a plea to leave the plans alone. Another Darling episode, 'Erik Darling and Kendra Little talk AI, SQL Server 2025, and the Future Is Text Files', includes a detour into buying a set of AI prompts. What arrived was a bunch of text files, and it was judged worth it anyway. Guests take the show beyond the engine. The Power BI episode with Eugene Meidinger explains why star schema, with fact tables surrounded by dimension tables, suits how that engine works. It also mentions a service designed to compress data on its own and ask less indexing work of its users. The conversation with Michael J Swart turns to automated deployments and whether to build or buy the tooling. The case for writing it in-house comes with a car metaphor: call the automobile association and someone else does the repair, but write it yourself and you are the mechanic, even if it breaks down more often. Jeremiah, introduced as a software engineer, a fellow database nerd and Little's husband, joins for optimized locking. They start by pretending the topic is SQL REST endpoints, then get to what taking fewer locks could save in memory for a company running databases as a cloud service. That episode signs off by calling itself a glimpse of how database nerds spend a Friday afternoon. The leadership conversation with Alex Robson steps sideways from databases. Little introduces him as a former Stack Overflow colleague who was director of engineering there while she was a technical product manager, and adds that he is very good at Destiny. Some sessions were streamed, and the goodbyes include thanks to people watching in the chat. The listener gets candid, specific opinions on SQL Server features, and the jokes around them never quite take over.

Made for: Suits a listener who works with SQL Server, Power BI or database deployments and wants candid opinions delivered as a relaxed, joking conversation rather than a formal tutorial.

What sets it apart: Its verdicts on SQL Server features are blunt and specific, like the single star it gives automatic plan correction, while the tone stays playful and self-mocking. The guest conversations also go beyond the engine into Power BI, deployment tooling and technical leadership.

In their own words

Kendra Little's podcast discussing database performance tuning, software development, and working with data.

Why you'd press play

Automatic plan correction earns a participation star; your SQL Server grievances have found company.

Press play if you want

  • your favorite database feature judged by what it actually fixes, with a little affectionate heckling
  • a Power BI schema explanation that follows the filter cascades all the way down
Read the full recommendation in PlayNext →
SQL Server performance tuningQuery Store and automatic plan correctionoptimized lockingPower BI performance and star schemaautomated database deploymentsAI tools and promptstechnical leadership

Talks about

Best episodes of Dear SQL DBA

Short reviews from the PlayNext desk, based on the episodes we processed.

Erik Darling and Kendra Little talk AI, SQL Server 2025, and the Future Is Text FilesDec 8, 2025

A grounded Dear SQL DBA conversation about AI prompts, text files, and SQL Server 2025.

Kendra Little and Eric Darling ground the AI conversation in the small realities of software work: writing prompts, asking AI to improve those prompts, and Little's $35 purchase of a prompt bundle that turned out to be plain text files.

Erik Darling and Kendra Little Rate SQL Server Perf Tuning TechniquesMay 20, 2024

A one-star verdict turns automatic plan correction into a sharp question about SQL Server control.

Kendra Little and Eric Darling give SQL Server automatic plan correction the kind of skeptical performance review that DBAs tend to value. Their one-star score lands because the feature is built on Query Store, tests whether queries improve or regress, and can forget what it…

Power BI Performance Tuning with Eugene MeidingerJan 15, 2024

A grounded tour of Power BI schemas, cascading filters, and the two engines inside VertiPaq.

Power BI performance tuning gets a practical model-level frame here, with Kendra Little and Eugene Meidinger tying report speed to the shape of the underlying model.

Automated Deployments and the Art of the Database with Database Michael J SwartSep 26, 2023

A grounded look at database automation, migration safety, and the real cost of owning the tools.

Database deployment becomes more interesting here because the hard part is not just creating automation, but owning what it does afterward. On Dear SQL DBA, Kendra Little and Michael J.

Jer and Kendar Explore Optimized LockingSep 4, 2023

A pair of database specialists make Azure SQL optimized locking feel like a guided pass through unfamiliar blocking terrain.

Optimized locking gets a focused database-feature discussion as Kendra Little and Jeremiah Peshka walk through its place in the SQL Server engine, currently only in Azure SQL Database.

Podcasts like Dear SQL DBA

Episodes

  1. 1

    Erik Darling and Kendra Little talk AI, SQL Server 2025, and the Future Is Text Files

    Hidden gem

    Eric Darling says AI is useful when he treats it like a junior developer, not when he expects expert SQL answers.

    Dec 8, 2025·46m·3 clips
  2. 2

    Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

    Hidden gem

    Dear SQL DBA has Kendra Little and Eric Darling rating SQL Server tuning techniques like `OPTION (RECOMPILE)`, Query Store hints, Resource Governor, and page compression.

    May 20, 2024·1h 5m·5 clips
  3. 3

    Power BI Performance Tuning with Eugene Meidinger

    Hidden gem

    Dear SQL DBA talks with Eugene Meidinger and Kendra Little about Power BI performance tuning across SQL, Power Query, and DAX.

    Jan 15, 2024·54m·4 clips
  4. 4

    Automated Deployments and the Art of the Database with Database Michael J Swart

    Hidden gem

    Dear SQL DBA pairs Kendra Little with Michael J.

    Sep 26, 2023·1h 5m·4 clips
  5. 5

    Jer and Kendar Explore Optimized Locking

    Hidden gem

    Kendra Little and Jeremiah Peshka break down Azure SQL Database's optimized locking, which replaces many row and page locks with transaction ID locks.

    Sep 4, 2023·29m·2 clips
  6. 6

    Advice for Technical Leaders with Alex Robson

    Alex Robson says leadership at Stack Overflow required deliberate communication and investment in relationships, not just visible coding.

    Aug 25, 2023·1h·2 clips
  7. 7

    Erik Darling on Performance Tuning

    Eric Darling says developer-friendly shortcuts such as reusable functions and `IS NULL` filters can make SQL Server’s work harder.

    Aug 21, 2023·53m·2 clips
  8. 8

    What's up with Tech Interviews in 2023? With Jeremiah Peschka.

    On DearSQL DBA, host Kendra Little and software developer Jeremiah Peschka examine tech interviews amid layoffs and job churn.

    Aug 11, 2023·29m·2 clips
  9. 9

    Data Roles: DBA, DBRE, and Data Engineer

    Kendra Little, in a live-streamed Dear SQL DBA episode, maps the differences between DBA, DBRE and data engineer roles using a trash metaphor from Eric Darling's reply that "I'm not sure that anyone knows." She contrasts a DBA tuning an individual "dumpster" with a DBRE automating many thousands of instances and a data engineer working in cloud data lakes with tools like Databricks, Snowflake and DBT.

    Aug 4, 2023·25m·1 clip
  10. 10

    When NOT to choose SQL Server to store your data

    Jun 22, 2023·14m
  11. 11

    Down Tools Week 2020

    Aug 5, 2020·10m
  12. 12

    3 Things That Shouldn't Be Normal in Database Development

    Kendra Little uses the first three chapters of Gene Kim's The Unicorn Project, where developer Maxine finds new contractors who 'can't even check in code yet', to frame three gaps in database development.

    Jul 23, 2020·28m·2 clips
  13. 13

    Everything I Never Wanted to Know about Collation

    Jul 16, 2020·14m
  14. 14

    The Manager's Guide to Git Training for DBAs

    Jul 8, 2020·19m
  15. 15

    How Do Developers and DBAs Collaborate in a DevOps World?

    Jun 12, 2019·41m
  16. 16

    What a Software Evangelist Does - and Where the Job is Going

    Jan 29, 2019·21m
  17. 17

    DBA Jobs: Threats and Opportunities

    Jan 17, 2019·35m
  18. 18

    DevOps Terms - and Why They Matter to Database Specialists

    Oct 2, 2018·20m
  19. 19

    Employee Agreements & Contracts - Best Practices

    Aug 29, 2018·23m
  20. 20

    Employee Agreements & Contracts for DBAs & Developers - Anti-Patterns

    Aug 11, 2018·31m
  21. 21

    Remembering Robert Davis, DBA Hero

    Aug 1, 2018·20m
  22. 22

    Why Don't You Teach Service Broker?

    Jul 19, 2018·23m
  23. 23

    Training Resources for SQL Noobs

    Jun 13, 2018·29m
  24. 24

    Dealing With a Lack of Control as a DBA

    Kendra Little discusses dealing with lack of control as a database administrator and promotes her live SQL seminars.

    May 18, 2018·35m
  25. 25

    Do DBAs Need College Degrees?

    May 3, 2018·31m
  26. 26

    How Do I Prepare for Certification Exams?

    Apr 23, 2018·30m
  27. 27

    I Want to Work for Myself

    Apr 5, 2018·32m
  28. 28

    Auto-Tuning and the #1 Mindset Problem I had as a DBA

    Dec 1, 2017·18m
  29. 29

    Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers

    Nov 17, 2017·18m
  30. 30

    I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(

    Nov 8, 2017·44m
  31. 31

    The Death of SQL Server Service Packs

    Oct 5, 2017·12m
  32. 32

    Love and Hate for SSMS

    Sep 28, 2017·17m
  33. 33

    How Do I Analyze a SQL Server Execution Plan?

    Sep 22, 2017·26m
  34. 34

    Do I Need to Master PowerShell?

    Sep 12, 2017·9m
  35. 35

    SQL PASS Summit 2017: Why I'm Excited, and Tips on Attending

    Sep 7, 2017·18m
  36. 36

    How Do You Stay Motivated?

    Aug 31, 2017·15m
  37. 37

    "I faked my resume... now what?"

    Aug 24, 2017·14m
  38. 38

    Interview Advice from the SQL Server Community

    Aug 17, 2017·8m
  39. 39

    Interview Patterns and Anti-Patterns

    Aug 8, 2017·16m
  40. 40

    Which Queries are Causing my Wait Stats?

    May 25, 2017·35m
  41. 41

    Removing Query Hints with Plan Guides

    Kendra Little explains how to remove detrimental query hints from SQL Server code without modifying the application.

    May 18, 2017·30m
  42. 42

    Batch Mode Hacks in SQL Server

    May 11, 2017·31m
  43. 43

    Should I Get Certified as a DBA?

    May 4, 2017·18m
  44. 44

    How Does a DBA Build Confidence After Making Mistakes?

    Apr 27, 2017·20m
  45. 45

    Are Bad Statistics Making My Query Slow?

    Apr 20, 2017·35m
  46. 46

    Index Maintenance and Performance

    Apr 13, 2017·29m
  47. 47

    Lock Timeouts & Memory

    Apr 6, 2017·19m
  48. 48

    Why is my Transaction Log Growing in My Availability Group?

    Mar 30, 2017·30m
  49. 49

    When SQL Server Does NOT Use Write Ahead Logging

    Mar 23, 2017·23m
  50. 50

    Using a Tail Log Backup in a SQL Server Migration

    Mar 16, 2017·14m