We are able to test all the improvements of the new version of SQL Server Code-named “Denali” with the public release of the CTP3.

Official release: Download the SQL Server Denali CTP 3 for 32-bit or  64-bit
Official Feature Pack release: Download the SQL Server Denali CTP 3 Feature Pack
Official PowerPivot release: Download the SQL Server Denali CTP 3 PowerPivot for Excel
(Just wait in this website until the Download Manager is ready to download the CTP 3 without clicking on the “Get Started now” button)

Here there is a short list of some features inside the CTP 3. You will find the full list with a lot of great features in the official Microsoft PowerPivot and SQL Server Code-Named Denali CTP3 Release Notes that should be published soon :

New features in Powerpivot in SQL Server Code-named Denali CTP3:

  • Hierarchies
  • Multiple Relationships
  • Sort by other Column
  • Add values to rows and columns
  • Perspectives
  • New DAX Functions: DISTINCTCOUNT, CROSSJOIN, RANKX, GENERATE, TOPN, VARX, STDEVX, USERELATIONSHIP
  • Key Performance Inditcators (KPI)

New features in Analysis Services in SQL Server Code-named Denali CTP3:

  • New BISM Project with the Multi-dimensional and Tabular Data Model and the new storage modes (ROLAP, MOLAP, VertiPaq In-Memory and Direct Query)

 

New features related to Business Intelligence in SQL Server Code-named Denali CTP3:

  • Columnstore Indexes for Fast DW (Project Apollo)

 

We will go deeply in all these new features in future posts but in the meantime you could read more about that in these links:

Analysis Services Roadmap for Denali by the Analysis Services Team

Whitepaper of Columnstore Indexes for SQL Server Denali