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.

Modeling the Agile Data Warehouse with Data Vault – Review

A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a local training provider. As part of the training, I received the book Modeling the Agile Data Warehouse with Data Vault written by Hans Hultgren who also is an instructor… Read more

0 comments, 99 reads

Posted in Koen Verbeeck on 17 July 2014

Creating a Matrix Infographic in SSRS

With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to display forecasts of World cup matches. An example:

I was wondering if something similar could be built using SSRS. And yes, it is possible and it isn’t… Read more

0 comments, 118 reads

Posted in Koen Verbeeck on 11 July 2014

Tableau Dashboard Cookbook by Jen Stirrup

DISCLAIMER

I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With Data. The actual publisher of the book is Packt Publishing, not O’Reilly itself.

TABLEAU DASHBOARD COOKBOOK

I guess most people who have been in contact with the… Read more

1 comments, 121 reads

Posted in Koen Verbeeck on 7 July 2014

Speaking at SQL Server Days 2014

I am absolutely delighted to share the great news that I have been selected as one of the speakers for the 2014 edition of the SQL Server Days in Belgium. It is one of the biggest SQL Server events in Europe and this will be the 4th time I am… Read more

1 comments, 114 reads

Posted in Koen Verbeeck on 4 July 2014

ITPROceed – Slide Deck and demo materials

ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very big thank you and “well done” to the organizers. It has been a great gathering of the #sqlfamily, with superb sessions about Azure, restoring databases with PowerShell, Hekaton… Read more

0 comments, 98 reads

Posted in Koen Verbeeck on 17 June 2014

Naked Statistics

A few weeks ago I stumbled up on this book review of Naked Statistics by Nathan Yau. The introduction on Amazon promises us the following:

Once considered tedious, the field of statistics is rapidly evolving into a discipline Hal Varian, chief economist at Google, has actually called “sexy.” From…

Read more

0 comments, 153 reads

Posted in Koen Verbeeck on 23 May 2014

SSRS Nugget: displaying placeholders when no rows are returned

A few days ago there was an interesting question on the forum:

How can I get None in each cell of a table in the report if no rows are returned? If I use “No rows message” property, header is not displaying on the report but I would like to…

Read more

4 comments, 1,255 reads

Posted in Koen Verbeeck on 15 May 2014

Speaking at ITPROceed

I’m delighted to announce I will be giving a session at ITPROceed, a new event in Belgium for the IT Professional. From their website:

ITPROceed is a joint effort between the ITProfessional User Groups with the strong support of Microsoft to bring you the best on the Cloud OS,…

Read more

0 comments, 118 reads

Posted in Koen Verbeeck on 14 May 2014

T-SQL Tuesday #54: An Interview Invitation

It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject is about interviews and hiring.

First I thought about writing a rant about the beginning of every interview and hiring process: recruiters. You can’t live with… Read more

2 comments, 150 reads

Posted in Koen Verbeeck on 13 May 2014

MDS: A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:

515: A database error has occurred. Please contact your system administrator

Too bad I am the system administrator on that machine…

Anyway, after some searching it came… Read more

0 comments, 168 reads

Posted in Koen Verbeeck on 18 April 2014

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, 96 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,918 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, 139 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, 153 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,358 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, 253 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, 163 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

2 comments, 218 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, 249 reads

Posted in Koen Verbeeck on 23 January 2014

Older posts