Dear SQL DBA

Dear SQL DBA
By Kendra Little
About this podcast
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.
In this podcast

Kendra Little

DBA

SQL

questions

Machine generated. There may be errors. Report errors to us.

Podcasts like "Dear SQL DBA"   · View all

By Manuel Wenk, Oliver Vogel, Thomas Krause
By Carlos L Chacon
By Matan Yungman, Guy Glantser
By For the Love of Data
Latest episodes
Dec. 1, 2017
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server? In this week's episode, I talk about why I'm excited about those features rather than afraid of them. Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.
Nov. 17, 2017
Are you worried that you talk too fast when you give a speech, talk, or presentation? Is fear being a fast-talker one of the concerns that keeps you from getting started with public speaking? In this episode, I give you simple, practical tips that I've used to successfully improve the way I give presentations. Four years ago, I got frustrated feedback from listeners who had a hard time keeping up with my mouth; now I get congratulations that the pace was great.
Nov. 8, 2017
In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions -- and there's at least one curse word. I don't talk tech in this episode. (Don't worry, there's more of that coming in future weeks.)
Oct. 5, 2017
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server.
Sept. 28, 2017
People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week's episode, I talk about why people have such conflicting feelings about SSMS, and how to work it all out.
Sept. 22, 2017
A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.
Sept. 12, 2017
As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.
Sept. 7, 2017
I'll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week's episode, I share why I'm excited about going, and why I've purchased a seat for a pre-conference session. (Spoiler: pre-cons are awesome!) I also give my tips on how to get the MOST value out of a big conference like the PASS Summit.
Aug. 31, 2017
Over the years, readers have asked me: "How do you stay motivated?" Sticking with a learning plan, blogging, or becoming a public speaker isn't easy. In this episode I share how I think about motivation and what keeps me going.
Aug. 24, 2017
This week's question from a reader: how do I deal with interview questions asking about real-world scenarios when I've faked three years of experience on my resume?