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":644,"date":"2013-03-22T15:03:32","date_gmt":"2013-03-22T22:03:32","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=644"},"modified":"2018-11-13T10:52:02","modified_gmt":"2018-11-13T18:52:02","slug":"microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/","title":{"rendered":"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update"},"content":{"rendered":"

Starting on March 14, 2013, Microsoft started offering SQL Server 2012 Service Pack 1 as an Optional update on Microsoft Update (as shown in Figure 1). That means that it will not be pushed down automatically, and you will not even see it unless you are running Microsoft Update (which is an optional superset of Windows Update).<\/p>\n

 <\/p>\n

\"image\"<\/a><\/p>\n

Figure 1: SQL Server 2012 Service Pack 1 on Microsoft Update<\/strong><\/p>\n

Personally, I like the fact that more people will be reminded about SQL Server 2012 Service Pack 1 (as long as they are running Microsoft Update), but I still think it is better to manually download and install SQL Server 2012 Service Pack 1 yourself, rather than pulling it down from Microsoft Update. I think that database professionals should maintain their SQL Server instances explicitly, by design.<\/p>\n

If you are going to move to the SQL Server 2012 Service Pack 1 branch, I think you should make sure to also install SQL Server 2012 Service Pack 1 Cumulative Update 3<\/a> while you are\u00a0 at it. Microsoft has been very busy fixing many important issues (and actually adding some new functionality) with the early CUs for SQL Server 2012.<\/p>\n","protected":false},"excerpt":{"rendered":"

Starting on March 14, 2013, Microsoft started offering SQL Server 2012 Service Pack 1 as an Optional update on Microsoft Update (as shown in Figure 1). That means that it will not be pushed down automatically, and you will not even see it unless you are running Microsoft Update (which is an optional superset of […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[319,93,99,98],"class_list":["post-644","post","type-post","status-publish","format-standard","hentry","category-sql-server-2012","tag-microsoft-update","tag-service-pack-1","tag-sql-server-2012-service-pack-1","tag-sql-server-2012-sp1"],"yoast_head":"\nMicrosoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update\" \/>\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\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-22T22:03:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:52:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/\",\"name\":\"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png\",\"datePublished\":\"2013-03-22T22:03:32+00:00\",\"dateModified\":\"2018-11-13T18:52:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png\",\"width\":644,\"height\":393},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update\"}]},{\"@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":"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry","description":"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update","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\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry","og_description":"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/","og_site_name":"Glenn Berry","article_published_time":"2013-03-22T22:03:32+00:00","article_modified_time":"2018-11-13T18:52:02+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/","name":"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png","datePublished":"2013-03-22T22:03:32+00:00","dateModified":"2018-11-13T18:52:02+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Describes how Microsoft is offering SQL Server 2012 Service Pack 1 on Microsoft Update","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2013\/03\/image_thumb2.png","width":644,"height":393},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/microsoft-offering-sql-server-2012-service-pack-1-on-microsoft-update\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Microsoft Offering SQL Server 2012 Service Pack 1 on Microsoft Update"}]},{"@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\/644","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=644"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/644\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}