Two sample chapters of my Programming Microsoft LINQ book are finally available. Links to download pages in the chapters title. Chapter 6 - Tools for LINQ to SQL In this chapter, we took a look at the tools that are available to generate LINQ to SQL entities  Read more

I'm still late with blog reading and sometimes I discover interesting things one or two months later than the original posting. I just read the SQLCAT analysis of the several solutions available to handle multiple parent-child hierarchies within a single  Read more

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

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

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

Darren Gosbell describes a useful technique to clear cache and execute an MDX statement using a single MDX command window. It's very very useful when you're doing performance tuning of your MDX script!  Read more