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 …
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…
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