{"id":1064,"date":"2016-02-23T09:41:02","date_gmt":"2016-02-23T17:41:02","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1064"},"modified":"2017-04-13T12:28:56","modified_gmt":"2017-04-13T19:28:56","slug":"sql-server-2014-service-pack-1-cu5-available","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/","title":{"rendered":"SQL Server 2014 Service Pack 1 CU5 Available"},"content":{"rendered":"<p>Microsoft has released <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/3130926\/cumulative-update-5-for-sql-server-2014-service-pack-1\">SQL Server 2014 Service Pack 1 Cumulative Update 5<\/a>, which is Build 12.0.4439.1. There are 21 hotfixes in the public fix list.<\/p>\n<p>In a very welcome change from the past, Microsoft has greatly streamlined the process for obtaining SQL Server Cumulative Updates. Rather than having to request the CU from a web page, and then wait for Microsoft to send you a download link by email (which, to be fair, usually only took a few minutes), you can now just download the <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=51186\">latest Cumulative Update directly from the Microsoft Download Center<\/a>.<\/p>\n<p>Another, even more welcome move is how Microsoft has changed their guidance and language regarding whether you should install SQL Server Cumulative Updates. Rather than the old, somewhat alarming language, we now have this language:<\/p>\n<blockquote>\n<p>Only the most recent cumulative update that was released for SQL Server 2014 SP1 is available at the Download Center. <\/p>\n<ul>\n<li>Each new Cumulative Update (CU) contains all the fixes that were included with the previous CU for the installed version\/Service Pack of SQL Server.\n<li><font style=\"background-color: #ffff00\">Microsoft recommends ongoing, proactive installation of CUs as they become available<\/font>:\n<ul>\n<li>SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.\n<li>Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.\n<li>CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.<\/li>\n<\/ul>\n<li>Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.\n<li>We recommend that you upgrade your SQL Server installation to <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/2936603\/sql-server-2014-build-versions\">the latest SQL Server 2014 service pack<\/a>. <\/li>\n<\/ul>\n<\/blockquote>\n<p>This is a huge improvement, and I really hope that this new guidance will encourage more people to actually try to stay more up to date with their SQL Server CUs. Having a robust testing, deployment and rollback plan, that you actually use and improve over time as you regularly deploy SQL Server CUs has a lot of benefits for your organization.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 5, which is Build 12.0.4439.1. There are 21 hotfixes in the public fix list. In a very welcome change from the past, Microsoft has greatly streamlined the process for obtaining SQL Server Cumulative Updates. Rather than having to request the CU from a web [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,21,156],"tags":[276],"class_list":["post-1064","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-microsoft","category-sql-server-2014","tag-sql-server-2014-sp1-cu5"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2014 Service Pack 1 CU5 Available - 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\/sql-server-2014-service-pack-1-cu5-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014 Service Pack 1 CU5 Available - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 5, which is Build 12.0.4439.1. There are 21 hotfixes in the public fix list. In a very welcome change from the past, Microsoft has greatly streamlined the process for obtaining SQL Server Cumulative Updates. Rather than having to request the CU from a web [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-23T17:41:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T19:28:56+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=\"2 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\/sql-server-2014-service-pack-1-cu5-available\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/\",\"name\":\"SQL Server 2014 Service Pack 1 CU5 Available - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2016-02-23T17:41:02+00:00\",\"dateModified\":\"2017-04-13T19:28:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014 Service Pack 1 CU5 Available\"}]},{\"@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":"SQL Server 2014 Service Pack 1 CU5 Available - 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\/sql-server-2014-service-pack-1-cu5-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014 Service Pack 1 CU5 Available - Glenn Berry","og_description":"Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 5, which is Build 12.0.4439.1. There are 21 hotfixes in the public fix list. In a very welcome change from the past, Microsoft has greatly streamlined the process for obtaining SQL Server Cumulative Updates. Rather than having to request the CU from a web [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/","og_site_name":"Glenn Berry","article_published_time":"2016-02-23T17:41:02+00:00","article_modified_time":"2017-04-13T19:28:56+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/","name":"SQL Server 2014 Service Pack 1 CU5 Available - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2016-02-23T17:41:02+00:00","dateModified":"2017-04-13T19:28:56+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-2014-service-pack-1-cu5-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014 Service Pack 1 CU5 Available"}]},{"@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\/1064","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=1064"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1064\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}