Saturday, 13 November 2010

SQL Server 'Denali' highlights

On Wednesday at the two Adelaide sessions of the PDC Roadshow I gave the world's fastest overview of interesting things coming in the next version of SQL Server – codenamed 'Denali'.

I'd even whipped up some PowerPoint slides, but due to time constraints didn't get to share them with everyone, so I've summarised the main points here:

Main highlights

Areas unchanged in CTP1

  • Analysis Services
  • Data Quality Services
  • Reporting Services
  • Replication
  • Service Broker

SQL Server Engine

  • SMSS uses VS2010 shell
  • Transact-SQL debugging and IntelliSense
  • Transact-SQL Snippets
  • Contained databases
  • SEQUENCE objects
  • Circular arc segment (spatial)
  • User-defined server roles

SQL Server Integration Services

  • “Biggest change since 2005”
  • New deployment model
  • Object Impact and Data Lineage Analysis
    • Dependency Designer
  • Merge and Merge Join memory improvements
  • Designer enhancements
  • Edit disconnected components
  • Data correction component


  • Runs on your SQL Server system Uploading information to cloud service
    • Configuration
    • Performance, etc
  • Browse using a dashboard
  • Give access to Microsoft Support


  • Web-based reporting experience that offers rich visualization to let you project the story about your data to end users and other business users

Microsoft Certified Masters

  • Just sit the exams (don't have to do all the training)
  • No testing centres in Australia yet

If you're interested in finding out about these features (and more), Roger Noble and Rob Farley will be talking all about 'Denali' at this month's Adelaide SQL User Group (Tuesday 23rd November).


Joseph Cooney said...

Is that Oracle RAC compete feature (Matrix or Grid...can't remember what it was called) in this release?

Denali seems like an unfortunate code-name. It was the code-name for classic ASP as well. Bad memories.

David Gardiner said...

I hadn't picked up on the overloaded codename, but I think you might be right. Bad memories aside, classic ASP was pretty successful in it's time IMHO, so hopefully the SQL team can take that bit forward.

Regarding similar features to Oracle Real Application Clusters.. I'm not sure.
Will be interesting to see between Denali and SQL Azure whether they end up offering something similar.