Podcasts Technology Dear SQL DBA
Dear SQL DBA

Dear SQL DBA

73 episodes

Description: Kendra Little answers burning questions from SQL Server Database Administrators -- from dealing with SAN Administrators to handling index rebuilds, she helps DBAs improve their jobs.

Podcasts

Down Tools Week 2020

Published: Aug. 5, 2020, 4:22 p.m.
Duration: 9 minutes 52 seconds

Listed in: Technology

3 Things That Shouldn't Be Normal in Database Development

Published: July 23, 2020, 9:28 a.m.
Duration: 28 minutes 12 seconds

Listed in: Technology

Everything I Never Wanted to Know about Collation

Published: July 16, 2020, 11:29 a.m.
Duration: 13 minutes 53 seconds

Listed in: Technology

The Manager's Guide to Git Training for DBAs

Published: July 8, 2020, 5:23 p.m.
Duration: 19 minutes 2 seconds

Listed in: Technology

How Do Developers and DBAs Collaborate in a DevOps World?

Published: June 12, 2019, 11:59 p.m.
Duration: 41 minutes 7 seconds

Listed in: Technology

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

Published: Jan. 29, 2019, 12:59 a.m.
Duration: 21 minutes 25 seconds

Listed in: Technology

DBA Jobs: Threats and Opportunities

Published: Jan. 17, 2019, 9:51 p.m.
Duration: 34 minutes 36 seconds

Listed in: Technology

DevOps Terms - and Why They Matter to Database Specialists

Published: Oct. 2, 2018, 9:39 p.m.
Duration: 19 minutes 31 seconds

Listed in: Technology

Employee Agreements & Contracts - Best Practices

Published: Aug. 29, 2018, 3:22 p.m.
Duration: 23 minutes

Listed in: Technology

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

Published: Aug. 11, 2018, 1 a.m.
Duration: 31 minutes 20 seconds

Listed in: Technology

Remembering Robert Davis, DBA Hero

Published: Aug. 1, 2018, 10:38 p.m.
Duration: 19 minutes 34 seconds

Listed in: Technology

Why Don't You Teach Service Broker?

Published: July 19, 2018, 12:31 a.m.
Duration: 23 minutes 17 seconds

Listed in: Technology

Training Resources for SQL Noobs

Published: June 13, 2018, 10:28 p.m.
Duration: 29 minutes 10 seconds

Listed in: Technology

Dealing With a Lack of Control as a DBA

Published: May 18, 2018, 12:29 a.m.
Duration: 34 minutes 44 seconds

Listed in: Technology

Do DBAs Need College Degrees?

Published: May 3, 2018, 1 p.m.
Duration: 31 minutes 6 seconds

Listed in: Technology

How Do I Prepare for Certification Exams?

Published: April 23, 2018, 2 p.m.
Duration: 29 minutes 31 seconds

Listed in: Technology

I Want to Work for Myself

Published: April 5, 2018, 10:42 p.m.
Duration: 31 minutes 32 seconds

Listed in: Technology

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

Published: Dec. 1, 2017, 11:49 p.m.
Duration: 18 minutes 10 seconds

Listed in: Technology

Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers

Published: Nov. 17, 2017, 10 p.m.
Duration: 18 minutes 13 seconds

Listed in: Technology

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

Published: Nov. 8, 2017, 12:49 a.m.
Duration: 43 minutes 46 seconds

Listed in: Technology

The Death of SQL Server Service Packs

Published: Oct. 5, 2017, 9 p.m.
Duration: 11 minutes 32 seconds

Listed in: Technology

Love and Hate for SSMS

Published: Sept. 28, 2017, 10 p.m.
Duration: 17 minutes 21 seconds

Listed in: Technology

How Do I Analyze a SQL Server Execution Plan?

Published: Sept. 22, 2017, 1 p.m.
Duration: 26 minutes 18 seconds

Listed in: Technology

Do I Need to Master PowerShell?

