Click here to monitor SSC
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.

Reblog: SSIS Performance Testing

I had to do some performance testing for an 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 package… Read more

0 comments, 59 reads

Posted in Koen Verbeeck on 12 February 2016

The Future of SSMS

One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a separate installation. You heard that right (read, probably), no more dragging along those bulky .ISO files with the entire SQL Server set-up just to install some client tools. Just like… Read more

0 comments, 156 reads

Posted in Koen Verbeeck on 3 February 2016

Book Review – Expert Performance Indexing

A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in SQL Server for me to review. Since I know both the authors and since I’m familiar with the spectacular work they do, I was happy to do so. Doesn’t mean… Read more

0 comments, 1,201 reads

Posted in Koen Verbeeck on 2 February 2016

Reblog: Building the Script Component

SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components. 

The problem

From time to time I have to script out some logic using a Script Component in a SSIS package. Business as… Read more

0 comments, 133 reads

Posted in Koen Verbeeck on 28 January 2016

Book review – Extending SSIS with .NET Scripting

Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost van Rossum (blog | twitter). My .NET scripting knowledge could use an update, so I decided to read the whole book and provide you with a full… Read more

2 comments, 1,689 reads

Posted in Koen Verbeeck on 21 January 2016

T-SQL Tuesday #74: Be the Change

It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited… Read more

1 comments, 943 reads

Posted in Koen Verbeeck on 12 January 2016

Happy Holidays

It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do I plan to do next year?”. I plan on keeping it quite short

2015 was awesome because:

  • I got to speak on ITPROceed and SQLServerDays again, and it was great…

Read more

0 comments, 127 reads

Posted in Koen Verbeeck on 29 December 2015

Performance Tuning with sp_BlitzIndex

Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one of the many free scripts you can get from the great team at Brent Ozar Unlimited.

Recently I went to a client for a one day data warehouse… Read more

3 comments, 2,099 reads

Posted in Koen Verbeeck on 7 December 2015

Master Data Services Configuration Woes

Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re gonna get. Recently I ran into some troubles (or woes) when configuring MDS at a client. The installation went smoothly, as well as the installation of other prerequisites (like… Read more

2 comments, 862 reads

Posted in Koen Verbeeck on 24 November 2015

Reporting Services redesign – it’s the little things

SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing:

Read more

0 comments, 3,210 reads

Posted in Koen Verbeeck on 20 November 2015

Reblog: Data Visualization – Book Review

To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll give a short review for each one of them.

Information Dashboard Design

 This book, written by Stephen Few, was the first one I read. And it was…

Read more

0 comments, 901 reads

Posted in Koen Verbeeck on 12 November 2015

Webinar – What’s New for Business Intelligence in SQL Server 2016

I’ll be giving a webinar for on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server 2016 and its abstract goes like this:

The preview of SQL Server 2016 has been released right before the summer and it already seems this will be…

Read more

0 comments, 259 reads

Posted in Koen Verbeeck on 23 October 2015

Presentation Design – Before and After

Recently I gave a session on the SQL Server Days about the new features for business intelligence in SQL Server 2016. I have always found that the design of the slide deck matters and this time I was fortunate enough to have the assistance of 356labs, a presentation design… Read more

0 comments, 162 reads

Posted in Koen Verbeeck on 15 October 2015

What’s new for BI in SQL 2016 – Session materials

SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I… Read more

0 comments, 237 reads

Posted in Koen Verbeeck on 1 October 2015

New SSRS features in SQL 2016 CTP 2.4

SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features… Read more

0 comments, 1,157 reads

Posted in Koen Verbeeck on 30 September 2015

Why I hate Pie Charts

The pie chart should be avoided at all costs. Why?

  • you can only display a limited number of slices (although that doesn’t really stop people from creating pie charts with dozens of slices)
  • they take up a lot of space
  • the human brain cannot easily compare slices based on radial…

Read more

0 comments, 214 reads

Posted in Koen Verbeeck on 21 September 2015

Reblog: The Magic Alt Button

SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live action? You can watch my webcast on-demand where I demonstrate this trick. Start watching at around minute 38.

Lately I have been using more and more the awesomeness… Read more

0 comments, 264 reads

Posted in Koen Verbeeck on 17 September 2015

MDS 2016 CTP 2.3: tiles greyed out in Manager

I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI in SQL Server 2016. I uploaded the sample models into MDS and I opened up Master Data Manager in Internet Explorer to try out some of the new features. The… Read more

1 comments, 227 reads

Posted in Koen Verbeeck on 15 September 2015

Older posts