SQLServerCentral Editorial

Roll Up All the Versions

,

I saw the announcement that we'll get a final SP4 for SQL Server 2012 soon, which is something I like. I think it's a good idea to roll up all the patches at some point and provide this as a final update for users. After all, we may not install the older version on new servers, but in the case of development or DR situations, we may need to create a new instance, and we want the patching to be smooth.

The final patch  for SQL Server 2012 will have ( list quoted from MS):

  • All fixes and CUs for SQL 2012 up to and including SQL Server 2012 SP3 CU9.
  • Scalability and performance improvements for SQL Server.
  • Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans
  • New improvements based on connect feedback items filed by the SQL Community.
  • Some of the Improvements originally introduced in SQL 2014 SP2 and SQL Server 2016 SP1.

We haven't always seen this. In 2005 we had an SP4, but then more CUs. SQL Server 2008 got to SP3, but with 17 more CUs. SQL Server 2008 R2, perhaps the worst software version name ever, went to SP3 and then just security patches. With 2012, we are getting this final SP and then hopefully continue the path of providing security patches only, but stopping the CU cycle here.

I've asked for final service packs, and while I don't think Microsoft really listens to me, I do hope they see this final patch for a version as a good way to close out support for all versions of their products. If you feel the same way, continue to put pressure on Microsoft, file items on Connect, and ask for one last patch for each version that you manage.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating