SQL Server

The 20th Anniversary of the SQL Slammer Worm

SQL Server
8 Comments
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high network traffic related to problems with their SQL Servers. The SQL Slammer worm was infecting Microsoft SQL Servers. Microsoft had known about it and patched the problem 6 months earlier, but people just weren’t patching SQL Server. There…
Read More

Should You Use SQL Server 2022’s GREATEST and LEAST?

SQL Server
2 Comments
If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think the answer is no, but bear with me. It’s Christmas week, right? The news can’t all be bad. GREATEST and LEAST are kinda like MAX and MIN, but instead of taking multiple rows as input, they take multiple columns.…
Read More

#PASSdataCommunitySummit Keynote Day 3 Live Blog

SQL Server
1 Comment
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. Here’s the abstract: Over the 30+ years I’ve been working with SQL Server, I’ve seen an incredible amount of innovation and change. How do we keep up with so many changes and how do we know how…
Read More

SQL Server 2022 Paid Editions Require a Licensing Key.

SQL Server 2022
6 Comments
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: Your choices are: Install a free edition: Evaluation (which times out after 180 days), Developer (which isn’t allowed to be used for production purposes), or Express (which is limited to small databases & hardware resources) Use pay-as-you-go-billing,…
Read More

SQL Server 2022 Release Date: November 16, 2022

SQL Server 2022
7 Comments
Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer edition, Express edition) are available to download starting today. SQL Server 2022 paid editions (Enterprise edition, Standard edition) will be available in Volume Licensing (Enterprise Agreement, Enterprise Agreement Subscriptions) customers starting today, which represents the majority of…
Read More

Office Hours: Read This, Watch This Edition

SQL Server
1 Comment
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other places. Welcome to the Read This, Watch This series of answers. Don’t Blame Anthony: Our developers prefer writing TSQL queries directly in their .NET code rather than writing sprocs and calling them. What are the pros /…
Read More
And it looks bad even in shades.

PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing

Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which doesn’t work out well for widely varying parameters. Here’s a primer for the basics about how it happens. SQL Server 2022 introduces a new feature called Parameter Sensitive Plan optimization. I’m not really sure why Microsoft capitalized…
Read More
Brent Ozar

What’s New in SQL Server 2022 Release Candidate 0: Undocumented Stuff

SQL Server 2022
24 Comments
Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system objects that might be interesting to script developers like you and I, dear reader. New stored procedure sp_get_table_card_est_and_avg_col_len – I assume the “card” refers to statistics and cardinality, not Hallmark. SQL Server has historically struggled with memory…
Read More

SQL Server 2022 Tells You Why A Query Can’t Go Parallel.

Until 2022, when a query couldn’t go parallel, all we got was a really cryptic note in the execution plan properties saying NonParallelPlanReason = CouldNotGenerateValidParallelPlan. But starting with SQL Server 2022, even when I’m running under older compatibility levels: ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 140; /* 2017 */ GO DECLARE @TableVariable TABLE(Total BIGINT); INSERT…
Read More

The Top Feature Requests for SQL Server

SQL Server
31 Comments
If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking for. Here’s a quick rundown of the top requests from feedback.azure.com as voted by the people who cared enough to log in and upvote ’em: 10:…
Read More

Big Data Clusters: Out of Aces

SQL Server
16 Comments
When this feature was announced in 2018, I wrote: <sarcasm> It’s like linked servers, but since they don’t perform well, we need to scale out across containers. </sarcasm> I just didn’t get it, and I continued: I like that Microsoft is making a risky bet, planting a flag where nobody else is, saying, “We’re going…
Read More

The SQL Server Posts You Read the Most in 2021

SQL Server
0
I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to be evergreen (like how a feature works) Posts that provoke discussion and…
Read More

Contest: SQL Server 2022 Needs a Slogan.

SQL Server
309 Comments
Now that Microsoft has announced that SQL Server 2022 is coming, it’s time for us to talk about a shameful truth: SQL Server doesn’t sell itself. Remember when everybody was talking about how MongoDB was Web Scale™? Or when Oracle was Unbreakable™? Even if you were making fun of it, the point was that you…
Read More