Blogs

Fake News about Auto Parameterization/Simple Parameterization

Fake News about Auto Parameterization/Simple Parameterization

By Kendra Little on May 4, 2018 • 4 min read

I saw a question on Twitter today that took me down a little rabbit hole. And when I go down rabbit holes, I like to blog about it! There’s a TLDR at the bottom of this post if you’re short on time.

Continue reading

Dear SQL DBA: Do DBAs Need a College Degree?

Dear SQL DBA: Do DBAs Need a College Degree?

By Kendra Little on May 3, 2018 • 25 min read

Our question this week comes from a database administrator who’s excited to be on a healthy career path, building their work experience, getting certified, and working with a more experienced mentor.

But they’re worried: will lacking a college degree block their career growth down the line?

Continue reading

Dear SQL DBA: How Do I Prepare for Certification Exams? (video)

Dear SQL DBA: How Do I Prepare for Certification Exams? (video)

By Kendra Little on April 23, 2018 • 25 min read

Category: dear-sql-dba

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

Continue reading

Query Store Cleanup Can be Part of a Blocking Chain

Query Store Cleanup Can be Part of a Blocking Chain

By Kendra Little on April 18, 2018 • 3 min read

Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated test system– and that’s how I learned this.

I left a bit of blocking open on my test VM, and forgot about it.

Continue reading

Dear SQL DBA Q&A: A Poorly Indexed ISV Database

Dear SQL DBA Q&A: A Poorly Indexed ISV Database

By Kendra Little on April 16, 2018 • 4 min read

At a recent conference, two speakers reminded me of something important: when you put effort into learning something or helping folks, don’t simply put your words in private emails or post-it notes on your desk. Whenever possible, blog it as well. It can help other people, and it can also help you remember it in the future!

Continue reading

A Case of Inconsistent Wait Stats and Query Duration

A Case of Inconsistent Wait Stats and Query Duration

By Kendra Little on April 11, 2018 • 7 min read

You know how they say “don’t sweat the small stuff”?

That’s good advice for lots of things, but when it comes to query tuning - I WANT TO KNOW MORE when something is inconsistent. I just can’t let it go. I go total X-Files: The Truth Is Out There.

Continue reading

Free Webcast: DBA vs Memory Settings

Free Webcast: DBA vs Memory Settings

By Kendra Little on April 11, 2018 • 1 min read

Join me in two weeks for a really fun free webcast.

Continue reading