Dear SQL DBA cover image

Dear SQL DBA

Latest episodes

undefined
Nov 17, 2016 • 24min

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.
undefined
Nov 3, 2016 • 24min

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.
undefined
Oct 20, 2016 • 22min

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?
undefined
Oct 13, 2016 • 23min

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.
undefined
Oct 6, 2016 • 20min

Can I Use Statistics to Design Indexes?

Should you look at automatically created statistics on  your tables in SQL Server to help you design better indexes?
undefined
Sep 29, 2016 • 21min

Setting up Free Blocking Alerts and Deadlock Monitoring

What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?
undefined
Sep 22, 2016 • 17min

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

Should you always index your foreign keys? What if you index them, and then the index never gets used?
undefined
Sep 1, 2016 • 12min

Finding Your Voice as a Speaker

Learn what it's like to find and develop your voice as a technical speaker in this week's episode.
undefined
Aug 25, 2016 • 17min

Collect and Baseline Wait Statistics

What are the best tools to collect and baseline wait statistics? Should you write your own?
undefined
Aug 18, 2016 • 15min

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?  

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode