250 blog posts

Last week, I noticed that I published my 250th blog post. I'm not sure if it's something to celebrate (I'm not really someone who celebrates things), but it is an extra reason to write a new post. Endurance I started writing in 2018 after Brent Ozar suggested I do this. He also told me that … Continue reading 250 blog posts

Azure Synapse Analytics performance, an analysis

Some time ago, a client came up with a very intriguing question. As I love a challenge, especially when you get to dig deep into a toolset, I jumped at the occasion and went for it. The following is a write up about the steps taken to analyse. Both for future me when I run … Continue reading Azure Synapse Analytics performance, an analysis

DP-700 Training: Data transformation options

Welcome to my Ted Talk, data transformation is done in T-SQL. Thank you. Well, yes once upon a time, maybe. Nowadays there are many more ways that lead to the dark side (also known as data vault) and the happy side (also known as the star schema or dimensional model). Did I lose you yet? … Continue reading DP-700 Training: Data transformation options

Creating Azure Synapse Link for Dynamics: Step-by-Step Guide

I had an interesting morning trying to connect Dynamics to a Data lake. As you might know, there was a feature where Dynamics would create a Data lake for you. This choice will cease to exist quite soon and to offer alternatives, you can create an Azure Synapse Link or Fabric Link. This blog will … Continue reading Creating Azure Synapse Link for Dynamics: Step-by-Step Guide