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
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
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
SSIS in Visual Studio 2022
The Visual Studio 2022 Integration Services Extension is Generally Available (GA). I tested a couple things that, while not bugs per se, “bugged” me. The “bugged-me’s” I observed appear fixed. Enjoy! :{>