Brent Ozar

38 posts

Announcing SQL Server 2017 Cumulative Update 6

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 […]

Announcing SQL Server 2017 CU5

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.

Announcing SQL Server 2016 SP1 CU8, 2014 SP2 CU11

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 […]

SQL Server 2014 SP2 Cumulative Update 9 Released

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 […]

SQL Server Management Studio 17.4 Released

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 […]

SQL Server 2016 SP1 Cumulative Update 6 Released

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 […]

New Service Pack 4 for SQL Server 2012

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 […]