{"id":14611,"date":"2015-11-30T15:10:00","date_gmt":"2015-11-30T23:10:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/"},"modified":"2024-01-22T22:50:23","modified_gmt":"2024-01-23T06:50:23","slug":"sql-server-2016-community-technology-preview-3-1-is-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/","title":{"rendered":"SQL Server 2016 Community Technology Preview 3.1 is available"},"content":{"rendered":"<p>The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 November public preview release CTP 3.1.<\/p>\n<p>To learn more about SQL Server 2016, visit the <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\">SQL Server 2016 preview page<\/a>. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, <a href=\"https:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">download the preview<\/a> and start evaluating the impact these new innovations can have for your business.<\/p>\n<p>Have questions?\u00a0Join the discussion of the new SQL Server 2016 capabilities at <a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/sqlserver\/en-US\/home?forum=SQLServer2016Preview\">MSDN<\/a> and <a href=\"http:\/\/stackoverflow.com\/nocaptcha?s=90783ecc-b296-47d6-8e8b-06d05bcfae2c\">StackOverflow<\/a>. If you run into an issue or would like to make a suggestion, you can let us know\u00a0through <a href=\"https:\/\/connect.microsoft.com\/SQLServer\">Microsoft\u2019s Connect tool<\/a>. We look forward to hearing from you.<\/p>\n<p>New <strong>In-Memory OLTP<\/strong> improvements in CTP3.1 include:<\/p>\n<ul>\n<li><strong>Unique indexes<\/strong> in memory-optimized tables, to complement the support for unique constraints that was released in CTP3<\/li>\n<li><strong>LOB data types<\/strong> varchar(max), nvarchar(max), and varbinary(max) in memory-optimized tables and natively compiled modules<\/li>\n<li><strong>Indexes with NULLable key columns<\/strong> in memory-optimized tables<\/li>\n<\/ul>\n<p><strong>Example<\/strong>: Illustrate the new features using a memory-optimized table natively compiled stored procedure.<\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">CREATE TABLE<\/span> Sales.Store_inmem(<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[BusinessEntityID] <span style=\"color: #0000ff\">int IDENTITY<\/span> <span style=\"color: #808080\">NOT NULL<\/span> <span style=\"color: #0000ff\">PRIMARY KEY NONCLUSTERED<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[Name] <span style=\"color: #0000ff\">nvarchar<\/span><span style=\"color: #808080\">(<\/span>200<span style=\"color: #808080\">)<\/span> <span style=\"color: #808080\">NOT NULL<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[SalesPersonID] <span style=\"color: #0000ff\">int<\/span> <span style=\"color: #808080\">NULL<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">[Demographics] <span style=\"color: #0000ff\">nvarchar<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #ff00ff\">max<\/span><span style=\"color: #808080\">)<\/span> <span style=\"color: #808080\">NULL<\/span>, <span style=\"color: #008000\">&#8212; LOB column<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[ModifiedDate] <span style=\"color: #0000ff\">datetime2<\/span> <span style=\"color: #808080\">NOT NULL<\/span> <span style=\"color: #0000ff\">DEFAULT<\/span> <span style=\"color: #808080\">(<\/span><span style=\"color: #ff00ff\">sysdatetime<\/span><span style=\"color: #808080\">())<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<span style=\"color: #0000ff\">INDEX<\/span> ix_SalesPersonID <span style=\"color: #0000ff\">NONCLUSTERED<\/span> (SalesPersonID), <span style=\"color: #008000\">&#8212; index on Nullable column<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">INDEX<\/span> ix_Name <span style=\"color: #0000ff\">UNIQUE NONCLUSTERED<\/span> <span style=\"color: #808080\">(<\/span>Name<span style=\"color: #808080\">)<\/span> <span style=\"color: #008000\">&#8212; UNIQUE index<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">) <span style=\"color: #0000ff\">WITH<\/span> (<span style=\"color: #0000ff\">MEMORY_OPTIMIZED=ON<\/span>)<\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">GO<\/span><\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">CREATE PROCEDURE<\/span> Sales.usp_InsertStore<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">@Name <span style=\"color: #0000ff\">nvarchar<\/span><span style=\"color: #808080\">(<\/span>200<span style=\"color: #808080\">)<\/span> <span style=\"color: #808080\">NOT NULL<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">@SalesPersonID <span style=\"color: #0000ff\">int<\/span> <span style=\"color: #808080\">= NULL<\/span>,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">@Demographics <span style=\"color: #0000ff\">nvarchar<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #ff00ff\">max<\/span><span style=\"color: #808080\">)<\/span> <span style=\"color: #808080\">= NULL<\/span><\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">WITH NATIVE_COMPILATION, SCHEMABINDING<\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">AS<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">BEGIN ATOMIC WITH<\/span> <span style=\"color: #808080\">(<\/span><span style=\"color: #0000ff\">TRANSACTION ISOLATION LEVEL<\/span>=<span style=\"color: #0000ff\">SNAPSHOT<\/span>, <span style=\"color: #0000ff\">LANGUAGE<\/span>=<span style=\"color: #ff0000\">N&#8217;Dutch&#8217;<\/span><span style=\"color: #808080\">)<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">INSERT<\/span> Sales.Store_inmem <span style=\"color: #808080\">(<\/span>Name, SalesPersonID, Demographics<span style=\"color: #808080\">)<\/span> <\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">VALUES<\/span> <span style=\"color: #808080\">(<\/span>@Name, @SalesPersonID, @Demographics<span style=\"color: #808080\">)<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">\u00a0<\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">END<\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">GO<\/span><\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">DECLARE<\/span> @Demographics nvarchar<span style=\"color: #808080\">(<\/span><span style=\"color: #ff00ff\">max<\/span><span style=\"color: #808080\">)<\/span> <span style=\"color: #808080\">=<\/span> <span style=\"color: #ff00ff\">REPLICATE<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #ff0000\">N&#8217;LOBtest&#8217;<\/span><span style=\"color: #808080\">,<\/span> 10000<span style=\"color: #808080\">)<\/span> <\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">EXECUTE Sales.usp_InsertStore @Name=<span style=\"color: #ff0000\">&#8216;test&#8217;<\/span>, @Demographics=@Demographics<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\">SELECT <span style=\"color: #808080\">*<\/span> <span style=\"color: #0000ff\">FROM<\/span> Sales.Store_inmem<\/span><br \/>\n<span style=\"color: #0000ff;font-family: courier new,courier;background-color: #f5f5f5\">GO<\/span><\/p>\n<p>Programmability improvement &#8211; AT TIME ZONE clause<br \/>\nSupport for AT TIME ZONE clause that allows customers to convert datetime values across different time zones, honoring time zone conversion rules. It can be used to appropriately present datetime values in applications that target international markets.<\/p>\n<p>Syntax inputdate AT TIME ZONE timezone.<\/p>\n<ul>\n<li><em>Inputdate<\/em>: An expression that can be resolved to a smalldatetime, datetime, datetime2, or datetimeoffset value.<\/li>\n<li><em>Timezone<\/em>: Name of the destination time zone in standard format as enumerated by Windows. Available time zones can be found by querying <strong>sys.time_zone_info<\/strong>.<\/li>\n<\/ul>\n<h1>Examples<\/h1>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">SELECT<\/span> SalesOrderID, OrderDate, <span style=\"color: #ff00ff\">TODATETIMEOFFSET<\/span> <span style=\"color: #808080\">(<\/span>OrderDate, <span style=\"color: #ff0000\">&#8216;-07:00&#8217;<\/span><span style=\"color: #808080\">)<\/span> <span style=\"color: #0000ff\">as<\/span> OrderDatePST,<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #ff00ff\">TODATETIMEOFFSET<\/span> <span style=\"color: #808080\">(<\/span>OrderDate, <span style=\"color: #ff0000\">&#8216;-07:00&#8217;<\/span><span style=\"color: #808080\">)<\/span> <span style=\"color: #0000ff\">AT TIME ZONE<\/span> <span style=\"color: #ff0000\">&#8216;Central European Standard Time&#8217;<\/span> <span style=\"color: #0000ff\">AS<\/span> OrderCETTime<\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">FROM<\/span> Sales.[SalesOrderHeader]<\/span><\/p>\n<p>If inputdate is without provided offset information, function applies offset of the time zone assuming that value was originally provided in that time zone:<\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">SELECT<\/span> <span style=\"color: #ff00ff\">convert<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #0000ff\">datetime2<\/span>, <span style=\"color: #ff0000\">&#8216;2015-06-27 11:20:08.5783475&#8217;<\/span><span style=\"color: #808080\">)<\/span> <\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">AT TIME ZONE<\/span> <span style=\"color: #ff0000\">&#8216;Central European Standard Time&#8217;<\/span> <span style=\"color: #0000ff\">as<\/span> CETTimeWithOffset<\/span><\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">SELECT<\/span> <span style=\"color: #ff00ff\">convert<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #0000ff\">datetime2<\/span>, <span style=\"color: #ff0000\">&#8216;2014-11-04 11:15:30.3214560&#8217;<\/span><span style=\"color: #808080\">)<\/span> <\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">AT TIME ZONE<\/span> <span style=\"color: #ff0000\">&#8216;Central European Standard Time&#8217;<\/span> <span style=\"color: #0000ff\">as<\/span> CETTimeWithOffset<\/span><\/p>\n<p>If inputdate contains offset, then function performs conversion to destination time zone:<\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">SELECT<\/span> <span style=\"color: #ff00ff\">convert<\/span>(<span style=\"color: #0000ff\">datetimeoffset<\/span>, <span style=\"color: #ff0000\">&#8216;2015-06-27 11:20:08.5783475 +02:00&#8217;<\/span><span style=\"color: #808080\">)<\/span><\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">AT TIME ZONE<\/span> <span style=\"color: #ff0000\">&#8216;Pacific Standard Time&#8217;<\/span> <span style=\"color: #0000ff\">as<\/span> PacificStandardTime<\/span><\/p>\n<p><span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">SELECT<\/span> <span style=\"color: #ff00ff\">convert<\/span><span style=\"color: #808080\">(<\/span><span style=\"color: #0000ff\">datetimeoffset<\/span>, <span style=\"color: #ff0000\">&#8216;2014-11-04 10:15:30.3214560 +00:00&#8217;<\/span><span style=\"color: #808080\">)<\/span> <\/span><br \/>\n<span style=\"font-family: courier new,courier;background-color: #f5f5f5\"><span style=\"color: #0000ff\">AT TIME ZONE<\/span> <span style=\"color: #ff0000\">&#8216;Pacific Standard Time&#8217;<\/span> <span style=\"color: #0000ff\">as<\/span> PacificStandardTime<\/span><\/p>\n<p><strong>SQL Server Analysis Services (SSAS)<\/strong> updates allow upgrading your existing models to 1200 compatibility level and a JSON editor for SSDT.<\/p>\n<p><strong>SQL Server PowerPivot and Reporting Services\/Power View for SharePoint 2016<\/strong> available now with CTP3.1! Make sure you use SharePoint Server 2016 Beta 2 available for download <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=49961\">here<\/a>. Earlier versions of SharePoint Server are not supported. You also need <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=49028\">Office Online Server Preview<\/a> because SharePoint Server no longer includes Excel Services. Excel Services, now called Excel Online Server, is now only available with Office Online Server. PowerPivot and Reporting Services\/Power View for SharePoint 2016 therefore require Office Online Server.<\/p>\n<p>For more information, see <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb500435.aspx\">What&#8217;s New in SQL Server 2016<\/a> and <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn876712.aspx\">SQL Server 2016 Release Notes<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 November public preview release CTP 3.1. To learn more about SQL Server 2016, visit the SQL Server 2016 preview page.<\/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,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-14611","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates","review-flag-1593580427-503","review-flag-1593580419-556","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2016 Community Technology Preview 3.1 is 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\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 Community Technology Preview 3.1 is available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 November public preview release CTP 3.1. To learn more about SQL Server 2016, visit the SQL Server 2016 preview page.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-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=\"2015-11-30T23:10:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:23+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\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-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 2016 Community Technology Preview 3.1 is available\",\"datePublished\":\"2015-11-30T23:10:00+00:00\",\"dateModified\":\"2024-01-23T06:50:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/\"},\"wordCount\":615,\"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\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/\",\"name\":\"SQL Server 2016 Community Technology Preview 3.1 is available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-11-30T23:10:00+00:00\",\"dateModified\":\"2024-01-23T06:50:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-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 2016 Community Technology Preview 3.1 is 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 2016 Community Technology Preview 3.1 is 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\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Community Technology Preview 3.1 is available - Microsoft SQL Server Blog","og_description":"The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 November public preview release CTP 3.1. To learn more about SQL Server 2016, visit the SQL Server 2016 preview page.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-11-30T23:10:00+00:00","article_modified_time":"2024-01-23T06:50:23+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\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-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 2016 Community Technology Preview 3.1 is available","datePublished":"2015-11-30T23:10:00+00:00","dateModified":"2024-01-23T06:50:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/"},"wordCount":615,"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\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/","name":"SQL Server 2016 Community Technology Preview 3.1 is available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-11-30T23:10:00+00:00","dateModified":"2024-01-23T06:50:23+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/11\/30\/sql-server-2016-community-technology-preview-3-1-is-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 2016 Community Technology Preview 3.1 is 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\/14611","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=14611"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14611\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14611"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14611"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14611"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14611"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14611"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}