Davy's Blog

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks

Opening Keynote by Wesley Backelant and Ritchie Houtmeyers
Best Practices for SQL Server Consolidation by Tom Van Mulders
Breaking the ETL world record with Integration Services by Henk van der Valk
Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb
High availability for BI DWH [...]

I recently struggled with the following challenge in Analysis Services:
In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″.

bing brought me to the following great article, where Mosha explains how [...]

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties.
When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]

Today I got this error while trying to browse a cube from the Business Intelligence Development Studio:

The detailed error information told me that the connection failed, because the server actively refused it. Connecting from another pc worked perfectly, so it had to be a problem with my computer.
To solve this problem I needed to reinstall the [...]