Martin's Blog

The hidden costs of Azure Data Factory’s managed virtual network

When Azure Data Factory (ADF) released the managed virtual network feature for Azure integration runtimes, it seemed like a no-brainer at first. Who wouldn’t want to isolate their ETL traffic without the need to manage the network infrastructure? A recent migration project made me look much closer look at this feature, and the cost implications …

April 12, 2022April 12, 2022

Owning my own business: Lessons learned from year four

I decided not to tempt 2021 with any challenging remarks, and I’m glad I didn’t because it showed up in a big way anyways. Let’s call it 2020, part deux…

April 5, 2022April 5, 2022

Dynamic column mapping in Azure Data Factory

One of the most appealing features in Azure Data Factory (ADF) is implicit mapping. The benefit of this is that I can create one dataset and reuse it multiple times and without explicitly mapping the source & destination columns. Compare that to Integration Services (SSIS) where columns have to be explicitly mapped and where metadata is validated before execution (forcing you to create granular-level packages), and you can understand why it is so appealing to anyone coming from that world…

March 22, 2022March 21, 2022

About Me

Hi, I’m Martin. I like to help people make sense of their data, using Microsoft technologies. This blog is my attempt at giving back to our awesome community, from which I have received so much. Hope you find it worth reading!

Subscribe to My Blog

Get new content delivered directly to your inbox.