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

I just posted this bug on the Microsoft Connect site. Please vote it if you think it would be a useful change. This is the issue description. If you set the”Aggregation Usage” to true for an attribute of a dimension (i.e. Customer), you cannot run the  Read more

I found an interesting “how-to” guide to Excel 2007 Pivot Table. It is a sample chapter from the Pivot Table Data Crunching for Microsoft Office Excel 2007 book. Probably not all the described feature are available in a Pivot Table attached to an Analysis  Read more

I have been notified of this strange bug in Analysis Services 2005 that is easily reproducable. ****************************************************************** PLEASE DO NOT TRY THIS TEST ON A PRODUCTION SERVER! IT HANGS ANALYSIS SERVICES!!! ******************************************************************  Read more

I am proud to announce that SQLBI community will be at the Microsoft Business Intelligence Conference 2007 (May 9-11, 2007 – Seattle). You can meet me and Alberto Ferrari in the User Group Area, booth #532 . We will try to make our booth visible with  Read more