A comment received by one reader of Programming LINQ suggested me to underline a concept that is not so intuitive using LINQ, especially if you come from years of SQL coding. The idea is very simple. Two entities in LINQ might be related in the model.  Read more

I worked on Data Mining solutions years before Microsoft added it to Analysis Services. It is an interesting domain for everyone, but it becomes really hard to explain how it works when you scratch the surface. At the last TechEd Developers I watched  Read more

I and Paolo Pialorsi have been interviewed at TechEd by Ken Rosen. We talked about our experience as book authors of Programming LINQ . If you are interested in writing a book, or if you simply want to see our faces and hear our italian accent, you can  Read more

I’m already in Orlando for TechEd 2008 Developers . Tomorrow I and Paolo Pialorsi will be at the TechEd bookshop for a book signing of our just released Programming Microsoft LINQ , scheduled at 4:00PM-4:30PM. I wrote a post a few days a go with the list  Read more

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