{"id":11317,"date":"2011-07-13T17:48:00","date_gmt":"2011-07-13T17:48:00","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=11317"},"modified":"2011-07-13T17:48:00","modified_gmt":"2011-07-13T17:48:00","slug":"sql-server-2008-r2-service-pack-1","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=11317","title":{"rendered":"SQL Server 2008 R2 Service Pack 1"},"content":{"rendered":"<p>I hate SQL Service Packs.&#160; Yeah, you heard me!&#160; They just add so much more time to the installation time.&#160; Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it.<\/p>\n<p>Good news everybody!&#160; SQL Server 2008 R2 SP1 is <a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26727\" target=\"_blank\">launched<\/a>.&#160; Some new features are listed on that page but it\u2019s all beyond an accidental DBA like me so I won\u2019t copy\/paste and present to understand it all.<\/p>\n<p>Don\u2019t just lash this SP out and hope for the best.&#160; Check your application compatibility.&#160; That applies to your System Center admins too!&#160; There are support lists and you shouldn\u2019t go upgrading without checking for support first.&#160; Assuming there is support is your problem, not Microsoft\u2019s.&#160; You break it \u2013 you fix it <img decoding=\"async\" style=\"border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none\" class=\"wlEmoticon wlEmoticon-smile\" alt=\"Smile\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/07\/wlEmoticon-smile.png\" \/><\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:b43b8d31-629a-4218-9a4d-2e7154f97bda\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a>,<a href=\"http:\/\/technorati.com\/tags\/System+Center\" rel=\"tag\">System Center<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I hate SQL Service Packs.&#160; Yeah, you heard me!&#160; They just add so much more time to the installation time.&#160; Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody!&#160; SQL Server 2008 R2 SP1 is launched.&#160; Some new features are listed on that page but it\u2019s all beyond &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=11317\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL Server 2008 R2 Service Pack 1&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[39],"tags":[192,193],"class_list":["post-11317","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql","tag-system-center"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=11317\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=11317\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2011-07-13T17:48:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2011-07-13T17:48:00+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#article\",\"name\":\"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro\",\"headline\":\"SQL Server 2008 R2 Service Pack 1\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/wp-content\\\/uploads\\\/2011\\\/07\\\/wlEmoticon-smile.png\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317\\\/#articleImage\",\"width\":19,\"height\":19},\"datePublished\":\"2011-07-13T17:48:00+01:00\",\"dateModified\":\"2011-07-13T17:48:00+01:00\",\"inLanguage\":\"en-GB\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#webpage\"},\"articleSection\":\"SQL, SQL, System Center\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#listItem\",\"name\":\"SQL Server 2008 R2 Service Pack 1\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#listItem\",\"position\":3,\"name\":\"SQL Server 2008 R2 Service Pack 1\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317\",\"name\":\"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro\",\"description\":\"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \\u201cslipstream\\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\\u2019s all beyond\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=11317#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2011-07-13T17:48:00+01:00\",\"dateModified\":\"2011-07-13T17:48:00+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro","description":"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond","canonical_url":"https:\/\/aidanfinn.com\/?p=11317","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=11317#article","name":"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro","headline":"SQL Server 2008 R2 Service Pack 1","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/07\/wlEmoticon-smile.png","@id":"https:\/\/aidanfinn.com\/?p=11317\/#articleImage","width":19,"height":19},"datePublished":"2011-07-13T17:48:00+01:00","dateModified":"2011-07-13T17:48:00+01:00","inLanguage":"en-GB","mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=11317#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=11317#webpage"},"articleSection":"SQL, SQL, System Center"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=11317#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","position":2,"name":"SQL","item":"https:\/\/aidanfinn.com\/?cat=39","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=11317#listItem","name":"SQL Server 2008 R2 Service Pack 1"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=11317#listItem","position":3,"name":"SQL Server 2008 R2 Service Pack 1","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=11317#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=11317#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=11317#webpage","url":"https:\/\/aidanfinn.com\/?p=11317","name":"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro","description":"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=11317#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2011-07-13T17:48:00+01:00","dateModified":"2011-07-13T17:48:00+01:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro","og:description":"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond","og:url":"https:\/\/aidanfinn.com\/?p=11317","article:published_time":"2011-07-13T17:48:00+00:00","article:modified_time":"2011-07-13T17:48:00+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"SQL Server 2008 R2 Service Pack 1 | Aidan Finn, IT Pro","twitter:description":"I hate SQL Service Packs. Yeah, you heard me! They just add so much more time to the installation time. Yeah, you can \u201cslipstream\u201d them, but only a few people ever do it. Good news everybody! SQL Server 2008 R2 SP1 is launched. Some new features are listed on that page but it\u2019s all beyond","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"11317","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:18","updated":"2025-06-04 14:32:06","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=39\" title=\"SQL\">SQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQL Server 2008 R2 Service Pack 1\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com"},{"label":"SQL","link":"https:\/\/aidanfinn.com\/?cat=39"},{"label":"SQL Server 2008 R2 Service Pack 1","link":"https:\/\/aidanfinn.com\/?p=11317"}],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/11317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11317"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/11317\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}