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...Continue Reading
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...Continue Reading
I will be speaking at the Power BI Fest next weekend.
The topic will be how to analyze your Azure Cost with Power BI. This gives many benefits compared with the native functionality in the Azure portal, for example speed and options to customize.
The result of this can look like the following:...Continue Reading
I have presented at The Data Blaster Community Conference on October 15th 2021. It was an honor to be part of a conference with many great speakers.
This was based on my previous blog post on chocolatey.
Moreover, based on the received feedback I have added my investigations of
winget to the...
To work with an Azure Data Platform efficiently there is many tools that one should be aware of. However, installing them and keeping them current is a tedious job. In this post, I will describe which tools are needed for developer of a standard data platform on Azure with a focus on Data Warehousing. Moreover, I will explain how to install and keep everything updated with Chocolatey.Continue Reading