Kendra Little

Dear SQL DBA

Technology EN ↓ 83 episodes

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

Author

Kendra Little

Episodes

Max Degree of Confusion 14.07.2016 19:54

Learn how to configure the Max Degree of Parallelism and Cost Threshold for Parallelism settings in SQL Server - and about how SQL Server 2014 SP2 and SQL Server 2016 change the way that SQL Server automatically configures some SQL Servers with lots of cores.

How to Level Up Your DBA Career 07.07.2016 26:53

You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

Index Usage Stats Insanity 30.06.2016 23:18

SQL Server's "index usage stats" dynamic management view is incredibly useful-- but does it tell you what you THINK it tells you? Kendra explains the quirks of how sys.dm_db_index_usage_stats works, as well as why she thinks the information is so valuable.

Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery 23.06.2016 29:25

You're setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?

Outside the Big SAN Box 16.06.2016 36:20

You believe that your expensive SAN is slowing down the SQL Server. How can you make your case without making enemies?

Next Door to Derpton 09.06.2016 14:05

What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?

Lost in Performance Troubleshooting 02.06.2016 25:23

The SQL Server is slow, what should you do? Kendra shares her strategy for performance troubleshooting.

Bleeding in Edgevile 25.05.2016 21:24

Kendra Little answers a question about early adoption of SQL Server, discusses why testing in production isn't necessarily crazy, and recommends how to handle requests to upgrade your SQL Server to use new features.