SentryOne Team Blog (blogs.sentryone.com)

How I learned to stop worrying and love cumulative updates

Stop worrying about cumulative updateshttps://www.flickr.com/photos/lord-jim/8019881296/

I have a pretty long history of advocating that people stay up to date on SQL Server updates. Service packs should be routine, but cumulative updates can be pretty important too, mostly because they can include crucial fixes you can deploy a lot sooner than the next service pack. The problem? FEAR. And this is mostly Microsoft's doing. For years, they have been peppering their CU and COD download pages and confirmation e-mails with cautionary messaging that borders on fear-mongering:

WARNING: This hotfix has not undergone full testing. Therefore, it is intended only for systems or computers that are experiencing the exact problem that is described in the one or more Microsoft Knowledge Base articles that are listed in "KB Article Numbers" field in the table at the end of this e-mail message. If you are not sure whether any special compatibility or installation issues are associated with this hotfix, we encourage you to wait for the next service pack release. The service pack will include a fully tested version of this fix. We understand that it can be difficult to determine whether any compatibility or installation issues are associated with a hotfix. If you want confirmation that this hotfix addresses your specific problem, or if you want to confirm whether any special compatibility or installation issues are associated with this hotfix, support professionals in Customer Support Services can help you with that.

The truth is, for some time now, cumulative updates have actually gone through the same scrutiny, regression testing, and release processes as service packs. And in fact, as an observer, I would say that CUs have a much better track record than service packs – as a result, I am much more reluctant to apply a service pack until it's been out in the wild for a few weeks, whereas I have no problem being among the first to install a fresh CU.

And the hints coming from Redmond have been that they will do away with major service packs for SQL Server in the future, moving to a more frequent and incremental model, not unlike cumulative updates (as they have already been doing with great success in Azure SQL Database, and as they are doing with the monthly builds of SSMS, and as they have announced for Windows).

Furthermore, the messaging you see above is soon going to be a thing of the past. The first round of cumulative updates you see in January, for example, will have updated wording that is far less ominous and will have less chance of scaring people away (I'll update this post with the new wording as soon as it is confirmed). And let's not forget how many cumulative updates are recommended in the following best practices knowledge base article:

So, join me (and Glenn Berry, among others). The water is nice, and nobody in here is scared of cumulative updates. They should become a part of your testing and deployment plans, instead of the annual service pack fire drill.

3 replies on “How I learned to stop worrying and love cumulative updates”

3 Comments (Comments are now closed.)
  1. Used to be that you needed to wait a CU to see if a previous fix caused any new issues. Much better now.

    Chris

  2. I've always been a service pack guy, believing that cumulative updates should be applied only as needed. After reading this article, however, things at Microsoft may be changing to be more incremental. I have mixed feelings about this specifically because where I work we haven't had luck automating SQL patch installs so everything must be done manually. If at some point Microsoft expects us to move to a more incremental patching strategy for SQL Server they need to provide a free and effective way to cleanly automate patching that I can be confident will work.