Misleading SSMS Connection

Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....

Advent of Code 2022

Foreword
Advent of Code is an annual event in which participants solve a series of coding puzzles. It typically begins on December 1 and runs through the end of the...

Default event_file path for Extended Events

Foreword
Have you ever wondered where the .xel file is saved when you create a new Extended Event session and don’t specify the full path (just the file name)?
Like so:

Well,...

T-SQL Tuesday #156 - Wrap Up

Foreword
Thank you everyone for participating! There is a total of 15 submissions and thanks to them, I’ve widened my perspective.
The order of the posts is chosen at random.
Greg Moore
Contribution|Blog|Twitter
Greg...

Testing the code (T-SQL Tuesday #156)

Foreword
Even though I picked the question, I struggled to answer it.
Following my train of thought - production code should be of the highest quality. To enforce quality, we use...

Production Code (T-SQL Tuesday #156)

Background
T-SQL Tuesday - the brainchild of Adam Machanic and coordinated by Steve Jones (blog|Twitter) is a monthly blog party on the second Tuesday of each month. And I will...

Scary Scalar Functions - Part Four: Your Environment

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Part Four: Your Environment

Foreword
In the previous posts, we have learned why Scalar Functions (UDFs) are bad for parallelism...

My Toolbox - Everything

Foreword
Not everything in the general sense, but a tool called Everything by voidtools (Download link). Usually, I have to make this distinction when googling.
No matter how great is my...

Unexpected Blocking during the Indexed View Creation

The problem
There was a need to make changes to a table with an Indexed View. Since Indexed Views must be created with SCHEMABINDING, the View must be dropped and...

My Toolbox - Greenshot

Foreword
A picture is worth a thousand words. I use screenshots daily, whether it’s to share results, how-to tutorials, point out mistakes or create memes.
None of the tools I’ve tried...