SP2 includes the hotfixes from all released 2016 cumulative updates: SQL Server 2016 CU1 through SP1 CU8. To get the itemized list of those, you’d need to click through the posts in our 2016 CU listing. Suffice it to say, there were a lot. Here’s some of my favorite new […]
Brent Ozar
38 posts
When Microsoft announced that they’d do a monthly release schedule for the first year of a SQL Server version, a lot of eyes rolled, saying there’s no way they’d be able to keep up. Guess what: they’re doing it! Cumulative Update 6 is out, just less than a month after […]
High Five! Here comes Cumulative Update 5 with such fixes as: Better intra-query parallelism deadlocks troubleshooting Access violation when you query a table with an integer column Access violation when Query Store collects runtime statistics Can’t stop a Docker container Right on time for a monthly release schedule! Awesome.
It’s download day Fresh on the heels of Azure SQL Managed Instances, 2016 SP1 CU8, and 2014 SP2 CU11 comes the release of SSMS 17.6, which brings “near 100% compatibility” for MIs.
SQL Server 2016 SP1 CU8 has a whole bunch of Analysis Services fixes, plus: Long restore times for encrypted databases Memory leak in sys.dm_exec_cached_plans Deadlocks when inserting into a partitioned clustered columnstore index Dynamic data masking returns invalid data Tempdb contention due to caching problems UPDATE fails silently if you […]
The Meltdown and Spectre attacks are newly announced ways of hacking CPUs, and they’re causing all kinds of urgent patches this week in operating systems, hypervisors, and apps. SQL Server 2017 CU3 SQL Server 2016 SP1 CU7 Go get ’em, tiger. Other improvements & fixes include some really awesome stuff! […]
Just a handful of fixes in this one: UPDATE statement fails silently if you reference a nonexistent partition function the WHERE clause Incorrect results for SELECT with batch mode hash aggregate Invalid comparison due to NO COLLATION False alarms from CHECKDB if SOUNDEX function is used in a persisted computed […]
The tool you know and love, SSMS, just got an update to 17.4, build 14.0.17213. Here’s what’s new from the changelog: General SSMS+ Vulnerability Assessment: Added a new SQL Vulnerability Assessment service to scan your databases for potential vulnerabilities and deviations from best practices, such as misconfigurations, excessive permissions, and […]
Just in time for your Thanksgiving outage window, Microsoft brings you the latest cumulative update for SQL Server 2016. Some highlights include: Memory use higher with many databases Memory leak when you process updates in SSAS Access violation when you cancel a query Access violation when you run sp_xml_preparedocument Incorrect […]
FORE! Download Service Pack 4 here, and here’s the list of bugs it fixes. Should you install it? Sometimes people think, “I don’t need to bother installing this update because I’m not having any problems.” Well, friend, check out KB #3146404: canceling a backup crashes SQL Server. You don’t wanna […]