I and Alberto have posted a suggestion on Microsoft Connect to improve aggregation wizard behavior in a future version of SQL Server. The idea is to give an aggregation usage priority to dimension attributes for each cube or measure group. If you find  Read more

David Shroyer published an interesting paper about a Different Approach to Implementing Time Calculations in SSAS . It is something I would have found the time to write since Analysis Services 2000 (I have being using a similar approach since then) and  Read more

During the Microsoft Business Intelligence Conference 2007 we distributed a free printed copy of The Many-to-Many Revolution to attendees who visited our booth. Now the same book can be ordered on Lulu.com paying only the print and shipping costs (we  Read more

The Microsoft Business Intelligence Conference 2007 has been a good conference. Not very good, probably as a result of its success. Microsoft wanted to send the message “we are serious in the BI market” with this event. From my perception, half of attendees  Read more

Now that our presence as exhibitor is finished (Day 3 is only for keynote and breakout sessions), we can say that we had a great success! We distributed all the 300 copies of The Many-to-Many Revolution paper we printed just to show the kind of content  Read more

The first Microsoft BI Conference started today and we received a lot of people at our booth. Thank you to all the people who came to visit us!  Read more

Usually I blog about Business Intelligence, but BI is not the only field I work on. I born as developer and I recently co-authored a book about LINQ with Paolo: the title is Introducing Microsoft LINQ , we created a dedicated site where you can find blog  Read more

In the last two years I worked on advanced modeling with Analysis Services. One result of this was the paper ” The many-to-many revolution ” I released in September 2006. Since then, I got a lot of feedback and I have been working on other evolutions  Read more

Almost two months ago I wrote a post about the lack of multi-phase data pump control in Management Studio “legacy” user interface for DTS. Microsoft answered that documentation has the workaround I have found using RegEdit… In the meantime, I received  Read more

Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer . It’s a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank  Read more