white paper

The Many-to-Many Revolution

This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models.  Read more

Wow! Today I hit F5 on this interesting transaction: BEGIN TRANSACTION     INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender)     VALUES (‘Arianna’, ‘Ferrari’, ‘20110720’, ‘Female’);     UPDATE World.Parents SET STATUS = ‘Happy’     WHERE NAME = ‘Alberto’ AND Surname =…  Read more

link In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago. The sad answer is that this…  Read more

I already announced a few weeks ago that I and Alberto will speak at SQLBits in Liverpool. We will also speak at SQLPASS Summit in Seattle and at SQLRally Nordic. A few details about my sessions: SQLPASS Summit (Seattle, WA…  Read more

It seems that the next SQLBits will be larger than ever! The SQLBits 9 will take place in Liverpool from 29th September to 1st October 2011. It will be hard to get a nicer weather than in Brighton, but we…  Read more

A few days ago a post about VSTO-based PowerPivot Workbook in the PowerPivot Team Blog shown a workaround for the lack of PowerPivot API in Excel. In reality, I don’t like this workaround at all, because it relies on displaying…  Read more

Alberto anticipated me announcing our next edition of the PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The announcement has been published also on the SQLPort website in Portuguese! But remember, the workshop will be entirely in English! In…  Read more

Chris Webb, who wrote the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book with me and Alberto, is preparing another Introduction to MDX course in London, this time from October 26th to 28th. It is now a…  Read more

Jeffrey Wang wrote an interesting post about internals of IF statement in MDX script, describing how and when it is rewritten as a IIF statement. The interesting news in his post is also a possible query plan tool for MDX…  Read more

Next week I will be in Paris and Brussels for two editions of the PowerPivot Workshop. The evening after the first day of the workshop is always a good chance to meet people from local communities and I am happy…  Read more