Attempting to Force a Narrow Plan on an Update with Query Store
Category:
query-store
When you force a plan with Query Store, you may not get what you expect. Here’s an example.
Kalen Delaney and Inspiration for Adventure
Category:
tsql-programming
This post is part of TSQL Tuesday, a monthly blog party. You’re welcome to join in this party: if you’d like email notifications of future topics, here’s how to set them up.
This month’s topic is “Folks Who Have Made a Difference”, by Ewald Cress.
The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Wait
Category:
columnstore-indexes
A funny thing happened on the way to my filtered nonclustered columnstore demo recently…
It was taking forever to create my demo index.
Things I Learned from Speaker Idol 2017 at the SQL PASS Summit
Category:
database-administration
I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching presentations and giving feedback on them is that you learn a lot about speaking by watching sessions and crafting your feedback.
![I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)](/images/I-thought-I-was-an-introvert.jpg)
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)
Category:
career
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.)
SQL PASS Summit 2017 Day 2 - Keynote Notes and Ideas
Category:
indexing
This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system.
SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories
Category:
indexing
Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going to see some great presenters this morning.