Comments for Curated SQL

Comment on The Real Ultimate Power of Omni-JOIN by Erik Darling

Erik Darling — Thu, 05 Mar 2026 20:47:44 +0000

Patent pending!

Comment on The State of Vector Indexes in SQL Server 2025 by George Walkey

George Walkey — Thu, 05 Mar 2026 13:40:37 +0000

And Json Indexes too
BrentO said they can be up to 30X the size of the underlying data?
My own benchs show about a 1.8X speedup over varchar(max)
Ho hum

Comment on The Power of Naming Standards by Louis Davidson

Louis Davidson — Tue, 03 Mar 2026 14:14:00 +0000

Love this 🙂 (And I bet it is as true for you as it is for most of us!)

Comment on The Final Month of Azure Data Studio by Aleksander Kowalczyk

Aleksander Kowalczyk — Sun, 15 Feb 2026 23:35:35 +0000

Since I moved from Windows I just couldn’t find an SSMS replacement, even Azure Data Studio didn’t quite make it. Thus I decided to write a new SQL IDE tool – https://jamsql.com – feel free to take a look, it has full parity with Azure Data Studio and is in that scope for free.

Comment on SQL Server Performance Monitor by Erik Darling

Erik Darling — Fri, 13 Feb 2026 23:07:43 +0000

In reply to Kevin Feasel.

I meant at the top!

Comment on SQL Server Performance Monitor by Kevin Feasel

Kevin Feasel — Fri, 13 Feb 2026 14:00:55 +0000

In reply to Erik Darling.

That is what we in the business call a tease, forcing people to go visit your page to grab it from GitHub.

Comment on SQL Server Performance Monitor by Erik Darling

Erik Darling — Fri, 13 Feb 2026 13:18:08 +0000

Jeez, you cut off the best part

Comment on SQL vs Azure Permissions by Kevin Feasel

Kevin Feasel — Wed, 04 Feb 2026 20:15:44 +0000

In reply to Rebecca.

Oh, for sure, the names can be confusing to people who don’t know what they mean because so many of these terms are overloaded. I mean, overloading terms in a Microsoft product? Never!

Comment on SQL vs Azure Permissions by Rebecca

Rebecca — Wed, 04 Feb 2026 19:55:24 +0000

Fair! But ‘Welcome to cloud permissions, where role names describe abstract API scopes rather than user expectations’ didn’t fit. 🙂 Thank you for the repost, Kevin. I need to think on the best revision. Until then…

Contributor does let you contribute — to the management plane (creating, configuring, deleting Azure resources)
Reader does let you read — the management plane metadata

Comment on Thoughts on SELECT * by Louis Davidson

Louis Davidson — Wed, 04 Feb 2026 05:00:05 +0000

I won’t argue with you over select 1 vs select *, I can see that point of view, especially if using tools (or queries) that can’t tell the difference for sure.

The TOP advice is great advice, and probably something g more tools could to for you too. DBeaver does that in the client which is great for ad hoc querying (but it does do it silently so if you need more rows and forget it can be annoying).

Really glad that SSMS is really good at killi g a query these days (and not crashing when it runs out of memory when you do return too many rows).

As always, love your site!