One Complex Example of ADF Pipeline Return Value

This post is part of a short series on Azure Data Factory pipeline return value functionality, which is in preview at the time of this writing. The Problem I am Trying to Solve I want to develop an Azure Data Factory (ADF) design pattern for calling focused, unit-of-work, function-y ADF pipelines that perform focused tasks. …
Continue reading One Complex Example of ADF Pipeline Return Value

One Simple Example of ADF Pipeline Return Value

This post is part of a short series on Azure Data Factory pipeline return value functionality, which is in preview at the time of this writing. The Problem I am Trying to Solve I want to develop an Azure Data Factory (ADF) design pattern for calling focused, unit-of-work, function-y ADF pipelines that perform focused tasks. …
Continue reading One Simple Example of ADF Pipeline Return Value

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

Changing ADF Execute SSIS Package Activity to Manual Entries

I found this error confusing, too. Why? One reason was I made an assumption that the SSIS Catalog reference (a reference is an SSIS Catalog configuration setting that connects an SSIS project to an SSIS Catalog Environment) would override any values being sent from the ADF Execute SSIS Package activity to the SSIS Project / Package execution call.

Laid Off? Or the Beginning of Your Next Opportunity?

Updates: The “opp23” limited-time offer has expired. I may make similar offers in the future. The best way to learn of offers from me is to subscribe to my mailing list and check the checkbox labeled “I would like to receive more information about products, services, events, communications, and offers.” If you signed up for …
Continue reading Laid Off? Or the Beginning of Your Next Opportunity?

My 2023 Presentation Schedule

I am presenting! Here’s a partial list of upcoming events at which I am honored and privileged to present: 14 Mar 2023 – SQLBits 2023 – A Day of Azure Data Factory Training Day (full-day) – International Convention Centre, Celtic Manor, Newport, Wales 25 Feb 2023 – SQL Saturday Atlanta 2023 – BI & Data …
Continue reading My 2023 Presentation Schedule

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

Azure-SSIS Express Custom Setup License Key Textbox Update

Back in June 2022, I was honored to deliver a webinar along with the good people on the SolarWinds Task Factory team. During that presentation, I noticed (and I may have even commented on) the License key textbox not being masked when adding Task Factory to an Azure-SSIS integration runtime. I sent a note to the …
Continue reading Azure-SSIS Express Custom Setup License Key Textbox Update

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!