All Episodes
Dear SQL DBA — 83 episodes
Erik Darling and Kendra Little talk AI, SQL Server 2025, and the Future Is Text Files
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Power BI Performance Tuning with Eugene Meidinger
Automated Deployments and the Art of the Database with Database Michael J Swart
Jer and Kendar Explore Optimized Locking
Advice for Technical Leaders with Alex Robson
Erik Darling on Performance Tuning
What's up with Tech Interviews in 2023? With Jeremiah Peschka.
Data Roles: DBA, DBRE, and Data Engineer
When NOT to choose SQL Server to store your data
Down Tools Week 2020
3 Things That Shouldn't Be Normal in Database Development
Everything I Never Wanted to Know about Collation
The Manager's Guide to Git Training for DBAs
How Do Developers and DBAs Collaborate in a DevOps World?
What a Software Evangelist Does - and Where the Job is Going
DBA Jobs: Threats and Opportunities
DevOps Terms - and Why They Matter to Database Specialists
Employee Agreements & Contracts - Best Practices
Employee Agreements & Contracts for DBAs & Developers - Anti-Patterns
Remembering Robert Davis, DBA Hero
Why Don't You Teach Service Broker?
Training Resources for SQL Noobs
Dealing With a Lack of Control as a DBA
Do DBAs Need College Degrees?
How Do I Prepare for Certification Exams?
I Want to Work for Myself
Auto-Tuning and the #1 Mindset Problem I had as a DBA
Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(
The Death of SQL Server Service Packs
Love and Hate for SSMS
How Do I Analyze a SQL Server Execution Plan?
Do I Need to Master PowerShell?
SQL PASS Summit 2017: Why I'm Excited, and Tips on Attending
How Do You Stay Motivated?
"I faked my resume... now what?"
Interview Advice from the SQL Server Community
Interview Patterns and Anti-Patterns
Which Queries are Causing my Wait Stats?
Removing Query Hints with Plan Guides
Batch Mode Hacks in SQL Server
Should I Get Certified as a DBA?
How Does a DBA Build Confidence After Making Mistakes?
Are Bad Statistics Making My Query Slow?
Index Maintenance and Performance
Lock Timeouts & Memory
Why is my Transaction Log Growing in My Availability Group?
When SQL Server Does NOT Use Write Ahead Logging
Using a Tail Log Backup in a SQL Server Migration
Stack Dumps in SQL Server
WAL: The concept that makes recovery models & backups make sense
Will the Cloud Eat My DBA Job?
Confused by sp_Who2
Should I Learn Full-Text Indexing?
Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes
What's that Garbage in my Execution Plan?
Why You Should Switch in Staging Tables Instead of Renaming Them
Limiting Downtime for Schema Changes in SQL Server
Signs Your SQL Server is Running with Scissors
Why is My Query Faster on the Second Run?
Should I Upgrade to SQL Server 2016?
What's Adaptive Query Processing?
Where Do You Get Your Creativity? (Dear SQL DBA Episode 20)
Should You Rebuild or Reorganize Large Indexes?
Can I Use Statistics to Design Indexes?
Setting up Free Blocking Alerts and Deadlock Monitoring
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key?
Finding Your Voice as a Speaker
Collect and Baseline Wait Statistics
Developer Seeks DBA Career
Teach Yourself SQL Server Performance Tuning
Altering an INT Column to a BIGINT
Should I Automate Windows Updates for SQL Server?
Why Upgrades can Cause Performance Regression
Max Degree of Confusion
How to Level Up Your DBA Career
Index Usage Stats Insanity
Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery
Outside the Big SAN Box
Next Door to Derpton
Lost in Performance Troubleshooting
Bleeding in Edgevile