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

Nope.

At least, not right now.

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

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

Auto-Tuning and the #1 Mindset Problem I Had as a DBA

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why I’m excited about those features rather than afraid of them.

Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.

Continue reading

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)

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.)

Continue reading

New Free Webcasts for November and December 2017

I’ve Just Scheduled a Whole Batch o’ Free Webcasts!

Webcasts are held on Thursdays at 9 AM Pacific / noon Eastern / 4 pm UTC.

Here’s the upcoming slate of topics:

• Oct 5 – RCSI and Snapshot Isolation
• Oct 19 – Pressure Testing Memory
• Oct 26 – What’s REALLY in That Index?
• Nov 9 – Filtered Columnstore Indexes
• Nov 16 – Defragging: Reorg or Rebuild?
• Nov 30 – In-Memory Indexes & Isolation
• Dec 7 – Indexing for Windowing Functions
• Dec 14 – Serializable & Repeatable Read

I can’t wait to put together these presentations, and I hope to see you on Thursdays!

Continue reading