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 …

Continue reading

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…

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.

Administration Analysis Services API Azure Azure AD Azure Data Factory Biml Business Intelligence Career Consulting Custom Visuals Data Warehouse Architecture DAX Dimensional Modeling Drill-Through Results ETL Events General iif-function Installation Internet Explorer 9 Multidimensional O365 OAuth 2.0 PASS PASS Summit Personal Power BI Power Query PowerShell Presentations Report Builder 3.0 Reporting Services SQL Saturday SQL Saturday SQL Server SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SSIS SSRS 2008 R2 SSRS 2012 T-SQL Tabular Temporal Fact Table