maintenance

No new SQL Server CUs till the end of 2020

Reading Time: < 1 minute

SQL server team announced today that they will not be releasing any new cumulative update for SQL server products (SQL Server 2019, 2017, and 2016SP2) until the end of this year.

As written in this blog post, it’s been a tough year and is now a good time, around the holidays, for people to spend time with their families.

I personally find this move very kind and supportive and I wish for more companies to follow this paradigm.

So cheers to Microsoft, once again, and happy -early- Christmas holidays to everyone.

Microsoft recalls CU 7 for SQL Server 2019

Reading Time: < 1 minute

Microsoft is recalling CU7 for SQL 2019 because of a known reliability issue with the database snapshot feature.

If you haven’t installed it yet, it is advised not to install it, even if you don’t make use of this feature, as DBCC CHECKDB also uses it. Instead wait for the CU 8 which is scheduled for the week of October-12.

You can read more here.

New CU for SQL Server 2016 SP2: CU14

Reading Time: < 1 minute

On August 6th, Microsoft released the latest Cumulative Update (CU14) targeting SQL Server 2016 Service Pack 2 (SP2) for Windows OS.

ComponentBuild versionFile version
SQL Server13.0.5830.852015.131.5830.85

Download today and test your environment with the latest CU

Cumulative updates (CU)

  • Each new CU contains all the fixes that were included with the previous CU for the installed version of SQL Server.
  • SQL Server CUs are certified to the same levels as Service Packs and should be installed at the same level of confidence.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available according to these guidelines:
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.
  • Microsoft recommends that you test SQL Server CUs before deploying to production environments.

A number of fixes have been released in this CU and you can check them all here.