Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/glenn/wp-config.php on line 94

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":879,"date":"2014-04-24T09:09:03","date_gmt":"2014-04-24T16:09:03","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=879"},"modified":"2020-01-11T12:51:51","modified_gmt":"2020-01-11T20:51:51","slug":"most-recent-cumulative-updates-for-sql-server-2008-2014","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/","title":{"rendered":"Most Recent Cumulative Updates for SQL Server 2008-2014"},"content":{"rendered":"

Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) <\/p>\n

\n

SQL Server 2014 RTM CU2 (12.0.2370)<\/a>           released on June 27, 2014<\/font> <\/p>\n

Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB article. These include most of the hotfixes from SQL Server 2012 through SP1 CU10. If you are getting ready to deploy a new SQL Server 2014 instance, I really think you want to be on SQL Server 2014 RTM CU2<\/u>.<\/font><\/p>\n<\/blockquote>\n

\n

SQL Server 2012 RTM CU11 (11.0.2424)<\/a>          released on December 16, 2013  (this is the last one for the RTM branch)<\/p>\n<\/blockquote>\n

\n

SQL Server 2012 SP1 CU10 (11.0.3431)<\/a>           released on May 19, 2014 (On<\/strong> SQL Server 2012,<\/strong> this is where you want to be, in my opinion<\/strong>) <\/p>\n

SQL Server 2012 SP2 RTM (11.0.5058)<\/a>            released on  June 19, 2014 (I would wait for SQL Server 2012 SP2 CU1 before you move to this branch) <\/p>\n

If you are on SQL Server 2012, only Service Pack 1 and Service Pack 2 are still officially a \u201csupported service pack\u201d. The RTM branch is no longer a \u201csupported service pack\u201d. <\/p>\n<\/blockquote>\n

<\/blockquote>\n
\n

SQL Server 2008 R2 SP2 CU12 (10.50.4305)<\/a>     released on April 21, 2014 <\/p>\n

If you are on SQL Server 2008 R2, only Service Pack 2 is still a \u201csupported service pack\u201d. All other branches are retired.<\/p>\n<\/blockquote>\n

<\/blockquote>\n
\n

SQL Server 2008 SP3 CU17 (10.0.5861)<\/a>           released on May 19, 2014  (this is the final CU for SQL Server 2008 SP3)<\/p>\n<\/blockquote>\n

\n

If you are on SQL Server 2008, only Service Pack 3 is still a \u201csupported service pack\u201d. All other branches are retired.<\/p>\n<\/blockquote>\n

For a number of months, I was very curious about whether there would be a SQL Server 2008 SP4 and\/or a SQL Server 2008 R2 SP3 before both SQL Server 2008 and 2008 R2 fall out of mainstream support on July 8, 2014<\/a>?  Especially for people who don\u2019t believe in deploying cumulative updates, the SQL Server 2008 SP3 RTM build and the SQL Server 2008 R2 SP2 RTM build are going to be quite ancient (and missing a lot of very important fixes) by July 8, 2014. <\/p>\n

June 2, 2014 Update:<\/strong> On May 29, Microsoft announced that there will be final Service Packs for both SQL Server 2008 and SQL Server 2008 R2, that will be released some time after July 8, 2014. This is very welcome news that I really appreciate! <\/p>\n

So, to recap, if you are getting ready to deploy SQL Server 2014, you should install SQL Server 2014 RTM CU2.  If you are on SQL Server 2012, you should be on the SP1 branch by now (even though SP2 is now available). If you are on SQL Server 2008 R2, you should be on the SP2 branch, since SP1 and RTM are retired. If you are on SQL Server 2008, you should be on the SP3 branch, since all previous branches are retired. All of SQL Server 2005 is out of mainstream support, but if you are still on SQL Server 2005, you should be on SP4.<\/p>\n","protected":false},"excerpt":{"rendered":"

Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,29,30,31,156],"tags":[315],"class_list":["post-879","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-sql-server-2008","category-sql-server-2008-r2","category-sql-server-2012","category-sql-server-2014","tag-sql-server-cumulative-updates"],"yoast_head":"\nMost Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Most Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2014-04-24T16:09:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:51+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/\",\"name\":\"Most Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2014-04-24T16:09:03+00:00\",\"dateModified\":\"2020-01-11T20:51:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Most Recent Cumulative Updates for SQL Server 2008-2014\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Most Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/","og_locale":"en_US","og_type":"article","og_title":"Most Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry","og_description":"Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/","og_site_name":"Glenn Berry","article_published_time":"2014-04-24T16:09:03+00:00","article_modified_time":"2020-01-11T20:51:51+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/","name":"Most Recent Cumulative Updates for SQL Server 2008-2014 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2014-04-24T16:09:03+00:00","dateModified":"2020-01-11T20:51:51+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/most-recent-cumulative-updates-for-sql-server-2008-2014\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Most Recent Cumulative Updates for SQL Server 2008-2014"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=879"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/879\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}