{"id":571,"date":"2011-01-05T11:38:00","date_gmt":"2011-01-05T11:38:00","guid":{"rendered":"\/blogs\/bobb\/post\/Whats-new-in-Denali-CTP1-And-what-isnt-in-CTP1.aspx"},"modified":"2014-01-20T12:19:52","modified_gmt":"2014-01-20T20:19:52","slug":"whats-new-in-denali-ctp1-and-what-isnt-in-ctp1","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/","title":{"rendered":"What’s new in Denali CTP1. And what isn’t in CTP1."},"content":{"rendered":"

\nAt SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and sessions on it alluded to many more of the upcoming Denali features than appear on the CTP1. That's all well and good, but I've heard tell of one person who installed the CTP1 to show a client a feature he'd heard about, then spent time in front of the client looking for the feature (and no, it wasn't me).\n<\/p>\n

\nTo clarify things, you can reference the What's New for CTP1<\/a> in BOL. There's even a blogger (I forget the reference) who cut-and-pasted all the "what's new"s into a blog entry (for reference without using all the BOL links, I guess). But BOL What's New is somewhat incomplete in some areas. So, here's a list I made up after listening to the SQLPASS keynotes yesterday. For your experimenting pleasure.\n<\/p>\n

\n
\nAvailable in CTP1\n<\/p>\n

\nAlways On HADR – subset of features (see team blog post<\/a>)
\nFull-text – Property-based searches, better NEAR predicate
\nSpatial Enhancements (see whitepaper<\/a>)
\nT-SQL Enhancements
\nContained databases
\nSSIS Enhancements
\nSSIS Server
\nImpact Analysis and Lineage
\nProject Atlanta
\nUser-defined Server Roles
\nTools enhancements and SSMS uses VS2010 shell
\nXEvent enhancements – subset of enhancements
\nXEvents and SSIS Server in PowerShell provider, and Always On cmdlets.\n<\/p>\n

\nAnnounced at SQLPASS, but not available in CTP1\n<\/p>\n

\nAlways on (additional features coming)
\nFull-text – FileTable
\nColumnar Storage\/Indexes (Vertipak in Engine and SSAS)
\nProject Crescent
\nProject Juneau
\nBIDS integration with Visual Studio 2010
\nData Quality Services – SSIS and Standalone
\nDefault schemas for groups
\nDAC improvements
\nSemantic Search
\nSingle Model for Analysis and Reporting
\nMaster Data Services tab in Excel\n<\/p>\n

\nAnnounced at TechEd 2011, but not in CTP1\n<\/p>\n

\nT-SQL Analytical Function and OVER clause enhancements
\nAdditional T-SQL functions
\nXEvent Session create\/display GUI and parity with SQLProfiler
\nXEvents in SMO
\nExpansion of XEvents to more subsystems (SSAS, Replication, PDW)
\nAudit Enhancements (including Server Audit Specification for all SKUs)
\nCryptography Enhancements
\nMore Spatial enhancements
\nStreamInsight 1.2 (technically not part of Denali)\n<\/p>\n

\nAs always, corrections or additions are always welcome. You'll have to send them to me in email or on Twitter, though, I had to turn blog comments off.\n<\/p>\n

\n@bobbeauch<\/p>\n","protected":false},"excerpt":{"rendered":"

At SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and sessions on it alluded to many more of the upcoming Denali features than appear on the CTP1. That's all well and good, but I've heard tell of one person who […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-571","post","type-post","status-publish","format-standard","hentry","category-sql-server-2012"],"yoast_head":"\nWhat's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin<\/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.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"At SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and sessions on it alluded to many more of the upcoming Denali features than appear on the CTP1. That's all well and good, but I've heard tell of one person who […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-05T11:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-20T20:19:52+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/\",\"name\":\"What's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2011-01-05T11:38:00+00:00\",\"dateModified\":\"2014-01-20T20:19:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2012\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"What’s new in Denali CTP1. And what isn’t in CTP1.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin","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.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/","og_locale":"en_US","og_type":"article","og_title":"What's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin","og_description":"At SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and sessions on it alluded to many more of the upcoming Denali features than appear on the CTP1. That's all well and good, but I've heard tell of one person who […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/","og_site_name":"Bob Beauchemin","article_published_time":"2011-01-05T11:38:00+00:00","article_modified_time":"2014-01-20T20:19:52+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/","name":"What's new in Denali CTP1. And what isn't in CTP1. - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2011-01-05T11:38:00+00:00","dateModified":"2014-01-20T20:19:52+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/whats-new-in-denali-ctp1-and-what-isnt-in-ctp1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2012\/"},{"@type":"ListItem","position":3,"name":"What’s new in Denali CTP1. And what isn’t in CTP1."}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=571"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}