-->
SQL Clone
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.

T-SQL Tuesday #99 – Door #2

This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll… Read more

1 comments, 115 reads

Posted in Koen Verbeeck on 13 February 2018

T-SQL Tuesday #99 – Door #1

This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll… Read more

4 comments, 160 reads

Posted in Koen Verbeeck on 13 February 2018

Session Materials – Biml DataMinds

All of the materials for my Biml session for DataMinds.be can be downloaded from Github:

  • the slidedeck (it’s only 12MB :))
  • a .sql file with the DDL statements to create objects (schema, tables, views, stored procs, functions) in a database called Biml (which you have to create yourself). Along…

Read more

0 comments, 138 reads

Posted in Koen Verbeeck on 25 January 2018

DataMinds.be Meetup – Biml

First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and otherwise. And what better way to start the new year with a user group session? On Thursday 25th of January 2018 I will be giving an evening session for dataminds.be Read more

1 comments, 143 reads

Posted in Koen Verbeeck on 8 January 2018

Connect is dead! Long live feedback.azure.com!

After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been found: feedback.azure.com. It’s not all about Azure, the link goes to the relevant portion of SQL Server. I’m glad for this change, as Connect could sometimes be… Read more

0 comments, 893 reads

Posted in Koen Verbeeck on 18 December 2017

Book Review – The Biml Book

After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and Data Warehouse Automation) and I can tell you immediately it’s the best Biml book I’ve ever read! (haha, it will take a while until this joke… Read more

1 comments, 450 reads

Posted in Koen Verbeeck on 4 December 2017

SQL Server Data Tools 2017 and TFS Integration

I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no Visual Studio extension for SSIS, so if you want to create SSIS projects you still need to install SQL Server Data Tools (which makes it a bit useless that… Read more

0 comments, 455 reads

Posted in Koen Verbeeck on 30 November 2017

Microsoft Professional Program in Data Science – The Finish Line

In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this program before:

I’m happy to announce I got the certificate: Read more

7 comments, 1,829 reads

Posted in Koen Verbeeck on 21 November 2017

Installing the MDS add-in for Excel 2016

For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to install the add-in for SQL Server 2012 on a machine that has Office 2016 64-bit installed. I clicked on the link in the MDS webpage which send me to the… Read more

1 comments, 363 reads

Posted in Koen Verbeeck on 15 November 2017

Can’t Connect to Analysis Services – Invalid Connection Information

I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried to connect to the SSAS instance for the first time, and I was greeted with the following error:

“Invalid connection information to establish the server connection”

I was using SSMS… Read more

1 comments, 377 reads

Posted in Koen Verbeeck on 30 October 2017

Error Installing SQL Server 2017

A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for the usual features (database engine, SSAS, SSIS, SSRS and MDS), but the installation failed for the database engine and SSIS. During the set-up, I received two pop-ups notifying that something… Read more

1 comments, 622 reads

Posted in Koen Verbeeck on 20 October 2017

dataMinds Connect 2017 – And The Winner Is?

Last week I had the privilege to host a little contest to give away one free ticket to dataMinds Connect 2017, the biggest Microsoft Data Platform conference in the Benelux. There was a prize question you had to answer:

How many versions of SQL Server have I worked with? Read more

1 comments, 231 reads

Posted in Koen Verbeeck on 25 September 2017

dataMinds Connect 2017 (win a ticket!)

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m talking about, dataMinds Connect is the new name of the SQL Server Days (the biggest Microsoft Data Platform event in the Benelux). I’ve been a regular speaker at the… Read more

9 comments, 175 reads

Posted in Koen Verbeeck on 18 September 2017

Error Processing Tabular – Method Not Found

Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012, I was greeted with the following error while processing a Tabular model:

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a…

Read more

0 comments, 230 reads

Posted in Koen Verbeeck on 15 September 2017

CALCULATE and FILTER: A Love Story?

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course):

In this… Read more

6 comments, 1,758 reads

Posted in Koen Verbeeck on 6 September 2017

The Wait Is Over – SSIS 2017 Is Here!

UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post SQL Server Data Tools 2017 and TFS Integration.

Finally, months after the release of SSAS and SSRS projects for VS 2017, we have the ability to create SSIS projects… Read more

10 comments, 496 reads

Posted in Koen Verbeeck on 23 August 2017

Fix for Blurry SSMS in Windows 10

I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a bit blurry on my laptop screen. On another screen, it looked fine though. The cause for this is easy to find in the display settings. My primary screen is scaled… Read more

4 comments, 566 reads

Posted in Koen Verbeeck on 14 August 2017

Two Small Tips for Working with Azure

Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up a project where the data warehouse needed to be fully in the cloud. This was an Azure SQL Database, not Azure Data Warehouse. The size of the DWH was just… Read more

0 comments, 335 reads

Posted in Koen Verbeeck on 10 August 2017

SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server

A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error:

A .NET Framework error occurred during execution user-defined routine or…

Read more

0 comments, 590 reads

Posted in Koen Verbeeck on 8 August 2017

Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes

I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher.
Title:… Read more

0 comments, 185 reads

Posted in Koen Verbeeck on 7 August 2017

Older posts