Marco Russo's Blog posts of 2007
Microsoft BI Conference 2007 comments
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
SQLBI at MS BI Conference 2007 – Day 2
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
SQLBI at Microsoft BI Conference 2007 – Day 1
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
Introducing Microsoft LINQ book
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
SSAS: Model on the server vs. client-side MDX
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
A better solution to control multi-phase data pump in DTS editor
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
SSAS Performance Tools
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
Aggregation Usage issues with a measure group not linked to a dimension
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
An useful guide to Excel 2007 Pivot Table
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
Strange bug in SSAS 2005
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