Published: Sept. 12, 2017, 1 p.m.
Duration: 9 minutes 6 seconds

Listed in: Technology

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

Published: Sept. 7, 2017, 1 p.m.
Duration: 18 minutes 25 seconds

Listed in: Technology

How Do You Stay Motivated?

Published: Aug. 31, 2017, 7:13 p.m.
Duration: 14 minutes 51 seconds

Listed in: Technology

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

Published: Aug. 24, 2017, 7:23 p.m.
Duration: 13 minutes 34 seconds

Listed in: Technology

Interview Advice from the SQL Server Community

Published: Aug. 17, 2017, 1 p.m.
Duration: 8 minutes 25 seconds

Listed in: Technology

Interview Patterns and Anti-Patterns

Published: Aug. 8, 2017, 1 p.m.
Duration: 15 minutes 38 seconds

Listed in: Technology

Which Queries are Causing my Wait Stats?

Published: May 25, 2017, 1 p.m.
Duration: 34 minutes 45 seconds

Listed in: Technology

Removing Query Hints with Plan Guides

Published: May 18, 2017, 1 p.m.
Duration: 29 minutes 49 seconds

Listed in: Technology

Batch Mode Hacks in SQL Server

Published: May 11, 2017, 1 p.m.
Duration: 30 minutes 33 seconds

Listed in: Technology

Should I Get Certified as a DBA?

Published: May 4, 2017, 1 p.m.
Duration: 17 minutes 30 seconds

Listed in: Technology

How Does a DBA Build Confidence After Making Mistakes?

Published: April 27, 2017, 1 p.m.
Duration: 19 minutes 32 seconds

Listed in: Technology

Are Bad Statistics Making My Query Slow?

Published: April 20, 2017, 1 p.m.
Duration: 35 minutes 2 seconds

Listed in: Technology

Index Maintenance and Performance

Published: April 13, 2017, 1 p.m.
Duration: 28 minutes 45 seconds

Listed in: Technology

Lock Timeouts & Memory

Published: April 6, 2017, 1 p.m.
Duration: 19 minutes 17 seconds

Listed in: Technology

Why is my Transaction Log Growing in My Availability Group?

Published: March 30, 2017, 1 p.m.
Duration: 29 minutes 45 seconds

Listed in: Technology

When SQL Server Does NOT Use Write Ahead Logging

Published: March 23, 2017, 1 p.m.
Duration: 23 minutes 28 seconds

Listed in: Technology

Using a Tail Log Backup in a SQL Server Migration

Published: March 16, 2017, 1 p.m.
Duration: 13 minutes 32 seconds

Listed in: Technology

Stack Dumps in SQL Server

Published: March 9, 2017, 2 p.m.
Duration: 20 minutes 57 seconds

Listed in: Technology

WAL: The concept that makes recovery models & backups make sense

Published: March 2, 2017, 2 p.m.
Duration: 18 minutes 4 seconds

Listed in: Technology

Will the Cloud Eat My DBA Job?

Published: Feb. 23, 2017, 2 p.m.
Duration: 28 minutes 29 seconds

Listed in: Technology

Confused by sp_Who2

Published: Feb. 16, 2017, 4 p.m.
Duration: 14 minutes 38 seconds

Listed in: Technology

Should I Learn Full-Text Indexing?

Published: Feb. 9, 2017, 2 p.m.
Duration: 18 minutes 19 seconds

Listed in: Technology

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

Published: Feb. 2, 2017, 2 p.m.
Duration: 26 minutes 45 seconds

Listed in: Technology

What's that Garbage in my Execution Plan?

Published: Jan. 26, 2017, 2 p.m.
Duration: 17 minutes 46 seconds

Listed in: Technology

Why You Should Switch in Staging Tables Instead of Renaming Them

Published: Jan. 19, 2017, 11 a.m.
Duration: 11 minutes 24 seconds

Listed in: Technology

Limiting Downtime for Schema Changes in SQL Server

