{"id":1231,"date":"2017-08-09T08:38:00","date_gmt":"2017-08-09T15:38:00","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1231"},"modified":"2020-01-11T12:51:53","modified_gmt":"2020-01-11T20:51:53","slug":"upgrading-sql-server-day-9","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/","title":{"rendered":"Upgrading SQL Server–August 8, 2017 Updates"},"content":{"rendered":"

Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often required in order for some types of upgrade and migration operations. It is also required to be in a fully supported state from Microsoft. It is also just a good idea!<\/p>\n

On August 8, 2017, Microsoft had a multitude of updates and new releases that are relevant for Windows and SQL Server. First, it was \u201cPatch Tuesday\u201d for August 2017, so there were a number operating system updates, Internet Explorer updates, Edge updates, etc. Then, if you have Microsoft Update installed (which is a superset of Windows Update), you would also be offered security updates to SQL Server 2012, SQL Server 2014, and SQL Server 2016 (for currently supported Service Pack levels).<\/p>\n

Microsoft also released Cumulative Updates (CU) for SQL Server 2012, SQL Server 2014, and SQL Server 2016 (for currently supported Service Pack levels). The CUs also include the security hotfix offered by Microsoft Update (which also included the complete CU). So one way or another, if you took either update method, you should be fully up to date, whether you like it or not.<\/p>\n

Actually, I think this is a good thing. Microsoft has been recommending proactive installation of CUs since March 24, 2016, as detailed in their Announcing updates to the SQL Server Incremental Servicing Model (ISM)<\/a> post. As a consultant, I always advise people to regularly, explicitly install CUs on their own schedule, after they have done their own testing.<\/p>\n

The Microsoft SQL Server Release Services blog<\/a> has posts listing all of these new CUs.<\/p>\n

 <\/p>\n

SQL Server 2012<\/u><\/strong><\/font><\/p>\n

\n

SQL Server 2012 fell out of mainstream support on July 11, 2017. Despite this, Microsoft decided to release SQL Server 2012 SP3 CU10 (with only five public hotfixes) on August 8, 2017, probably because of the security hotfix. They are also due to release SQL Server 2012 SP4 in September, which will have a lot of manageability and performance improvements back-ported from SQL Server 2014 SP2.<\/p>\n

Cumulative update 10 for SQL Server 2012 SP3<\/a><\/p>\n

Announcing SQL Server 2012 Service Pack 4<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2014<\/u><\/strong><\/font><\/p>\n

\n

If you are running SQL Server 2014, you have hopefully moved to the SP2 branch by now, since it has a lot of manageability and performance improvements. It will also be a \u201csupported Service Pack\u201d for a longer period. <\/p>\n

Cumulative Update 13 for SQL Server 2014 SP1<\/a><\/p>\n

Cumulative Update 6 for SQL Server 2014 SP2<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server 2016<\/u><\/strong><\/font><\/p>\n

\n

If you are running SQL Server 2016, you have hopefully moved to the SP1 branch by now, since it has the new programmability features in Standard Edition, and many other manageability and performance improvements. It will also be a \u201csupported Service Pack\u201d for a longer period. <\/p>\n<\/blockquote>\n

\n

Cumulative Update 7 for SQL Server 2016<\/a><\/p>\n

Cumulative Update 4 for SQL Server 2016 SP1<\/a><\/p>\n

 <\/p>\n<\/blockquote>\n

SQL Server Management Studio<\/font><\/u><\/strong><\/p>\n

\n

Microsoft also released SSMS 17.2 on August 8, 2017. They recommend that you use this version of SSMS, even if you are running a down-level version of SQL Server. It is officially supported all the way back to SQL Server 2008, but it should actually work pretty well on SQL Server 2005 and even SQL Server 2000.<\/p>\n

Download SQL Server Management Studio (SSMS)<\/a><\/p>\n<\/blockquote>\n

 <\/p>\n

Additional Resources<\/font><\/u><\/strong> <\/p>\n

I have a new Pluralsight<\/a> course, SQL Server: Upgrading and Migrating to SQL Server 2016<\/a> has just been published. This is my eleventh course for Pluralsight, but the complete list of my courses is here<\/a>. <\/p>\n

Building on this online course is a new three day class, IEUpgrade: Immersion Event on Upgrading SQL Server<\/a>, taught by myself<\/a> and Tim Radney<\/a>. The first round of this course will be taught in Chicago from October 11-13, 2017. <\/p>\n

Finally, I will be presenting a half-day session called Migrating to SQL Server 2017<\/a> at the PASS Summit 2017<\/a> in Seattle, WA from October 31- November 3, 2017. <\/p>\n

Here is a link to the complete series<\/a> about upgrading SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"

Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often required in order for some types of upgrade and migration operations. It is also required to be in a fully supported state from Microsoft. It is also just a good […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[246,342,353],"tags":[350,352],"class_list":["post-1231","post","type-post","status-publish","format-standard","hentry","category-sql-server-2016","category-sql-server-2017","category-upgrading-sql-server","tag-upgrading-to-sql-server-2016","tag-upgrading-to-sql-server-2017"],"yoast_head":"\nUpgrading SQL Server–August 8, 2017 Updates - 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\/upgrading-sql-server-day-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading SQL Server–August 8, 2017 Updates - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often required in order for some types of upgrade and migration operations. It is also required to be in a fully supported state from Microsoft. It is also just a good […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-09T15:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:53+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\/upgrading-sql-server-day-9\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/\",\"name\":\"Upgrading SQL Server–August 8, 2017 Updates - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2017-08-09T15:38:00+00:00\",\"dateModified\":\"2020-01-11T20:51:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading SQL Server–August 8, 2017 Updates\"}]},{\"@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":"Upgrading SQL Server–August 8, 2017 Updates - 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\/upgrading-sql-server-day-9\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading SQL Server–August 8, 2017 Updates - Glenn Berry","og_description":"Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often required in order for some types of upgrade and migration operations. It is also required to be in a fully supported state from Microsoft. It is also just a good […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/","og_site_name":"Glenn Berry","article_published_time":"2017-08-09T15:38:00+00:00","article_modified_time":"2020-01-11T20:51:53+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\/upgrading-sql-server-day-9\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/","name":"Upgrading SQL Server–August 8, 2017 Updates - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2017-08-09T15:38:00+00:00","dateModified":"2020-01-11T20:51:53+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Upgrading SQL Server–August 8, 2017 Updates"}]},{"@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\/1231","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=1231"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1231\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}