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.

SSIS Naming Conventions 2.0

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more

0 comments, 103 reads

Posted in Koen Verbeeck on 2 December 2016

Problem where you can only browse Google websites

Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here

Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out… Read more

0 comments, 104 reads

Posted in Koen Verbeeck on 1 December 2016

Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all… Read more

0 comments, 155 reads

Posted in Koen Verbeeck on 24 November 2016

SQL Server 2016 service pack 1 is here!

SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why, you ask, is it so important? Because a lot of Enterprise Edition database engine features are now available in the other editions as well. In other words, you… Read more

0 comments, 1,530 reads

Posted in Koen Verbeeck on 22 November 2016

Book Review – Power Pivot and Power BI

Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website for quite some time now and they always have very insightful articles about DAX and… Read more

0 comments, 1,421 reads

Posted in Koen Verbeeck on 15 November 2016

Master Data Services – Database Error has Occured when Publishing Business Rule

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016. In that demo, I created a business rule to test out the extension with custom scripts. When the business rule was finished, I tried to publish it. But, I was… Read more

1 comments, 675 reads

Posted in Koen Verbeeck on 31 October 2016

First thoughts on Power BI on premises

The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises using Reporting Services! The preview itself is a VM hosted in Azure. You can read all about setting it up in the SSRS team blog post.

I toyed around… Read more

0 comments, 2,128 reads

Posted in Koen Verbeeck on 27 October 2016

Master Data Services error – Cannot read configuration file due to insufficient permissions

In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my system. Otherwise it would be quite hard to give demos, of course. The installation itself went quite smooth, no remarks there. I also enabled Internet Information Services (IIS) on my… Read more

0 comments, 155 reads

Posted in Koen Verbeeck on 23 October 2016

What’s new in SSRS 2016 – Session Contents

The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was very nice meeting up with the #sqlfamily again. I had a session about the new features in SSRS 2016. I was so excited that I could do a… Read more

0 comments, 184 reads

Posted in Koen Verbeeck on 14 October 2016

My thoughts on Recertifying your MCSE through Microsoft Virtual Academy

A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in my blog post How I prepared myself for the MCSE certification. As you might know, this certification is only valid for 3 years. My certification should… Read more

16 comments, 299 reads

Posted in Koen Verbeeck on 13 October 2016

Upcoming Webinars: What’s New in SSRS and MDS 2016

I’ll be delivering two webinars for in the coming months. The first one is about the – amazing – new features in Reporting Services 2016.

SQL Server Reporting Services is Microsoft’s corporate reporting tool. The SQL Server 2016 release marks one of the biggest evolutions of the product since…

Read more

0 comments, 170 reads

Posted in Koen Verbeeck on 4 October 2016

Power BI Desktop hosted on premises with SSRS 2016

UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the SSRS Team blog. You can also find my first impressions of the preview in the blog post First thoughts on Power BI on premises.

At Microsoft Ignite, it’s… Read more

10 comments, 2,800 reads

Posted in Koen Verbeeck on 28 September 2016

SSRS Mobile Reports – JSON error

Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS 2016, using the Mobile Report Publisher. I created the following query on top of the Wide World Importers data warehouse:

	,c.[State Province]
	,c.[Sales Territory]

Read more

0 comments, 248 reads

Posted in Koen Verbeeck on 14 September 2016

Bigger Fact Table for Wide World Importers

Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One… Read more

1 comments, 1,312 reads

Posted in Koen Verbeeck on 12 August 2016

Webinar – What’s new in SSIS 2016

I’ll be giving a webinar on the new features of Integration Services 2016.

When? August 11, 2016
Where? On the website. You can register here.

SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this webcast, we will take a look at which…

Read more

0 comments, 221 reads

Posted in Koen Verbeeck on 28 July 2016

An update on AutoAdjustBufferSize in SSIS 2016

This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible.

Anyway, one of the particular updates that caught… Read more

0 comments, 439 reads

Posted in Koen Verbeeck on 27 July 2016

Overview of Published Articles – 2016Q2

Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:

Read more

0 comments, 246 reads

Posted in Koen Verbeeck on 22 July 2016

Slidedeck ITPROceed – Power BI Status Update

I uploaded my slidedeck from the ITPROceed event to For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.

Read more

0 comments, 267 reads

Posted in Koen Verbeeck on 28 June 2016

My first SQL Server 2016 POC

Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course
One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of… Read more

4 comments, 3,035 reads

Posted in Koen Verbeeck on 9 June 2016

Older posts