SQL Server

The Top Feature Requests for SQL Server

Last Updated May 5, 2022

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:…

Big Data Clusters: Out of Aces

Last Updated March 1, 2022

Brent Ozar

SQL Server

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…

The SQL Server Posts You Read the Most in 2021

Last Updated December 20, 2021

Brent Ozar

SQL Server

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…

SQL Server 2022 Slogan Contest Winners

Last Updated November 17, 2021

Brent Ozar

SQL Server 2022

Last week, I challenged y’all to come up with slogans for SQL Server 2022. I have to confess that when I came up with the idea for that blog post, I thought y’all would take it seriously. I thought you’d come up with ideas that were meant to show off Microsoft’s hard work. I should…

Is Microsoft SQL Server 2022 a Big Release?

Last Updated November 11, 2021

Brent Ozar

SQL Server 2022

Normally when y’all post questions here on Pollgab, I let ’em pile up and I eventually do an Office Hours webcast where I talk through my answers. I check in on the list every couple of days just out of curiosity, though, and one of ’em jumped right out at me. The question, posed by…

Contest: SQL Server 2022 Needs a Slogan.

Last Updated November 8, 2021

Brent Ozar

SQL Server

307

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…

What’s New in SQL Server 2022

Last Updated November 4, 2021

Brent Ozar

SQL Server, SQL Server 2022

Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s a 13-minute video from Bob Ward explaining and demoing some of the new features: The new features include: Failover back/forth from SQL Server 2022 and Azure SQL DB Managed Instances, including restoring versionless databases from Azure SQL…

SQL ConstantCare® is Now Available in the UK & EU.

Last Updated September 16, 2021

Brent Ozar

SQL Server

Earlier this year, we opened up training class sales to the EU and UK. Now, we’re taking it to the next level: my monitoring service SQL ConstantCare® is available in the EU and UK, too! With SQL ConstantCare®, you install an app on your desktop that checks in with your SQL Servers once a day, sends…

Get Ready: SQL Server 2016 Mainstream Support Ends in One Week.

Last Updated July 6, 2021

Brent Ozar

SQL Server 2016

Brent Ozar, bearer of bad news Who am I kidding? You’re not really going to get ready, but let’s talk about this anyway. SQL Server 2016 mainstream support ends Tuesday, July 13, 2021. According to Microsoft’s SQL Server support policy, that means from here on out, Microsoft will only deliver security patches, not functional, performance,…

What’s the Buggiest Feature in SQL Server?

Last Updated May 5, 2021

Brent Ozar

Execution Plans, SQL Server

Not the one you like the least, or the one that requires the most work. What’s the one that you can’t use because it’s just flat out busted? For me, it’s SSMS’s Live Query Statistics, aka live query plans. The idea is so awesome – you click Query, Include Live Query Statistics, and then when you…

If You Could Only Say One Thing About Writing Good Queries…

Last Updated May 4, 2021

Brent Ozar

SQL Server

If you could give just one piece of advice about writing good queries, what would it be? I asked Twitter yesterday because I wanted to make sure I didn’t miss anything in a new training course I’m working on, and the replies were fantastic. Here were some of my favorites: As you’re writing a query,…

Your Top 10 Ideas for SQL Server

Last Updated April 13, 2021

Brent Ozar

SQL Server

You’ve submitted thousands of bug reports and feature requests at feedback.azure.com, and here’s what you’ve voted as the top 10 requests right now: #10: MIN/MAX as non-aggregate functions. PostgreSQL and Oracle have the GREATEST/LEAST functions that work like COALESCE, allowing you to pass in a list of values and get the top or lowest. Sounds…

Where I See Databases Going in the Next 10 Years

Last Updated March 18, 2021

Brent Ozar

Architecture, SQL Server

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. I’m going to generalize a little by decade here to keep things simple. In 1990-2000, databases were mostly tied to specific development languages. When you…

It’s Been Decades. Why Don’t Databases Manage Themselves Yet?

Last Updated March 20, 2021

Brent Ozar

SQL Server

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. A much younger me When I started working with databases, we had to: Provision the right CPUs and memory Provision the right storage throughput and…

What’s New & Undocumented in SQL Server 2019 Cumulative Update 9

Last Updated February 15, 2021

Brent Ozar

SQL Server 2019

Last week’s SQL Server 2019 Cumulative Update 9 snuck in some undocumented things. We got two new DMVs for Always On Availability Groups, sys.dm_hadr_cached_replica_states and sys.dm_hadr_cached_database_replica_states. They have a subset of data from other AG DMVs: I sure wish I could point you to the documentation or KB article on those. But we have no…

What Is the SQL Server CEIP Service?

Last Updated October 7, 2020

Brent Ozar

SQL Server

The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You can’t disable it during installation: it shows up in your services list whether you want it or not. You know it’s high quality when they can’t…

SQL Server Cumulative Update Documentation Is Going Downhill, Fast

Last Updated August 7, 2020

Brent Ozar

SQL Server 2019

Microsoft appears to have given up on patch documentation, and that’s kinda scary for a product that costs thousands of dollars per core. Yesterday’s SQL Server 2019 Cumulative Update 6 launched with the worst documentation I’ve seen yet. It’s been steadily going downhill, but CU6 represents a new low. For years, we’d complained that the…

Sit Down. We Need to Talk About Your Scalar Functions.

Last Updated June 25, 2020

Brent Ozar

Development, SQL Server 2019

Thanks for coming today. I apologize for baiting you in here with a picture of toilet paper. That’s not even in the US – that’s from my Iceland trip, before I flew back here to the US. Look, we all make mistakes. That’s not the point of this post. You see, I’ve been reading this…

[Video] What Percent Complete Is That Index Build?

Last Updated March 24, 2020

Brent Ozar

Index Maintenance, SQL Server 2017, Videos

SQL Server 2017 & newer have a new DMV, sys.index_resumable_operations, that show you the percent_completion for index creations and rebuilds. It works, but…only if the data isn’t changing. But of course your data is changing – that’s the whole point of doing these operations as resumable. If they weren’t changing, we could just let the operations…

That's it, I'm rolling back to SQL Server 6.5

Breaking News: SQL Server 2019 CU2 Breaks Agent.

Last Updated March 4, 2020

Brent Ozar

Breaking News, SQL Server 2019

That’s it, I’m rolling back to SQL Server 6.5 You reported it here in the comments, and over at SQLServerUpdates, and in this DBA.StackExchange.com question. The official word is in: yep, SQL Server 2019 Cumulative Update 2 breaks Agent jobs on some servers, causing them not to run. That official word is only in that…

SQL Server

Save your cart?