{"id":19895,"date":"2017-04-19T08:00:03","date_gmt":"2017-04-19T15:00:03","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=19895"},"modified":"2024-01-22T22:50:52","modified_gmt":"2024-01-23T06:50:52","slug":"sql-server-2017-community-technology-preview-2-0-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/","title":{"rendered":"SQL Server 2017 Community Technology Preview 2.0 now available"},"content":{"rendered":"<p>Microsoft is excited to announce a new preview for the next version of SQL Server!\u00a0 We disclosed a name for this next release, SQL Server 2017, today at the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/data-amp\">Microsoft Data Amp<\/a> event. Community Technology Preview (CTP) 2.0 is the first production-quality preview of SQL Server 2017, and it is available on both Windows and Linux.\u00a0 In this preview, we added a number of new capabilities, including the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, and other capabilities that help you manage SQL Server for high performance and uptime, including the Adaptive Query Processing family of intelligent database features and resumable online indexing.<\/p>\n<p>In addition to all these great new features we are excited to announce a <strong>world record in the TPC-H 1TB data warehousing workload<\/strong> (non-clustered). The benchmark was achieved with SQL Server 2017 on Red Hat Enterprise Linux and HPE Prolliant server hardware, beating SQL Server 2016 on the same hardware handily.\u00a0 This is just the first of many anticipated performance benchmarks for SQL Server 2017 on Linux and Windows, demonstrating SQL Server\u2019s industry leading performance.\u00a0 When taken in conjunction with the fact that SQL Server has had the <strong>least vulnerabilities of any major database over the last 7 years<\/strong> in the National Institute of Standards and Technology (NIST) vulnerability database, SQL Server 2017 on Windows and Linux is the best database for your Mission Critical application and data warehouse workloads.<\/p>\n<p>You can <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">try the preview<\/a> in your choice of development and test environments now.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\"><img loading=\"lazy\" decoding=\"async\" style=\"float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border-width: 0px\" title=\"Power your entire data estate\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\" alt=\"Power your entire data estate\" width=\"871\" height=\"490\" border=\"0\" \/><\/a><\/p>\n<h2>Key CTP 2.0 enhancements on Windows and Linux<\/h2>\n<p>We also added <strong>support for storing and analyzing graph data relationships<\/strong>. This includes full CRUD support to create nodes and edges and T-SQL query language extensions to provide multi-hop navigation using join-free pattern matching. In addition, SQL Server engine integration enables querying across SQL tables and graph data. And, you can use all of your existing SQL Server tools to work with graph data.<\/p>\n<p>With <strong>resumable online index rebuild<\/strong>, you can resume a paused index rebuild operation from where the rebuild operation was paused rather than having to restart the operation at the beginning. Additionally, this feature rebuilds indexes using only a small amount of log space. This feature will help pick up right where you left off when an index maintenance job encounters issues, or allow you to split index rebuilds across maintenance windows.<\/p>\n<p>New in SQL Server 2017, we\u2019re adding the <strong>Adaptive Query Processing<\/strong> family of intelligent database features. These features automatically keep database queries running as efficiently as possible without requiring additional tuning from database administrators.\u00a0 In addition to the previous capability to adjust batch mode memory grants, in CTP 2.0 Adaptive Query Processing adds the batch mode adaptive joins and interleaved execution capabilities. <strong>Interleaved execution<\/strong> will improve the performance of queries that reference multi-statement table valued functions by surfacing runtime row counts to the query optimizer.\u00a0 <strong>Batch mode adaptive joins<\/strong> enables the choice of a query\u2019s physical join algorithm to be deferred until actual query execution, improving performance based on runtime conditions.<\/p>\n<p>In addition, some <strong>functionality that was previously available in SQL Server on Windows is now available on Linux for the first time<\/strong>. This includes:<\/p>\n<ul>\n<li><strong>Additional SQL Server Agent capabilities<\/strong> &#8211; Use SQL Server Agent to keep replicas in synch with log shipping.<\/li>\n<li><strong>Listener for Always On availability groups<\/strong> &#8211; The listener enables clients to connect to the primary replica in an availability group, monitoring availability and directing connections to the replicas.<\/li>\n<\/ul>\n<h2>Key CTP 2.0 enhancement to SQL Server on Windows \u2013 Python for analytics<\/h2>\n<p>Another new, key feature enhancement in CTP 2.0 of SQL Server 2017 is the ability to run the <strong>Python language in-database<\/strong> to scale and accelerate machine learning, predictive analytics and data science scripts. The new capability, called <strong>Microsoft Machine Learning Services<\/strong>, enables Python scripts to be run directly within the database server, or to be embedded into T-SQL scripts, where they can be easily deployed to the database as stored procedures and easily called from SQL client applications by stored procedure call. SQL Server 2017 will also extend Python\u2019s performance and scale by providing a selection of parallelized algorithms that accelerate data transforms, statistical tests and analytics algorithms. This functionality and the ability to run R in-database and at scale are only available on Windows Server operating system at this time.<\/p>\n<p>For additional detail on CTP 2.0, please visit <a href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/mt788653(SQL.130).aspx\">What\u2019s New in SQL Server 2017,<\/a> <a href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/mt788652(SQL.130).aspx\">Release Notes<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/\">Linux documentation<\/a>.<\/p>\n<h2>Get SQL Server 2017 CTP 2.0 today!<\/h2>\n<p>Get started with the preview of SQL Server with <a href=\"http:\/\/www.microsoft.com\/sql-server\/developer-get-started\">our developer tutorials<\/a> that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice.<\/p>\n<ul>\n<li>Register to attend an Engineering Town Hall about \u201c<a href=\"https:\/\/info.microsoft.com\/sql-server-on-linux-town-hall-security-register.html\">Security in SQL Server on Linux<\/a>\u201d<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-red-hat\">Install on Red Hat Enterprise Linux<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-ubuntu\">Install on Ubuntu Linux<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-suse-linux-enterprise-server\">Install on SUSE Linux Enterprise Server<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/\">Pull and run a Linux Docker container<\/a><\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/evalcenter\/evaluate-sql-server-2017-ctp\">Download the preview for Windows<\/a><\/li>\n<li><a href=\"https:\/\/aka.ms\/eapsignup\">Sign up for the Early Adoption Program (EAP)<\/a> &#8211; The Early Adoption Program is designed to help customers and partners evaluate new features in SQL Server2017 and to build and deploy applications for SQL Server 2017 on Windows and Linux.<\/li>\n<\/ul>\n<p>Have questions? Join the discussion of SQL Server 2017 at <a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/home\">MSDN<\/a>. If you run into an issue or would like to make a suggestion, you can let us know through <a href=\"https:\/\/connect.microsoft.com\/SQLServer\">Connect<\/a>. We look forward to hearing from you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft is excited to announce a new preview for the next version of SQL Server!\u00a0 We disclosed a name for this next release, SQL Server 2017, today at the Microsoft Data Amp event. Community Technology Preview (CTP) 2.<\/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":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2406],"content-type":[2448],"topic":[2457,2469],"coauthors":[2487],"class_list":["post-19895","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","content-type-updates","topic-data-analytics","topic-high-performance-database","review-flag-2-1593580436-981","review-flag-7-1593580462-294","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2017 Community Technology Preview 2.0 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\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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 2017 Community Technology Preview 2.0 now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft is excited to announce a new preview for the next version of SQL Server!\u00a0 We disclosed a name for this next release, SQL Server 2017, today at the Microsoft Data Amp event. Community Technology Preview (CTP) 2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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=\"2017-04-19T15:00:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.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=\"4 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\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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 2017 Community Technology Preview 2.0 now available\",\"datePublished\":\"2017-04-19T15:00:03+00:00\",\"dateModified\":\"2024-01-23T06:50:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/\"},\"wordCount\":907,\"commentCount\":28,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/\",\"name\":\"SQL Server 2017 Community Technology Preview 2.0 now available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\",\"datePublished\":\"2017-04-19T15:00:03+00:00\",\"dateModified\":\"2024-01-23T06:50:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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 2017 Community Technology Preview 2.0 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 2017 Community Technology Preview 2.0 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\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017 Community Technology Preview 2.0 now available - Microsoft SQL Server Blog","og_description":"Microsoft is excited to announce a new preview for the next version of SQL Server!\u00a0 We disclosed a name for this next release, SQL Server 2017, today at the Microsoft Data Amp event. Community Technology Preview (CTP) 2.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-04-19T15:00:03+00:00","article_modified_time":"2024-01-23T06:50:52+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png","type":"","width":"","height":""}],"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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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 2017 Community Technology Preview 2.0 now available","datePublished":"2017-04-19T15:00:03+00:00","dateModified":"2024-01-23T06:50:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/"},"wordCount":907,"commentCount":28,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/","name":"SQL Server 2017 Community Technology Preview 2.0 now available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png","datePublished":"2017-04-19T15:00:03+00:00","dateModified":"2024-01-23T06:50:52+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-now-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/04\/Power-your-entire-data-estate_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/04\/19\/sql-server-2017-community-technology-preview-2-0-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 2017 Community Technology Preview 2.0 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\/19895","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=19895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=19895"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=19895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=19895"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=19895"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=19895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=19895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}