Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Overview of Published Articles – 2014Q1

Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an overview from time to time to keep track of all the published material. It makes it easier to follow and it’s also a chance for me to… Read more

0 comments, 47 reads

Posted in Koen Verbeeck on 15 April 2014

SSIS Performance Testing

I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I used in a blog post.

First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a… Read more

2 comments, 1,213 reads

Posted in Koen Verbeeck on 8 April 2014

Changing the 1000 separator in Power View

Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this:

For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the… Read more

0 comments, 87 reads

Posted in Koen Verbeeck on 11 March 2014

Thinking with Data by Max Shron

DISCLAIMER

I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for free per month so I can review it on my blog. This works in both ways of course: I get free eBooks while they’re still hot from the press… Read more

0 comments, 99 reads

Posted in Koen Verbeeck on 27 February 2014

Dude, where’s my Power Map?

If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update:

  • Downloading and installing service pack 1, aka the…

Read more

0 comments, 1,268 reads

Posted in Koen Verbeeck on 26 February 2014

Dealing with the mysterious “True” column in BIML

Recently I ran into the following error when compiling BIML into SSIS packages:

The message itself is not very revealing:

The data type for input buffer column ‘True’ on the ScriptComponent input buffer ‘Input0’ does not match the mapped output column from the previous transformation.

You might have guessed it… Read more

0 comments, 181 reads

Posted in Koen Verbeeck on 18 February 2014

Calculating the length of a hash in SQL Server

Some time ago I added a script component to a few SSIS packages to compare rows with each other using a hash to check if they had actually changed or not. In the output of the script component, I had chosen a string data type for the calculated hash with… Read more

2 comments, 96 reads

Posted in Koen Verbeeck on 11 February 2014

Master Data Services (Second Edition) – Review

For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham.

I had almost no prior experience with MDS up to this… Read more

0 comments, 146 reads

Posted in Koen Verbeeck on 31 January 2014

Star Schema The Complete Reference – Review

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit, a senior colleague of mine recommended the book Star Schema The Complete Reference by Christopher Adamson. To be honest, I had never heard about it. But… Read more

3 comments, 180 reads

Posted in Koen Verbeeck on 23 January 2014

T-SQL Tuesday #50: Automation, how much of it is the same?

It’s the second Tuesday of the New Year, so here comes the first T-SQL Tuesday of 2014! SQLChow (blog | twitter) has the honour to host this jubilee edition of the world famous blog party. The theme of this month is the utterly DBA-related topic of Automation.… Read more

0 comments, 98 reads

Posted in Koen Verbeeck on 14 January 2014

Happy 2014

I am a bit late with the almost obligatory “How was my past year and how do I think next year is going to rock” blog post – we’re already a good week into the new year – but without further ado I present you: How was my past year… Read more

0 comments, 51 reads

Posted in Koen Verbeeck on 7 January 2014

Nominated for the Tribal Awards

I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are not for some tattoos on your lower back or on your biceps, but rather a collaboration of Simple-Talk and SQLServerCentral to give outstanding community contributors the chance to receive… Read more

2 comments, 49 reads

Posted in Koen Verbeeck on 19 December 2013

Nominated for the Tribal Awards

I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are not for some tattoos on your lower back or on your biceps, but rather a collaboration of Simple-Talk and SQLServerCentral to give outstanding community contributors the chance to receive… Read more

10 comments, 183 reads

Posted in Koen Verbeeck on 19 December 2013

SQL Server 2012 Reporting Services Blueprints – Review


Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe (blog|twitter). My former colleague Valentino was the technical reviewer for this piece – he wrote about it here – so I was… Read more

2 comments, 68 reads

Posted in Koen Verbeeck on 12 December 2013

Master Data Services stops working after an upgrade

Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional. However, one of the instances also has Master… Read more

0 comments, 60 reads

Posted in Koen Verbeeck on 27 November 2013

Master Data Services stops working after an upgrade

Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional. However, one of the instances also has Master… Read more

10 comments, 155 reads

Posted in Koen Verbeeck on 27 November 2013

Create ETL solutions faster with metadata driven development – Session Materials

Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great audience, fantastic speakers and nice booths by the sponsors (especially the bar with Belgian beer was pretty awesome). It was great meeting up with the #sqlfamily again.

Anyway, I gave… Read more

10 comments, 200 reads

Posted in Koen Verbeeck on 13 November 2013

Create ETL solutions faster with metadata driven development – Session Materials

Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great audience, fantastic speakers and nice booths by the sponsors (especially the bar with Belgian beer was pretty awesome). It was great meeting up with the #sqlfamily again.

Anyway, I gave… Read more

5 comments, 58 reads

Posted in Koen Verbeeck on 13 November 2013

The times they are a-changin’

This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.

The most important one is my switch to a new employer. After almost 3 years being happily employed at Ordina Belgium, I’ll move to element61 in November. element61 is a…

Read more

2 comments, 46 reads

Posted in Koen Verbeeck on 29 October 2013

The times they are a-changin’

This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.

The most important one is my switch to a new employer. After almost 3 years being happily employed at Ordina Belgium, I’ll move to element61 in November. element61 is a…

Read more

10 comments, 196 reads

Posted in Koen Verbeeck on 29 October 2013

Older posts