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 Data Warehouse Architecture DB2 Drivers Dimensional Modeling Drill-Through Results ETL Events General iif-function Internet Explorer 9 Multidimensional O365 OAuth 2.0 OLEDB Drivers Parameter Sniffing PASS PASS Summit Performance Power BI PowerShell Presentations Report Builder 3.0 Reporting Services SharePoint 2010 SQL Saturday SQL Saturday SQL Server SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SSAS 2008 R2 SSIS SSRS 2008 R2 SSRS 2012 T-SQL Tabular Temporal Fact Table