Dear SQL DBA
Summary: 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.
- Visit Website
- RSS
- Artist: Kendra Little
- Copyright: Kendra Little 2016
Podcasts:
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.)
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.
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.
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.
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.
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.
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.
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?
In this episode, I talk about three articles that I can't stop thinking about: "Playing the Third Party Recruiter Game", by Adam Machanic - http://sqlblog.com/blogs/adam_machanic/archive/2017/08/08/playing-the-third-party-recruiter-game-t-sql-tuesday-093.aspx "I Hate Interviews", by Rob Sewell - https://sqldbawithabeard.com/2017/08/08/i-hate-interviews-tsql2sday/ "Learning to say 'No'" by Mark Broadbent - https://tenbulls.co.uk/2017/08/08/learning-to-say-no/
Hear the story of an interview where my dreams were crushed - and what I learned about interviewing from the experience.
Which Queries are Causing my Wait Stats?
Removing Query Hints with Plan Guides
Batch Mode Hacks in SQL Server
Should I Get Certified as a DBA?
How Does a DBA Build Confidence After Making Mistakes?