I am honored to present Introduction to ADF at Hampton Roads Azure Users Group at 6:00 PM 10 Oct 2023! I’ll be there live and in-person. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration …
Continue reading Presenting Introduction to ADF at Hampton Roads Azure Users Group at 6:00 PM 10 Oct 2023!
Return a Value from an ADF Pipeline Course Now Available
I am excited to announce the availability of Return a Value from an ADF Pipeline, 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 plus Premium …
Continue reading Return a Value from an ADF Pipeline Course Now Available
Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available
I am excited to announce the availability of Deploy an SSIS Project to 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 Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available
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
TaskFactory Activation Error in Azure-SSIS
I regularly help customers migrate SSIS to Azure-SSIS integration runtimes, a nifty component of Azure Data Factory. I was recently stumped by an error activating TaskFactory (Task Factory for the search engines…) on an Azure-SSIS IR node. The error was: “The system cannot find the file specified.” The TaskFactory activation file is named PragmaticWorks.TaskFactory.Licensing.exe. The …
Continue reading TaskFactory Activation Error in Azure-SSIS
SQL Feedback
Update: Erin Stellato [LinkedIn], program manager extraordinaire, responded to my off-topic comment (that inspired this post): Thanks, Erin! If you would like to suggest or view other suggested changes to a Microsoft product or platform, head over to the page labeled Microsoft Azure | Share your Ideas. I have to warn you to not get …
Continue reading SQL Feedback
Andy’s Generative AI Poll
Last week I posted polls on Twitter and LinkedIn asking readers the following question: The answer to my poll question – at the time* – was “None”. *”At the Time, Andy?” Yep. I finally broke down and used ChatGPT – to which I subscribe – to help in the blog post before this one: Why …
Continue reading Andy’s Generative AI Poll
Why I Have Never Liked Personas
First, A Story Years ago I managed an ETL Team at Unisys. When I became manager, we had about 24 team members. The team grew to 40 members. I was initially hired to build an SSIS framework to replace functionality built-in to a competing product. The maintenance cost for the competing product was $1,000,000USD per …
Continue reading Why I Have Never Liked Personas
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