Kendra Little

kendra little

Dear SQL DBA: Do DBAs Need a College Degree?

Dear SQL DBA: Do DBAs Need a College Degree?

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)

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

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

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

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

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

Continue reading