SQL Server

The Top Feature Requests for SQL Server

SQL Server
27 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
307 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

What’s New in SQL Server 2022

SQL Server, SQL Server 2022
56 Comments
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…
Read More
Brent Reading Book

Your Top 10 Ideas for SQL Server

SQL Server
45 Comments
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…
Read More

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

SQL Server 2019
26 Comments
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…
Read More

What Is the SQL Server CEIP Service?

SQL Server
21 Comments
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…
Read More

[Video] What Percent Complete Is That Index Build?

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…
Read More
Menu