Archives
-
SQL Server Day 2009 videos now available on Chopsticks
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 [...]
Dec 16th, 2009 | Filed under .Net, Analysis Services, BI, Event, Events, Excel Services, Integration Services, MDX, MOSS, Office, PowerPivot, Reporting Services, SQL 2008 R2, SQL Server, SQLUG.BE -
SSAS: Custom format string for “duration” using MDX
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 [...]
Dec 7th, 2009 | Filed under Analysis Services, BI, Excel, MDX, SQL 2008 R2, SQL Server, SQLServerPedia -
SQL Server Day 2009
On Thursday, the 3rd of December 2009 SQLUG.BE (The Belgian SQL Server User Group) and Microsoft are teaming up to organize the second Belgian SQL Server Day. Focus of the day is off course SQL Server. Last year, SQL Server Day 2008 was the biggest community driven SQL Server event in the Benelux, with more [...]
-
Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)
Today I wanted to start playing around with the new Report Manager of SQL 2008 R2. After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2 I got a very empty Report Manager : Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 [...]
