Microsoft has released a number of SQL Server Cumulative Updates and Service Packs over the past several weeks. For SQL Server 2014, these include:<\/p>\n

\n

June 20, 2016    SQL Server 2014 RTM CU14 (12.0.2569)<\/a><\/p>\n<\/blockquote>\n

\n

June 20, 2016    SQL Server 2014 SP1 CU7 (12.0.4459)<\/a><\/p>\n<\/blockquote>\n

\n

July 11, 2016     SQL Server 2014 SP2 RTM (12.0.5000<\/a>)<\/p>\n<\/blockquote>\n

SQL Server 2014 RTM CU14 will be the last cumulative update for the SQL Server 2014 RTM branch, and it is now an \u201cunsupported service pack\u201d. If you are still on the RTM branch, you should be be planning on moving to either SP1 or preferably SP2. SQL Server 2014 SP2 RTM has all of the fixes that are in SQL Server 2014 SP1 CU7, so there is no need to wait for SQL Server 2014 SP2 CU1 in order to \u201ccatch up\u201d to the previous branches. It also has a number of new features and performance improvements (which you can read about here<\/a>), so I think people are going to want to move to the SP2 branch relatively soon.<\/p>\n

You can find the official Microsoft Build list for SQL Server 2014 here:<\/p>\n

\n

SQL Server 2014 Build Versions<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

For SQL Server 2012, we have these updates:<\/p>\n

\n

July 18, 2016     SQL Server 2012 SP2 CU13  (11.0.5655)<\/a><\/p>\n

July 18, 2016     SQL Server 2012 SP3 CU4    (11.0.6540)<\/a><\/p>\n<\/blockquote>\n

As always, I think you are better off to be on the latest Service Pack for whatever version of SQL Server you are using. For SQL Server 2012, the RTM and SP1 branches are both considered \u201cunsupported service packs\u201d. You need to be on either SP2 or SP3, preferably SP3. <\/p>\n

You can find the official Microsoft Build lists for SQL Server 2012 SP3 and SP2 here:<\/p>\n

\n

SQL Server 2012 SP3 build versions<\/a><\/p>\n<\/blockquote>\n

\n

SQL Server 2012 SP2 build versions<\/a><\/p>\n<\/blockquote>\n

Finally, if you or your organization are still reluctant to deploy SQL Server Cumulative Updates, you should read the current official guidance from Microsoft about this. One of the key points is \u201cwe now recommend ongoing, proactive installation of CU\u2019s as they become available\u201d<\/strong>. This does not mean that you just blindly deploy a cumulative update to Production the day it is released. Rather, you should have a good testing and deployment plan that you go through before you deploy to Production. You can read the full Microsoft guidance here:<\/p>\n

\n

Announcing updates to the SQL Server Incremental Servicing Model (ISM)<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Microsoft has released a number of SQL Server Cumulative Updates and Service Packs over the past several weeks. For SQL Server 2014, these include: June 20, 2016    SQL Server 2014 RTM CU14 (12.0.2569) June 20, 2016    SQL Server 2014 SP1 CU7 (12.0.4459) July 11, 2016     SQL Server 2014 SP2 RTM (12.0.5000) SQL Server 2014 RTM […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,26,31,156],"tags":[],"class_list":["post-1096","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-sql-server-service-packs","category-sql-server-2012","category-sql-server-2014"],"yoast_head":"\n