I’ll be a speaker at the European PASS Conference 2008 next week in Dusseldorf. I will talk about advanced dimensional modeling using many-to-many relationship. The content is based on ” The many-to-many revolution ” paper I wrote two years ago. If you  Read more

Yesterday one customer of mine encountered the issue described in KB933836 and posted also by Chris Webb . UPDATE: you can use the SQL Server 2008 version of the Analysis Services Deployment Wizard to deploy a project to a SQL Server 2005 Analysis Services  Read more

It’s a shame I haven’t blogged for two months, but I’ve been really (I mean – REALLY) busy finishing the upcoming Microsoft Programming LINQ book . Now I’m coming back to my BI world and the first news is that I’ll speak about SSAS models based on many-to-many  Read more

More than one year ago I published a paper about design patterns for many-to-many dimension relationships . Since then, I built other models and I got more experience about possible performance optimizations. Unfortunately, I still hadn’t time to write  Read more

Usually I write in this blog about Business Intelligence without too much consideration for “traditional” access to SQL Server. However, in a parallel universe I also wrote a book about LINQ and now that we are in full Christmas mode, I hope you may be  Read more

Brian Welcker (who is leaving SSRS team – good luck Brian!) has announced a long explanation of the Report Builder 2008 positioning . For me (and all of you who live in the multidimensional business…) the most important part of the post is this simple  Read more

I just wrote a T-SQL query based on CTE that generates support information to calculate working days in a period. Simply look at the WorkingDaySequential measure, which difference between two dates is the number of elapsed working days. In the real world:  Read more

I just read the SQL Server Performance in a VMware Infrastructure 3 Environment performance study published by VMware (thanks to virtualization.info for the link ). Often I’ve been asked if it is a good move having a SQL Server in production in a virtual  Read more

Today I discovered that DefaultMember might result in a member other thant the default dimension member. Reading documentation , I got the idea that DefaultMember would be always the default member defined for a dimension into a cube. In reality, the  Read more

My backlog makes me late on a lot of announcements, but I’d like to post a link to the new MDX Studio by Mosha Pasumansky , because this is a very useful tool when you need to dig into an MDX query issue. There is a forum dedicated to the tool on SSAS  Read more