{"id":13961,"date":"2015-09-30T09:46:00","date_gmt":"2015-09-30T16:46:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/"},"modified":"2024-01-22T22:50:17","modified_gmt":"2024-01-23T06:50:17","slug":"introducing-sql-server-2016-community-technology-preview-2-4","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/","title":{"rendered":"Introducing: SQL Server 2016 Community Technology Preview 2.4"},"content":{"rendered":"<p>The <a href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">SQL Server 2016 Community Technology Preview (CTP) 2.4<\/a> is now available for download!\u00a0 This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to <a href=\"http:\/\/azure.microsoft.com\/en-us\/marketplace\/partners\/microsoft\/sqlserver2016ctp2evaluationwindowsserver2012r2\/\">SQL Azure Database<\/a> service first, running in production prior to the release build.<\/p>\n<p>In SQL Server 2016 CTP 2.4, part of our new rapid preview model, we made enhancements to several features.\u00a0 You can try them now in your SQL Server 2016 development and test environments.<\/p>\n<p>As part of our new rapid release model, you don\u2019t have to wait several months for responses to feedback or to test new capabilities.\u00a0 This means you can accelerate testing and time to production.\u00a0 The frequent updates are also engineered to be of the same quality as major CTPs, so you don\u2019t have to be concerned about build quality.\u00a0 You also have the flexibility to choose which CTPs you will deploy for development and test environments and won\u2019t be forced to upgrade to the most recent preview release.<\/p>\n<p>In SQL Server 2016 CTP 2.4, <a href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">available for download today<\/a>, you will see enhancements in several areas:<\/p>\n<ul>\n<li>Operational Analytics and In-Memory Data Warehouse improvements<\/li>\n<li>x86 server deprecation<\/li>\n<li>SQL Server Smart Maintenance Plans for effective database maintenance<\/li>\n<li>Tempdb scalability improvement<\/li>\n<li>SQL Server Reporting Services (SSRS) improvements, including design-time control over layout of report parameters, export to PowerPoint, and a new printing feature that works across modern browsers<\/li>\n<\/ul>\n<p>CTP 2.4 also contains multiple improvements to SQL Server Integration Services (SSIS).<\/p>\n<p>For additional details, please visit the detailed <a href=\"\/sqlserver\/2015\/09\/30\/sql-server-2016-community-technology-preview-2-4-is-available\/\">SQL Server 2016 CTP 2.4 Engineering blog<\/a> and <a href=\"http:\/\/blogs.msdn.com\/b\/sqlreleaseservices\/archive\/2015\/09\/30\/announcing-sql-server-management-studio-september-2015-release.aspx\">SQL Server 2016 CTP 2.4 Management Studio blog<\/a>.<\/p>\n<p><strong>Download SQL Server 2016 CTP 2.4 preview today!<\/strong><\/p>\n<p>As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft&#8217;s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.<\/p>\n<p>To learn more about the release, visit the <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\">SQL Server 2016 preview page<\/a>.\u00a0 To experience the new, exciting features in SQL Server 2016 and the new rapid release model, <a href=\"http:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">download the preview <\/a>or try the preview by using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.\u00a0 Have questions?\u00a0 Join the discussion of the new SQL Server 2016 capabilities at <a title=\"MSDN\" href=\"https:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/home?forum=SQLServer2016Preview\">MSDN<\/a> and\u00a0<a href=\"http:\/\/stackoverflow.com\/search?q=sql+server+2016\">Stack Overflow<\/a>.\u00a0 If you run into an issue or would like to make a suggestion, you can let us know at <a href=\"https:\/\/connect.microsoft.com\/SQLServer\">Connect<\/a>.\u00a0 We look forward to hearing from you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server 2016 Community Technology Preview (CTP) 2.4 is now available for download!\u00a0 This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.4, part of our new rapid preview model,<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-13961","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-2-1593580436-981","review-flag-4-1593580446-456","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introducing: SQL Server 2016 Community Technology Preview 2.4 - 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\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing: SQL Server 2016 Community Technology Preview 2.4 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Server 2016 Community Technology Preview (CTP) 2.4 is now available for download!\u00a0 This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.4, part of our new rapid preview model,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\" \/>\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=\"2015-09-30T16:46:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:17+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=\"2 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\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Introducing: SQL Server 2016 Community Technology Preview 2.4\",\"datePublished\":\"2015-09-30T16:46:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\"},\"wordCount\":409,\"commentCount\":5,\"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\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\",\"name\":\"Introducing: SQL Server 2016 Community Technology Preview 2.4 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-09-30T16:46:00+00:00\",\"dateModified\":\"2024-01-23T06:50:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing: SQL Server 2016 Community Technology Preview 2.4\"}]},{\"@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":"Introducing: SQL Server 2016 Community Technology Preview 2.4 - 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\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/","og_locale":"en_US","og_type":"article","og_title":"Introducing: SQL Server 2016 Community Technology Preview 2.4 - Microsoft SQL Server Blog","og_description":"The SQL Server 2016 Community Technology Preview (CTP) 2.4 is now available for download!\u00a0 This release fully embraced the \u201cCloud First\u201d tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 2.4, part of our new rapid preview model,","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-09-30T16:46:00+00:00","article_modified_time":"2024-01-23T06:50:17+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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Introducing: SQL Server 2016 Community Technology Preview 2.4","datePublished":"2015-09-30T16:46:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/"},"wordCount":409,"commentCount":5,"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\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/","name":"Introducing: SQL Server 2016 Community Technology Preview 2.4 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-09-30T16:46:00+00:00","dateModified":"2024-01-23T06:50:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/09\/30\/introducing-sql-server-2016-community-technology-preview-2-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducing: SQL Server 2016 Community Technology Preview 2.4"}]},{"@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"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13961"}],"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=13961"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13961\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=13961"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=13961"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=13961"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=13961"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=13961"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=13961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}