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

Techorama 2018 Session Materials

Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely organized. Big thanks to the organizers, sponsors and attendees of course.

My session on data modeling in self-service BI went really well (but I had some time left at the… Read more

0 comments, 111 reads

Posted in Koen Verbeeck on 25 May 2018

Issue while using SQLCompare against Azure SQL DB

I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate SQLCompare. When trying to specify my credentials, I got the following error: “Unable to load adalsql.ddl”.

Following that link actually leads you to a helpful page, where you can… Read more

0 comments, 130 reads

Posted in Koen Verbeeck on 15 May 2018

Change SSAS Tabular Data Source using TOM

We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server using Visual Studio. Whoops, you forgot to change the server name in the data sources, so now your Tabular model in production is trying to read from the test database.… Read more

1 comments, 1,496 reads

Posted in Koen Verbeeck on 8 May 2018

Connect to Power BI Report Server with SSMS

Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security role or modify an existing one. Recently I tried to log into our newly installed Power BI Report Server (March 2018 edition). I was greeted with the following error:

The…

Read more

0 comments, 2,342 reads

Posted in Koen Verbeeck on 2 May 2018

Stop Previewing the bim.layout File in SSAS Tabular

A quick blog post for future reference, because I know I’ll bump into this again someday.

When you’re working with a team on a Analysis Services Tabular project, you most likely will check your code into some sort of source control (yes, you do. If not, start tomorrow). One of… Read more

0 comments, 1,554 reads

Posted in Koen Verbeeck on 22 March 2018

Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel

As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book… Read more

1 comments, 135 reads

Posted in Koen Verbeeck on 15 March 2018

T-SQL Tuesday #100!

The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the Creator himself: Adam Machanic (blog | twitter). The topic is the future: what will the world be like when it’s T-SQL Tuesday #200?

The very first T-SQL Tuesday… Read more

0 comments, 168 reads

Posted in Koen Verbeeck on 13 March 2018

Excel Rendering In Power BI Report Server: You Are Not Licensed To Use This Feature

I recently migrated an SSRS 2017 instance to a Power BI Report Server environment, as you can read in the blog post Migrate SSRS 2017 to Power BI Report Server. After quite some issues, the PBI RS Portal worked and I could happily browse SSRS and Power BI Desktop… Read more

0 comments, 238 reads

Posted in Koen Verbeeck on 12 March 2018

Migrate SSRS 2017 to Power BI Report Server

UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try… Read more

5 comments, 2,522 reads

Posted in Koen Verbeeck on 8 March 2018

Data Modeling for Self-Service BI @ Techorama 2018

I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018 (the Internet is divided on the correct spelling: modelling or modeling. Apparently it depends on which side of the pond you’re on). Techorama is one of the biggest Microsoft-oriented tech… Read more

0 comments, 204 reads

Posted in Koen Verbeeck on 2 March 2018

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, 195 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, 370 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, 189 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, 196 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, 988 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, 642 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, 869 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, 2,191 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

2 comments, 537 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

3 comments, 663 reads

Posted in Koen Verbeeck on 30 October 2017

Older posts