Archive for SQL Server 2012

Goodbye Vertipaq, hello xVelocity !

Usually when a MS product finally goes to RTM, even if you’ve been playing with all CTPs and RCs, you’ll discover some ultimate (last-minute?) changes and new small features that wasn’t present before.

This one seems to be “just” a re-branding but may be significant of a new strategy for the (almost) new MS in-memory analytics engine technology : the Vertipaq engine which is now integrated in Excel through Power Pivot, Sharepoint through Power Pivot and PowerView, Analysis Services through Tabular Model and even in the Database Engine through ColumnStore Index (Codename Apollo) is now called xVelocity!

You can find the official announcement here on the Sql Server Team blog, and the usual strategy clarification here on the Analysis Services and Power Pivot Team Blog.

So … long live xVelocity !

Advertisements

Leave a Comment

SQL Server 2012 goes RTM !

Today on his blog, the SQL Server team just announced that SQL Server 2012 has been released to manufacturing :

“Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1.”

Exciting news indeed, as it gives us opportunities to explore new ways to deliver “Breakthrough Insights” to everyone.

additionally, you can register now for the virtual launch event (VLE) that will take place online tomorrow on march 7, 2012.

As Platinum Partners for the event, you can find the Avanade and Accenture virtual booth online here !

It’s not available at the moment but it should be accessible after the start of the VLE.

Comments (3)

Microsoft TechDays’12

In a few days from now I will be participating to the french edition of the MS TechDays’12  that will take place in Paris from the 7th to the 9th of February, and this year again I will be a speaker.

The session, that I will share with two colleagues of mine, will be a level 300 presentation about Master Data Services (MDS) and how MDS helps you to manage your master data :

SQL Server 2012: Gérer vos données maitres avec Master Data Services (MDS)

If you have the opportunity to attend it, don’t hesitate to join !

As an alternative, you may also want to review those other sessions, all conducted by colleagues from Avanade :

• Sharepoint 2010 et les utilisateurs infonuagiques : Gaël Fabry

• ALM 360° – Les fonctionnalités clés de Visual Studio et TFS pour booster vos projets : Philippe Puschmann

• Azure Integration Services : les concepts de BizTalk dans le Cloud : Olivier Sagory et Marius Zaharia

• Concevoir sa plateforme commerce multi canal en moins d’une heure : David Allaigre et Régis Ravant

Nouvelles tendances du poste de travail: “Bring your Own PC”, “Desktop as a Service”, une réalité en entreprise – Parcours Décideurs : Régis Ravant

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)