In one of my projects we have been migrating a Cube from an on Prem SQL Server Analysis Services Instance (SSAS) to Power BI Premium/Fabric Semantic Models. With XMLA endpoints migration is a breeze and one can easily use Tabular Editor to deploy the same model to onPrem and the Cloud.

In the re...

Today, I have been back at the University of Münster to give a lecture on "Azure DevOps Build, Deploy, Pull Requests and Testing for your Data Warehouse" for a crowd of students. During my preparation it was amazing to see that today’s scientific literature has a focus on the Microsoft Intelligent...

I have presented at SQL Konferenz in Hanau. The event took place from Septmber 11th to September 13th in Hanau.

After an interesting event about Synapse with the Microsoft team (e.g. Gabi Münster | Kasper de Jonge | Luke Moloney and Jovan Popovic) After Covid-19 pause it was great to meet...

Every Data Warehouse consists of lots of SQL code. While previously all business transformations have been handled in SSIS, in recent times I have often seen more and more logic handled in Stored Procedures. Stored procedures have the benefit that they run onPrem and on Azure and are cost efficient...

After five interesting years at avanade I join noventum consulting this month again. I worked for noventum already from 2012 to 2017. Noventum is a small consulting boutique with a team of experienced business intelligence and data warehouseing experts on Microsoft technology.

I will join ther...

I have presented at Power BI Fest on November 20th 2021. It was an honor to be part of a conference with many great speakers.

For the resources used in the presentation and more details please have a look at my previous blog post.

You find the deck here: PDF