Blogs

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

on March 7, 2018 • 12 min read

I’m at the Microsoft MVP Summit in Redmond, Washington this week. This is a great event for learning from the folks building amazing new technology at Microsoft, giving feedback and representing the community, and meeting and learning from other MVPs from around the world.

Continue reading

Forced Plan Confusion: Is_Forced vs Use Plan = True

Forced Plan Confusion: Is_Forced vs Use Plan = True

By Kendra Little on March 5, 2018 • 7 min read

Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.

Continue reading

Why I Love the Automatic Plan Correction Auto-Tuning Feature

Why I Love the Automatic Plan Correction Auto-Tuning Feature

on March 1, 2018 • 3 min read

I’m thrilled to have just finished and published a new course on Automatic Tuning in SQL Server. This feature is available in SQL Server 2017+ and Azure SQL Database.

Update: this course is now open and totally free to all.

Continue reading

Can I Force Multiple Plans for a Query in Query Store?

Can I Force Multiple Plans for a Query in Query Store?

By Kendra Little on February 28, 2018 • 2 min read

Nope.

At least, not right now.

Continue reading

Infographic: Conference Prep for Anxious Folk

Infographic: Conference Prep for Anxious Folk

on February 26, 2018 • 2 min read

I’m honored to be heading to the Microsoft MVP Summit. I really enjoy this conference– it’s not my first time going, so I know the ropes. I’m looking forward to seeing a bunch of old friends AND to connect to lots and lots of new people.

But even though I am familiar with the conference, I have a list of things I do to get ready and prepare. That’s because…

Continue reading

Using YouTube Captions & Transcript to Find Content in a Long Video

Using YouTube Captions & Transcript to Find Content in a Long Video

on February 23, 2018 • 3 min read

This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public.

I attended this session live at the conference, and I remembered that there was one specific part on memory limits in Query Store that I wanted to watch again. I’d jotted down a note about it, but things were flying by and my note was gibberish.

Continue reading

When Should I Use Explicit Transactions for Single Statements?

When Should I Use Explicit Transactions for Single Statements?

on February 22, 2018 • 6 min read

Category: tsql , sql-server

I got a great question about transactions by email recently about transactions.

Continue reading