Fixes an issue in which nonclustered index corruption occurs and an error message is logged in SQL Server. This issue occurs when you run a complex UPDATE statement against a table in SQL Server…

I love SQL Server, and I'm excited for the release of 2025. I think the query processing keeps getting better, which means your apps are gonna go faster, with less code changes. The AI stuff is a little fluffy, and I don't think time will be kind to it, but I totally understand why Microsoft felt like they had to chase that buzzword.

JAVASCRIPT IS DISABLED. Please enable JavaScript on your browser to best view this site.

SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly. On the SQL Server 2025 side, the two big ones are the new native JSON indexes and the new JSON_CONTAINS function. Let's see their improvements in action. On the .NET 10 side, EF 10 not only supports the new JSON data type, but on databases of compatibility level 170 or higher, EF will automatically migrate JSON data from NVARCHAR(MAX) data types over to JSON the next time you do a migration, as explained in the…

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to: Store the data in an NVARCHAR(MAX) column (because the native JSON datatype didn't arrive until SQL Server 2025) Add a computed column for the specific JSON keys we'll want to query quickly…

Most companies come to us saying, “The SQL Server isn’t fast enough. Help us make it go faster.” They’re kinda surprised when one of the first things we fill out together is a variation of our High…

Is your company hiring for a database position as of November 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. If your company is hiring, leave a…

In the first post in my How to Think Like the Engine series, I started by doing a pretty simple query: But I noted that if you were following along on your computer, you might see a different…

My cruise ship took a detour to Honduras to avoid the hurricane. Let's hang out on the beach and go through your top-voted questions from Here's what we covered: 00:00 Start 00:58 Dopinder: What is your opinion of the Github copilot support in SSMS 22? Is this more beneficial for the DBA or Data Engineer? 03:45 RunningOutofArguments: My company is planning an application that processes incoming emails and wants to store the emails and possibly attachments in SQL Server.

Years ago, when troubleshooting performance, I stumbled across this Microsoft documentation on parallel query processing that says: Certain types of statements cannot be processed in parallel unless…

Here’s how Books Online describes the Max Degree of Parallelism setting: You can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution. And…

Is your company hiring for a database position as of November 2025? Do you wanna work with the kinds of people who read this blog? Let's make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full job description, or the text of it.

You're a developer, database administrator, or DBRE who's been working with SQL Server, Azure SQL DB, and Amazon RDS SQL Server for yeeears. You're jaded. You're confident. You're pretty sure you know what you're doing. You've never taken my Mastering classes because you've been reading my blogs and watching my live streams, and you think you've put the pieces together yourself.

REMASTERED IN HD! Music video by Tom Petty And The Heartbreakers performing Don't Come Around Here No More. (C) 1985 Geffen Records #TomPetty #DontComeAroundHereNoMore #Remastered #Vevo

Welcome to my annual Black Friday sale, and I'm running special doorbuster deals to sweet talking you into taking the plunge quickly. On November 4, the Fundamentals bundle will go up to $295, and the Lifetime bundle will go up to $1,795 - still a deal, but not as good as the doorbuster folks will get:If you want to add on our apps, …

You've been telling yourself, "One of these days, I'll finally take Brent's classes." Get ready, because that day is here: my Black Friday sale runs all November long, and it's my lowest prices all year! SQL Server 2025, 2022, and 2019 all dramatically changed the game for performance tuning. We have more and better tooling than we've ever had before, and there are new places to look when performance goes wrong.

You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.”

This Office Hours episode comes to you from Virgin Voyages' newest cruise ship, the Brilliant Lady, sailing through the Western Caribbean. We were originally scheduled to do the Eastern Caribbean, but Tropical Storm Melissa had other ideas, so they reworked our itinerary at the last minute. Let's take your top-voted questions from Here's what we covered: 00:00…

Ever wonder what it takes to do this stuff behind the scenes? I’ll show you. If you’re thinking about getting started with live streaming or training videos, don’t be intimidated by this setup.…