Davy's Blog

Dear SQLUG member, We are happy to announce our first user group session of 2011…CSI style! Tom Van Zele will bring us SQL Server Forensic Analysis – Playing CSI with databases. You get a call from a colleague who thinks that his financial information system has been hacked. Of course this system uses a SQL Server [...]

Installing the report server in SharePoint integrated mode, really gives you the possibility to offer a great reporting frontend to your users. But a few days ago I came across a real nasty bug: I just tried to rename one of the reports, what should be an easy thing to do, but I got this [...]

Mark your calendar for the 29th of September for the “Ask The Experts” event. SQLUG teams up again with Microsoft to organize this panel of hardcore SQL Server experts with Wesley Backelant(MSFT), Frederik Vandeputte(MVP), Dirk Gubbels(MSFT) and Gunther Beersaerts(MSFT). Starts: 19:00 Location: Microsoft België Send your SQL Server related questions to asktheexperts@sqlug.be. We will answer [...]

At a current project I needed to create a deploy script for the MDX calculations of a cube. SQL Server Management Studio makes it very easy for you to create XMLA-scripts to create or alter cubes, dimensions, etc… But it’s not possible to use Management Studio to create an alter-script that only contains the MDX [...]

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]

Managing SQL Server requires insight in the state and performance of the underlying infrastructure, OS and individual SQL components. System Center Operations Manager 2007 R2 cannot only give you that insight, but it can be reused in a broader application/service monitoring view. This session focuses on the out-of-the-box capabilities of System Center Operations Manager 2007 [...]

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

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

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