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":865,"date":"2014-01-24T13:07:29","date_gmt":"2014-01-24T21:07:29","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=865"},"modified":"2020-05-03T16:55:54","modified_gmt":"2020-05-03T23:55:54","slug":"final-service-packs-for-sql-server-2008-and-sql-server-2008-r2","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/","title":{"rendered":"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2"},"content":{"rendered":"

(New: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who ends up causing problems. Check them out here<\/a>.)<\/p>\n

As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014<\/a>, I am very curious whether Microsoft is planning on releasing a SQL Server 2008 R2 Service Pack 3 or a SQL Server 2008 Service Pack 4 ?<\/p>\n

SQL Server 2008 Service Pack 3 was released on October 25, 2011 , and we are now up to SQL Server 2008 SP3 CU15. SQL Server 2008 R2 Service Pack 2 was released on July 26, 2012, and we are now up to SQL Server 2008 R2 SP2 CU10.<\/p>\n

I am not looking for release dates, just some word on whether there will be new Service Packs for SQL Server 2008 or SQL Server 2008 R2 before they both fall out of mainstream support this July.\u00a0 Since many organizations still refuse to install Cumulative Updates, we have the very strong possibility of many customers running some very old builds<\/u><\/b> of SQL Server 2008 and 2008 R2 going forward unless we get a final set of Service Packs for both versions.<\/p>\n

As Paul Randal discovered in his recent survey<\/a>, a very large percentage of SQL Server 2008 and 2008 R2 instances in the wild are already running on \u201cunsupported service packs\u201d, and this situation only got worse when SQL Server 2008 R2 SP1 fell out of support on October 8, 2013. These links show the builds that have been released since the most recent Service Packs for SQL Server 2008 and SQL Server 2008 R2.<\/p>\n

The SQL Server 2008 Builds that were released after SQL Server 2008 Service Pack 3 was released<\/a><\/p>\n

The SQL Server 2008 R2 Builds that were released after SQL Server 2008 R2 Service Pack 2 was released<\/a><\/p>\n

If you want to try to influence Microsoft in some small way, please take a moment to up vote these Connect items. It only will take a few seconds to click the green arrow!<\/p>\n

This is mine, meant to be a generic item:<\/p>\n

https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/814658\/release-final-service-packs-for-sql-server-2008-and-2008-r2<\/p>\n

This one is from Christoph Muthmann, for SQL Server 2008 SP3:<\/p>\n

https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/814600\/release-service-pack-3-for-sql-server-2008-r2<\/p>\n

This one is from Erland Sommarskog, regarding SQL Server 2012 SP2:<\/p>\n

https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/814656\/release-service-pack-2-for-sql-server-2012<\/p>\n

If you have a bit more time, write a comment in any of the Connect items.<\/p>\n","protected":false},"excerpt":{"rendered":"

(New: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who ends up causing problems. Check them out here.) As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,26,29,30],"tags":[78],"class_list":["post-865","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql-server-service-packs","category-sql-server-2008","category-sql-server-2008-r2","tag-sql-server-service-packs-2"],"yoast_head":"\nFinal Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2\" \/>\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\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-24T21:07:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-03T23:55:54+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\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/\",\"name\":\"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2014-01-24T21:07:29+00:00\",\"dateModified\":\"2020-05-03T23:55:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2\"}]},{\"@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":"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry","description":"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2","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\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/","og_locale":"en_US","og_type":"article","og_title":"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry","og_description":"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/","og_site_name":"Glenn Berry","article_published_time":"2014-01-24T21:07:29+00:00","article_modified_time":"2020-05-03T23:55:54+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\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/","name":"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2014-01-24T21:07:29+00:00","dateModified":"2020-05-03T23:55:54+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Glenn Berry talks about Final Service Packs for SQL Server 2008 and SQL Server 2008 R2","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Final Service Packs for SQL Server 2008 and SQL Server 2008 R2"}]},{"@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\/865","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=865"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/865\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}