-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Archives: May 2016

Conditional Formatting and Quick Calcs in Power BI Desktop

There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet.
However, two great new features have been spotted by Chris Webb:

Read more

2 comments, 2,092 reads

Posted in Koen Verbeeck on 31 May 2016

Reblog: Unexpected result with the File System Task

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies.

Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services.… Read more

2 comments, 1,006 reads

Posted in Koen Verbeeck on 24 May 2016

Speaking about Power BI @ ITPROceed 2016

I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this event, it’s an IT Pro focused event in Belgium about Microsoft Technologies. And what’s even better, it’s totally free.

My session will be a general overview of what you… Read more

0 comments, 352 reads

Posted in Koen Verbeeck on 19 May 2016

SSRS and MDX: Think about Cell Properties

I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about… Read more

0 comments, 328 reads

Posted in Koen Verbeeck on 4 May 2016