Finally, the Programming Microsoft LINQ book is available . We (I and Paolo Pialorsi, the other author) updated the website that supports our books ( http://programminglinq.com ), where you can download the sample code of the book. What’s in this book?  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

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