Dear SQL DBA - podcast cover

Dear SQL DBA

Kendra Little•littlekendra.com
Technology
News
Tech News
Kendra Little's podcast discussing database performance tuning, software development, and working with data.
Last refreshed: ⓘ
Follow this podcast in the Metacast mobile app to refresh it and see new episodes.
Follow on
Apple Podcasts
Spotify
RSS
YouTube
Overcast
Pocket Casts
Episodes.fm
Download Metacast podcast app
Podcasts are better in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episodes

Should I Upgrade to SQL Server 2016?

Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard and Web Editions.

Nov 17, 2016•24 min

What's Adaptive Query Processing?

Learn about new features to speed up SQL Server queries. Kendra talks about automatic index tuning and speculates about Adaptive Query Processing.

Nov 03, 2016•24 min

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

As a database administrator or developer, you'll get into trouble fast if you try to force all your code and processes into a database shaped hole. You have to be creative when you problem solve -- and when you communicate! So how do you cultivate creativity?

Oct 20, 2016•22 min

Should You Rebuild or Reorganize Large Indexes?

The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? Learn the pros and cons of each command and other options.

Oct 13, 2016•23 min

Developer Seeks DBA Career

A C# developer wants to be a DBA, but is having a hard time landing a job. Should they take a pay cut and go for a Junior level job? Or could there be another path?

Aug 18, 2016•15 min

Teach Yourself SQL Server Performance Tuning

You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yourself performance tuning and prepare yourself to land and succeed in job interviews.

Aug 11, 2016•20 min

Altering an INT Column to a BIGINT

You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.

Aug 04, 2016•21 min

Max Degree of Confusion

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.

Jul 14, 2016•20 min

How to Level Up Your DBA Career

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?

Jul 07, 2016•27 min

Index Usage Stats Insanity

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.

Jun 30, 2016•23 min

Outside the Big SAN Box

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

Jun 16, 2016•36 min

Next Door to Derpton

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

Jun 09, 2016•14 min

Bleeding in Edgevile

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.

May 25, 2016•21 min
← Prev
Hosted on Libsyn
For the best experience, listen in Metacast app for iOS or Android