Press "Enter" to skip to content

Curated SQL Posts

Thoughts on Open-Sourcing SQL Server

Brent Ozar has some thoughts:

At the PASS Summit last week in Seattle, I was having a discussion with a few people who’d moved on from managing SQL Server over to working with PostgreSQL. They were talking about the advantages of open source – and there are certainly many – but it prompted me to ask, “If Microsoft open-sourced SQL Server, would that actually fix any of SQL Server’s problems?”

Read on for Brent’s take, and definitely check out Dave Wentzel’s comment. Unfortunately, I do think Dave is right about the massive challenge of open-sourcing an existing code base in a world where a variety of language models can bang away at vulnerabilities in the code and where the process for fixing bugs takes a lot longer than the process of finding bugs.

Leave a Comment

What Was New for SQL Developers in 2012

Jeff Taylor starts a retrospective:

In my session, “What’s New in SQL Server for the Developer”, I always start with a show of hands, and usually the room has everything from SQL Server 2000 all the way up to 2025, and a few folks running Azure SQL. That’s a big spread. It’s also exactly why I built the session the way I did. A lot of us are still writing T-SQL like it’s 2008, even though the engine underneath has had better tools for years.

So I’m turning my session into a series, one post per version, with the examples from my slides. Today we start where the session starts: SQL Server 2012.

I love this approach. I have a very similar talk to Jeff’s, though, for the sake of time, I have my starting point as “2016 and a couple of things that were really important in 2012.”

Leave a Comment

Group by Schema in SSMS

Jess Pomfret finds an option:

Folks, how have I missed this? I was at FabCon & SQLCon in Barcelona a few weeks ago, when I discovered (in a totally unrelated session!) that you can now group by schema in SQL Server Management Studio (SSMS). This little gem makes navigating certain databases so much easier. If you’ve ever worked in a database with hundreds of objects across many schemas, you’re going to love this.

Click through to see how.

Leave a Comment

Fuzzy String Matching now GA

Abhiman Tiwari promotes a feature:

MICROSFT isn’t MICROSOFT. MARHTA isn’t MARTHA. INV-1O08 isn’t INV-1008. To an equality check, each pair is simply different. To your business, each is a near miss worth catching.

Today, fuzzy string matching is generally available in Microsoft SQL. EDIT_DISTANCE tells you MICROSFT is one edit from MICROSOFT. JARO_WINKLER_SIMILARITY scores MARTHA and MARHTA at 96 out of 100. It all runs in T-SQL, right where your data lives, with no external libraries, models, or custom code.

As of CU11, this is now GA in SQL Server 2025.

Leave a Comment

IS DISTINCT FROM

Andy Brownsword tries out a shortcut:

Comparisons involving NULL-able values and columns are an early learning experience. I recently stumbled upon a relatively new way to handle these which I thought would be interesting T-SQL to share.

I think the two reasons you don’t see this in production are as follows. First, it requires a recent version of SQL Server, 2022 or later. A lot of the T-SQL code that went into training language models was for older versions of SQL Server. Second, because there’s no performance difference, people don’t spend a lot of time changing existing code to use this syntax. It’s a bit clearer in terms of intent, but otherwise doesn’t move the needle for people.

Leave a Comment

Finding NTLM Connections to SQL Server

Andreas Wolter shares advice and a script:

In short: I recommend finding out now which connections to your SQL Servers still use NTLM, and fixing them before Windows disables NTLM by default. Most of them fall back to NTLM silently, because of a missing SPN, a connection by IP address or an alias. SQL Server itself has no setting for this – the work is in Active Directory, DNS and client connection strings.

Click through for several reasons why users might be connecting via the old and deprecated protocol, and what to do about it.

Leave a Comment

Load Testing Azure SQL Hyperscale

Reitse Eskens cranks up the speed:

My previous post on load testing Azure SQL covered the Business Critical tier; let’s move to the one that is getting a lot of attention lately: Hyperscale. And no, you’re not the only one with Scooter’s Hyper Hyper song playing in the back of your mind.

Before we get into the tests, I need a moment to explain a few things about this tier. No, it’s not as complicated as the DTU models, but there are a few things to keep in mind.

Read on for those things to keep in mind, as well as how this performs compared to other options like Azure SQL Database Business Critical.

Leave a Comment

Digging into the Azure SQL Database Container

Anthony Nocentino takes a peek under the hood:

Today at Ignite, Microsoft announced the public preview of the Azure SQL Database container. The line in the announcement that jumped out at me was this one: the container runs natively on x64 and ARM64, including Apple Silicon. If you’ve been following along with my posts on running SQL Server on Apple Silicon and the AVX issue under Rosetta, you know I’ve been waiting a long time to type that sentence.

So I did what any reasonable person would do on announcement day. I pulled the image, started it up next to a SQL Server 2025 CU11 container on my M4 Pro, and started taking both of them apart. I wanted to know two things. First, how did Microsoft get a SQL engine running natively on ARM64? Is it emulation? A brand new engine? Second, how does a container on my laptop pretend to be a managed cloud service?

In this post, I’m going to show you what’s inside the image, how Microsoft built it for ARM64, and how a control plane running inside the container makes it behave like Azure SQL Database. Then we’ll compare it to SQL Server 2025 on database defaults and performance. Let’s go.

Click through to see what Anthony found.

Leave a Comment

What Happens when You Enable Private Link on a Fabric Workspace

Gilbert Quevauvilliers performs a test:

In this blog post I am going to explain what happens when you enable Private Link on a Fabric Workspace.

I am currently working with an Enterprise customer who is implementing Private Link Workspaces, and I found that there is a lot of information required to understand how to get it successfully planned and implemented for Microsoft Fabric.

A lot of the information below is from a real world implementation based off of the Microsoft Learn Documents and working directly in Microsoft Fabric.

Click through to see what changes and what the limitations look like, including a variety of images to help explain things.

Leave a Comment

What’s New at Ignite 2026

Arun Ulag tells us what’s new:

Over the past year, my conversations with customers have changed. A year ago, the question was which model to choose. Now it’s how to put agents to work on the processes that run the business, and how to trust them to do it.

With the same frontier models available to everyone, the advantage comes from what no one else has: your context. It’s how your business runs, what your people know, and the systems and data you’ve spent years building. That’s your IQ. It’s your intellectual property, so it should stay yours, and it should work wherever your people and agents do. Our job is to make every layer beneath your agents better, from the infrastructure that runs them and the estate they act on to the apps they power and the business context that tells them how your company works.

If you’re all-in on agentic AI, you’ll find a lot to be happy about. If not, well…

Leave a Comment