Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available

I am excited to announce the availability of Build a Pipeline to Stop an ADF Azure-SSIS IR, a new Azure QuickStart course! Access the new course – along with all my recorded training for one year – by subscribing to Premium Level. Additional access options include: Azure QuickStart Premium – Access all Azure QuickStart training …
Continue reading Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available

Failed Get Parameter Info Error in Azure-SSIS

Have you encountered this error: “Failed Get Parameter Info of parameter ____”? I ran into this error a couple times while consulting for a client to lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). The Most Likely Fix Make sure the Azure-SSIS integration runtime is running: Launch Azure Data Factory …
Continue reading Failed Get Parameter Info Error in Azure-SSIS

How to Get ADF to List Available Properties

Did you know Azure Data Factory (ADF) will actually list available properties? It will. One of the things I cover in my ADF training titled Master the Fundamentals of Azure Data Factory is this handy troubleshooting tip. An Error I am attempting to read the status of a pipeline execution using a call to the ADF …
Continue reading How to Get ADF to List Available Properties

ADF Activity State Property Disables Pipeline Activities

Update: Chenye Charlie Zhu has posted an excellent article about this new functionality over at the Microsoft ADF blog! It’s titled Comment Out Part of Pipeline. Part of one of my consulting gigs is helping a client lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). While developing some test pipelines …
Continue reading ADF Activity State Property Disables Pipeline Activities

ADF Pipeline Return Value Series

While delivering Azure Data factory (ADF) consulting for a client, I had the opportunity to develop some utility pipelines that used Pipeline return values functionality (in preview at the time of this writing). For me, this exercise was a two-step process, which I share in this series: One Simple Example of ADF Pipeline Return Value …
Continue reading ADF Pipeline Return Value Series

Presenting A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Analytics Edition

I am honored to present A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Data Analytics Edition (#1042) 24 Feb 2023! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: Editing ADF pipeline JSON Version control integration Copying data …
Continue reading Presenting A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Analytics Edition

Join Me at SQLBits 2023!

I am honored to deliver a Training Day session at SQLBits 2023: A Day of Azure Data Factory is a full-day Training Day session scheduled for Tuesday, 14 Mar 2023. In this session I cover version control integration, copying data, using parameters and metadata, design patterns (of course!), and more! I hope to see you …
Continue reading Join Me at SQLBits 2023!

Three New Azure Training Offerings

Enterprise Data & Analytics Training announces three options for learning Azure (from me!). Start today for free with our 7-day free trial! Azure QuickStart Monthly – Subscribe monthly for one low monthly cost. Azure QuickStart Yearly – Subscribe yearly and save. Get two months free! Azure QuickStart Premium – A yearly subscription that includes access to recordings of …
Continue reading Three New Azure Training Offerings

Video Training for One Way to Add an Existing Data Factory to Github Series

I created a new course as part of Premium Level at Enterprise Data & Analytics. Managing Code in Azure Data Factory is the latest addition to the growing collection of Azure content: Read the blog series: One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data …
Continue reading Video Training for One Way to Add an Existing Data Factory to Github Series