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

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

Not every SQL is created equal

Yes I know, clickbaity cheesy title. This blog is a bit like that, but maybe you'll learn something as well. Issue In short, what I was facing today was a trial migration from System A to System B. Which means that data has to flow from one system to the other. System A is a … Continue reading Not every SQL is created equal

T-SQL Tuesday #159 – What’s Your New Favourite Feature?

This month Deepthi Goguri invites us (the community) to write about two topics: our favourite new feature of SQL Server 2022 and your new years resolutions. You can find her blog here, her LinkedIn profile here and she's also on Twitter here. Favourite new SQL Server 2022 feature Most of my work is in data … Continue reading T-SQL Tuesday #159 – What’s Your New Favourite Feature?