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

Book Review – Learning Pentaho Data Integration 8 CE

Yes, you’re reading that right. A book not about the Microsoft BI stack. At a project, Pentaho Data Integration (PDI) was used as an ETL tool. To get to know this tool a little better, I bought the book Learning Pentaho Data Integration 8 CE (Third Edition) by the author… Read more

0 comments, 278 reads

Posted in Koen Verbeeck on 26 September 2018

Community Engagements Second Half of 2018 – It’s all about Biml

I have a couple of community engagements coming up in the second half of 2018 and I’d like to share an overview with you. Some might remember my Biml meetup session at the start of this year. Basically I turned this session into two talks: an introduction to Biml… Read more

0 comments, 237 reads

Posted in Koen Verbeeck on 31 July 2018

Book Review – Factfulness by Hans Rosling

I recently bought the book Factfulness – Ten Reasons we’re wrong about the world – And why things are better than you think by Hans Rosland (with Ola Rosling and Anna Rosling Rönnlund). The book is a fascinating read and I recommend it to everyone. Not just people working with… Read more

1 comments, 2,519 reads

Posted in Koen Verbeeck on 15 July 2018

Installing SSDT for Visual Studio 2017

I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it. I also have SSDT for VS 2015 installed, as an add-on in Visual Studio 2015 Enterprise (because that’s the only way to get TFS working in VS 2015). I… Read more

1 comments, 1,704 reads

Posted in Koen Verbeeck on 19 June 2018

Introduction to Biml – Webinar

On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your SSIS packages from scratch. In this webinar, I’ll introduce the Biml language and its concepts and show you how you can generate multiple SSIS packages using metadata. Read more

0 comments, 185 reads

Posted in Koen Verbeeck on 29 May 2018

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, 227 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, 243 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,758 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

4 comments, 2,811 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,721 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, 223 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, 238 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, 395 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, 3,033 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, 276 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, 276 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, 462 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, 275 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, 289 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, 1,091 reads

Posted in Koen Verbeeck on 18 December 2017

Older posts