Davy's Blog

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

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

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

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

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

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

Dear readers, I’m proud to announce officially Community Day 2009, the third edition of a full day of community driven content on Microsoft technologies. The event will take place on Thursday June 25th 2009. For the first time, the event will be a full day of free sessions. Also new is the location: we have [...]

Ever tried to change the URL of the Report Manager in IIS using host headers? I did, but got the following error message when I tried to open the Report Manager: “The request failed with HTTP status 400: Bad Request”

Next UG-evening – The Holy Trinity: Indexes, Execution Plans and the optimizer This UG-evening will start with an introduction of the basics of index design (the heap,clustered/non clustered indexes and covering of a query by an index). Later we will discuss how the optimizer works, why it can be wrong (statistics, procedure cache) and how [...]

In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either [...]