{"id":3193,"date":"2012-09-20T11:00:00","date_gmt":"2012-09-20T18:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/"},"modified":"2024-01-22T22:49:34","modified_gmt":"2024-01-23T06:49:34","slug":"sql-server-2012-sp1-ctp4-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/","title":{"rendered":"SQL Server 2012 SP1 CTP4 Now Available"},"content":{"rendered":"<p><span style=\"font-family:'Segoe UI';font-size:small;\">In late July, we released SQL Server 2012 SP1 CTP3, the first public Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1, which contained compatibility features for SQL Server 2012 to support <\/span><a href=\"http:\/\/blogs.msdn.com\/b\/microsoft_business_intelligence1\/archive\/2012\/07\/23\/microsoft-business-intelligence-in-excel-2013-sharepoint-2013-and-sql-server-2012-sp1.aspx\"><span style=\"font-family:'Segoe UI';font-size:small;\">self-service BI capabilities in Office and SharePoint 2013<\/span><\/a><span style=\"font-family:'Segoe UI';font-size:small;\"> Preview. Today, we are excited to release SQL Server 2012 SP1 CTP4 which contains additional supportability improvements that have been reported through our customer feedback platforms. The following highlights a few key enhancements in CTP4:<\/span><\/p>\n<ul>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\">A solution to migrate AlwaysOn Availability Group from a lower version of Windows Server cluster to a higher version of Windows Server cluster.<\/span><\/li>\n<li>\n<span style=\"font-family:'Segoe UI';font-size:small;\">Selective XML Index which will improve querying performance over data stored as XML<\/span><span style=\"font-family:'Segoe UI';font-size:small;\"><\/span>\n<\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\">For SQL Server 2012 Express users, SQL Server 2012 SP1 Express Edition will ship the SQL Server Management Studio with functionality that existed with the SQL Server Management Studio from SQL Server premium editions<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">For a more detailed list of improvements and fixes please <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb500435\" target=\"_blank\" rel=\"noopener\">read here<\/a>.<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">Customers running SQL Server 2012 can download and test the SP1 CTP4 and send feedback to Microsoft for continuous product improvement. We look forward to your feedback!<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=257796\" target=\"_blank\" rel=\"noopener\">SQL Server 2012 SP1 CTP4 <\/a><\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=257783&amp;\" target=\"_blank\" rel=\"noopener\">SQL Server 2012 SP1 CTP4 Express<\/a><\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=263965&amp;\" target=\"_blank\" rel=\"noopener\">SQL Server 2012 SP1 CTP4 Feature Pack<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In late July, we released SQL Server 2012 SP1 CTP3, the first public Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1, which contained compatibility features for SQL Server 2012 to support self-service BI capabilities in Office and SharePoint 2013 Preview.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2400],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-3193","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2012","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In late July, we released SQL Server 2012 SP1 CTP3, the first public Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1, which contained compatibility features for SQL Server 2012 to support self-service BI capabilities in Office and SharePoint 2013 Preview.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-20T18:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2012 SP1 CTP4 Now Available\",\"datePublished\":\"2012-09-20T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\"},\"wordCount\":198,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\",\"name\":\"SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-09-20T18:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012 SP1 CTP4 Now Available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog","og_description":"In late July, we released SQL Server 2012 SP1 CTP3, the first public Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1, which contained compatibility features for SQL Server 2012 to support self-service BI capabilities in Office and SharePoint 2013 Preview.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-09-20T18:00:00+00:00","article_modified_time":"2024-01-23T06:49:34+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2012 SP1 CTP4 Now Available","datePublished":"2012-09-20T18:00:00+00:00","dateModified":"2024-01-23T06:49:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/"},"wordCount":198,"commentCount":4,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/","name":"SQL Server 2012 SP1 CTP4 Now Available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-09-20T18:00:00+00:00","dateModified":"2024-01-23T06:49:34+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/09\/20\/sql-server-2012-sp1-ctp4-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012 SP1 CTP4 Now Available"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3193"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3193\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3193"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3193"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3193"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3193"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3193"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}