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.

Author of the Year at MSSQLTips.com

I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at the MSSQLTips.com website!
I am humbled by the recognition of my fellow peers in the SQL Server community and I’d like to thank all of you, the #sqlfamily, for voting. Read more

2 comments, 72 reads

Posted in Koen Verbeeck on 13 January 2015

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty permission issue I encountered with SSIS. At a new project, someone mentioned me that a scheduled job has been failing for quite some time now (actually since they created the… Read more

1 comments, 112 reads

Posted in Koen Verbeeck on 9 January 2015

Better late than never…

Just like last year, I’m a bit late with the obligatory “how was last year and what is this year supposed to bring” blog post. Anyway, here it is. Let’s start by wishing every one of you the very best for the new year. I hope 2015 may bring… Read more

0 comments, 107 reads

Posted in Koen Verbeeck on 8 January 2015

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.

INTENSE SCHOOL

The third and final part of this series will probably be published this month, so… Read more

0 comments, 152 reads

Posted in Koen Verbeeck on 7 January 2015

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read it I’ll summarize it quickly: it explains how to create an MDX formula that formats durations into an [hh]:mm:ss format, where [hh] can go over 24 hours. For more… Read more

0 comments, 122 reads

Posted in Koen Verbeeck on 22 December 2014

Nominated for the 2014 Tribal Awards

Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:

The Tribal Awards, co-hosted by Simple-Talk and SQLServerCentral, seek to recognize outstanding members of the SQL community. We want to highlight people who are currently leaders due to their writing, speaking, or general community…

Read more

0 comments, 135 reads

Posted in Koen Verbeeck on 18 December 2014

PASS BI VC recording is available now

The recording of the webinar I did for the PASS BI virtual chapter is live!
(Quick reminder: it was the same session as on the SQLServerDays: How to (not) torment your fellow SSIS developer?)

I’m quite pleased with the recording, although I sound like a drunk German scientist sometimes. Read more

0 comments, 130 reads

Posted in Koen Verbeeck on 5 December 2014

Beware the defaults! (in windowing functions) – The Movie!

I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their SQL Server classes, they are doing a free series called SQL Server Solutions from the Web where they show different SQL Server solutions found in blog posts around… Read more

4 comments, 128 reads

Posted in Koen Verbeeck on 27 November 2014

Nominated for Author of the Year

I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post

You can vote for me at the following URL:

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note… Read more

1 comments, 105 reads

Posted in Koen Verbeeck on 20 November 2014

PASS BI VC: How to (not) torment your fellow SSIS developer?

On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS developer? for the PASS BI virtual chapter. This is great news for the people who couldn’t attend my session at the SQL Server Days and who still want to… Read more

6 comments, 169 reads

Posted in Koen Verbeeck on 12 November 2014

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).

Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who…

Read more

3 comments, 340 reads

Posted in Koen Verbeeck on 14 October 2014

Beware the defaults! (in windowing functions)

Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the last date an event had occurred for each type of event. Let’s illustrate with an example:

CREATE TABLE dbo.TestOver
	(ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL
	,[Group] CHAR(1) NOT NULL…

Read more

5 comments, 5,696 reads

Posted in Koen Verbeeck on 7 October 2014

SQL Server Days 2014 – Slide deck

SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers! My session went pretty well, somewhere around 60 attendees I would guess and they didn’t seem too bored. I saw some other great sessions as well, such as Buck Woody… Read more

0 comments, 174 reads

Posted in Koen Verbeeck on 6 October 2014

The Magic Alt Button

Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text.

Note that this is not an… Read more

9 comments, 152 reads

Posted in Koen Verbeeck on 23 September 2014

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder:

Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I’ll have a solution online… Read more

1 comments, 6,524 reads

Posted in Koen Verbeeck on 21 August 2014

Tableau Data Visualization Cookbook – Review

After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh Nandeshwar. The book is published by Packt but I am relieved to say this time there were no significant editing issues. In fact it is quite well written and… Read more

2 comments, 189 reads

Posted in Koen Verbeeck on 8 August 2014

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, 399 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, 234 reads

Posted in Koen Verbeeck on 11 July 2014

Older posts