SQL Server

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
17 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

SQL Server Doesn’t Encrypt Data By Default.

SQL Server
27 Comments
Create a table and insert a couple of rows: Then back up the database without using compression, and open up the backup file with a hex editor: The same trick works on the data file, too. That’s it. That’s all. That’s the post. Look, not every post is groundbreaking: sometimes it’s just about writing down…
Read More

SQL Server 2019 is out…now.

SQL Server 2019
7 Comments
After just one release candidate, Microsoft has decided it’s ready to go, apparently! Well, kinda: the official build in the release notes is 15.0.2000.5, and there’s already a “servicing update” to 15.0.2070.41. I’m not sure I wanna know what’s going on there. Anyhoo, SQL Server 2019 is available for download now. This also means it’s…
Read More
Menu