Davy's Blog

The Belgian SQL Server User Group offers a significant 35% discount for its members (even more than early bird discount) for any PASS European Conference 2010 registration. Use discount code BEC15Y and enjoy your savings on your registration. For more information check our SQLUG website. PASS European Conference 2010 is Europe’s premier conference for SQL [...]

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode.

I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception.
The report was kind of big, so [...]

SQL Server Service Broker and some of the things it can do for you” is brought to you by Nico Jacobs and will take place on February 11th. Since SQL server 2005, it is possible to build a Service Oriented Architecture (SOA) inside SQL Server.
The component that enables this is the service broker, a message [...]

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 [...]

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 than [...]

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio.
The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]

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 :

No [...]

On September 24th, we kick off a new year of SQLUG events.
To be sure we kick-off properly, we hired a top-speaker, namely Dirk Gubbels. Dirk is one of our best guest speakers and by far one of the best SQL Server professionals.
Dirk Gubbels is a senior consultant at Microsoft, and has been working with SQL [...]

This event is brought to you by InfoSupport and handles the implementation of BI within a SAAS concept.
Agenda Oscar Zonneveldand and Josquin Booij from InfoSupport will discuss the following topics:

1. The Business Case2. The Functional and Technical Architecture3. Near-realtime BI4. The Real world
About the speakers
Oscar Zonneveld is a BI and Datawarehouse Architect at Info Support’s [...]