Azure Data Factory – Web Hook vs Web Activity

As Azure Data Factory continues to evolve as a powerful cloud orchestration service we need to update our knowledge and understanding of everything the service has to offer. Mainly, so we can make the right design decisions when developing complex, dynamic solution pipelines. In this post I want to explore and share the reasons for … Continue reading Azure Data Factory – Web Hook vs Web Activity

PowerShell Export Databricks Workspace Items – Recurse

Building on the excellent PowerShell Databricks module created by Gerhard Brueckl here, I've added another layer of code to recursively export all items in a given Databricks workspace using PowerShell. I accept this does need to be hardened as a PowerShell cmdlet on its own and added to a module. However, I wanted to share the … Continue reading PowerShell Export Databricks Workspace Items – Recurse

Using Data Factory Parameterised Linked Services

Microsoft recently announced that we can now make our Azure Data Factory (ADF) v2 pipelines even more dynamic with the introduction of parameterised Linked Services. This now completes the set for our core Data Factory components meaning we can now inject parameters into every part of our Data Factory control flow orchestration processes. Pipelines ✔ Activities … Continue reading Using Data Factory Parameterised Linked Services

Creating an Azure Data Factory v2 Custom Activity

Many moons ago and in a previous job role I wrote a post for creating an Azure Data Factory v1 Custom Activity here. According to Google Analytics this proved to be one of my most popular blog posts on that site. I therefore feel I need to do an update post with the same information … Continue reading Creating an Azure Data Factory v2 Custom Activity

What is Azure Data Factory Data Flow?

There were many great announcements to come out of the Microsoft Ignite 2018 conference, but the main one for me was the introduction of Azure Data Factory Data Flow. As a business intelligence person with many years experience working with SSIS packages this new feature is very exciting! Since I first saw the mock up … Continue reading What is Azure Data Factory Data Flow?

Preparing My Community Sessions for 2019

Hey friends & SQL family, its been a great year of tech and events so far, but now with several big conferences planning next years agendas its time to think ahead. Below I've prepared titles and abstracts for talks I'd like to deliver to our awesome data platform community in 2019. 5x regular sessions. 2x … Continue reading Preparing My Community Sessions for 2019

Execute All SSIS Packages in Parallel with ADFv2 Lookup and ForEach Activities

Just a quick post friends following a talk I did on Azure Data Factory (ADF) v2 at SQL Saturday Manchester. In the talk I demonstrated using ADF more dynamically now version 2 supports expressions and parameters... Amongst other cool stuff I specifically showed how you could run your SSIS packages, scaled out across all the … Continue reading Execute All SSIS Packages in Parallel with ADFv2 Lookup and ForEach Activities