Published: Dec. 15, 2016, 11 a.m.
Duration: 27 minutes 44 seconds

Listed in: Technology

Signs Your SQL Server is Running with Scissors

Published: Dec. 1, 2016, 11 a.m.
Duration: 22 minutes 56 seconds

Listed in: Technology

Why is My Query Faster on the Second Run?

Published: Nov. 24, 2016, 11 a.m.
Duration: 25 minutes 31 seconds

Listed in: Technology

Should I Upgrade to SQL Server 2016?

Published: Nov. 17, 2016, 11 a.m.
Duration: 23 minutes 59 seconds

Listed in: Technology

What's Adaptive Query Processing?

Published: Nov. 3, 2016, 4 p.m.
Duration: 23 minutes 49 seconds

Listed in: Technology

Where Do You Get Your Creativity? (Dear SQL DBA Episode 20)

Published: Oct. 20, 2016, 10 a.m.
Duration: 22 minutes 26 seconds

Listed in: Technology

Should You Rebuild or Reorganize Large Indexes?

Published: Oct. 13, 2016, 10 a.m.
Duration: 23 minutes 23 seconds

Listed in: Technology

Can I Use Statistics to Design Indexes?

Published: Oct. 6, 2016, 10 a.m.
Duration: 19 minutes 43 seconds

Listed in: Technology

Setting up Free Blocking Alerts and Deadlock Monitoring

Published: Sept. 29, 2016, 10 a.m.
Duration: 20 minutes 53 seconds

Listed in: Technology

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

Published: Sept. 22, 2016, 10 a.m.
Duration: 17 minutes 2 seconds

Listed in: Technology

Finding Your Voice as a Speaker

Published: Sept. 1, 2016, 10 a.m.
Duration: 11 minutes 37 seconds

Listed in: Technology

Collect and Baseline Wait Statistics

Published: Aug. 25, 2016, 10 a.m.
Duration: 17 minutes 24 seconds

Listed in: Technology

Developer Seeks DBA Career

Published: Aug. 18, 2016, 10 a.m.
Duration: 15 minutes 8 seconds

Listed in: Technology

Teach Yourself SQL Server Performance Tuning

Published: Aug. 11, 2016, 10 a.m.
Duration: 19 minutes 49 seconds

Listed in: Technology

Altering an INT Column to a BIGINT

Published: Aug. 4, 2016, 5:07 p.m.
Duration: 20 minutes 39 seconds

Listed in: Technology

Should I Automate Windows Updates for SQL Server?

Published: July 28, 2016, 10 a.m.
Duration: 16 minutes 49 seconds

Listed in: Technology

Why Upgrades can Cause Performance Regression

Published: July 21, 2016, noon
Duration: 27 minutes 5 seconds

Listed in: Technology

Max Degree of Confusion

Published: July 14, 2016, 10 a.m.
Duration: 19 minutes 54 seconds

Listed in: Technology

How to Level Up Your DBA Career

Published: July 7, 2016, 10 a.m.
Duration: 26 minutes 53 seconds

Listed in: Technology

Index Usage Stats Insanity

Published: June 30, 2016, 10 a.m.
Duration: 23 minutes 18 seconds

Listed in: Technology

Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery

Published: June 23, 2016, 10 a.m.
Duration: 29 minutes 25 seconds

Listed in: Technology

Outside the Big SAN Box

Published: June 16, 2016, 10 a.m.
Duration: 36 minutes 20 seconds

Listed in: Technology

Next Door to Derpton

Published: June 9, 2016, 10 a.m.
Duration: 14 minutes 5 seconds

Listed in: Technology

Lost in Performance Troubleshooting

Published: June 2, 2016, 10 a.m.
Duration: 25 minutes 23 seconds

Listed in: Technology

Bleeding in Edgevile

Published: May 25, 2016, 7:03 p.m.
Duration: 21 minutes 24 seconds

Listed in: Technology