Posts Tagged Denali CTP3

[Denali CTP3] Product guide just released

Just in case you haven’t noticed yet, Microsoft has released the product guide for SQL Server Denali at this address :

http://www.microsoft.com/download/en/details.aspx?id=27069

This product guide provide us with product data sheets, Powerpoint presentations, technical white paper, hands on labs, self running demos, links and videos from the 2011 edition of the north america TechEd.

The content itself is divided into four modules :

  • Denali overview,
  • Mission critical confidence,
  • Breakthrough insights (aka. business intelligence)
  • and cloud on your terms

The whole thing take almost half a gigabytes and seems to be very handful.

Advertisements

Leave a Comment

[SQLServer 2012] Analysis Services New Feature : Scalable String Storage

As you may know, both dimension’s attributes and distinct count measures can be of string data type. During processing, Analysis Services reads data and put them into individual stores organized by attributes in case of dimensions or by measures groups/partitions for cubes.

The file format of those stores differ to adapt to the type of the data located inside. By default, until now, string stores couldn’t exceed the 4GB file size limit.

Starting with the CTP3, a new feature names “Scalable String Storage” allow to go beyond this limit. A new property named “StringStoresCompatibilityLevel” is available at different places to activate it.

I’ll review in this post how to set up this new feature in your SSAS solution and what we can expect from it…

Read the rest of this entry »

Comments (5)

SQL Server DENALI CTP3 out now !

It appears that the SQL Server DENALI CTP3 is out now and available at the following place :

https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx

The feature pack is also available :

http://www.microsoft.com/download/en/details.aspx?id=26726

I’ll review it as soon as possible.

Enjoy 🙂

Leave a Comment