Blogs

Infographic: Conference Prep for Anxious Folk

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

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?

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

Continue reading

New SQLChallenge: Defuse the Deadlock

When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”

This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.

Continue reading

When Were Statistics Last Updated for a Heap?

I got a question last week from a very smart fellow:

How can I tell when statistics were last updated for a heap?

Before I could email him back, I soon got another email in which he answered his own question.

Continue reading

How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)

For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server.

Continue reading

Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions

Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it and just return to it if you ever need it.

Continue reading

Does a Clustered Index Give a Default Ordering?

I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?

Continue reading

Watch my live session: When Partitioning Indexes Hurts Performance (and How to Fix It)

I’m very that my session on table partitioning from the 2017 SQL PASS Summit is being featured as one of the “Best of Summit” videos.

I had a terrific time presenting this session, thanks to everyone in the audience: you were awesome!

You can watch the video here, and follow the link above to see even more great videos from the conference for free.

Continue reading