Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!
Category:ADF Design Patterns
Honored to Present From Zero to ADF at SQLBits 2020!
I’m honored to deliver a Training Day at SQLBits 2020, which is now a virtual event! My training day will be delivered 30 Sep 2020 and is titled From Zero to Azure Data Factory. The agenda is: From Zero to Azure Data Factory is designed to jumpstart data engineering and data integration developers, introducing them …
Continue reading Honored to Present From Zero to ADF at SQLBits 2020!
Nesting ForEach Activities in Azure Data Factory
Near the end of June 2020, I delivered a free Enterprise Data & Analytics Summer o’ ADF webinar titled Using the Azure Data Factory ForEach Activity. My friend Meagan Longoria (Blog | @MMarie | LinkedIn) was in attendance. If you don’t know Meagan, you should – especially if you work with analytics. She’s scary-smart about …
Continue reading Nesting ForEach Activities in Azure Data Factory
The Recording for Building an SSIS Framework in Azure Data Factory
Enjoy this recording of the (free!) Enterprise Data & Analytics webinar titled Building an SSIS Framework in ADF! :{> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work …
Continue reading The Recording for Building an SSIS Framework in Azure Data Factory
Learn SSIS Data Flows and Azure Data Factory in August 2020!
I recently added two online training deliveries for August 2020: 10-11 Aug 2020: SSIS Data Flows 12 Aug 2020: Master the Fundamentals of Azure Data Factory SSIS Data Flows is a two-day, online, live course designed to jumpstart SSIS developers who want to learn SSIS and those who desire to fill gaps in their self-taught …
Continue reading Learn SSIS Data Flows and Azure Data Factory in August 2020!
SQL Server Data Automation through Frameworks Book Available for Pre-Order
Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!
Free Webinar – Building an SSIS Framework in ADF
Join me at 12:00 PM EDT on 9 Jul 2020 for Building an SSIS Framework in ADF, another free Summer o’ ADF webinar from Enterprise Data & Analytics. Abstract Andy authors SSIS frameworks according to a few principles: 1. Functionality 2. Empathy 3. Simplicity Join Microsoft Data Platform MVP Andy Leonard as he discusses and …
Continue reading Free Webinar – Building an SSIS Framework in ADF
Recording – Using the Azure Data Factory ForEach Activity
In this video, Andy Leonard discusses and demonstrates the Azure Data Factory ForEach activity.
Free Webinar: Using the Azure Data Factory ForEach Activity
The Azure Data Factory ForEach activity iterates collections. This makes the ForEach activity extremely useful for acting on flexible number of items. As with all software, there are corners. So, I cover a gotcha or two in this free webinar from Enterprise Data & Analytics at 12:00 PM EDT 30 Jun 2020. Register today for …
Continue reading Free Webinar: Using the Azure Data Factory ForEach Activity
One Way to Break Out of an Azure Data Factory ForEach Activity
First, a couple shoutouts to my brothers and friends, Joel Cochran (@joelcochran) and Shannon Lowder (@shannonlowder). This approach grew out of conversations with them. The ForEach activity iterates over a collection of items. One less-documented property of the ForEach activity is it (currently) iterates the entire collection. I can hear some of you asking… “What …
Continue reading One Way to Break Out of an Azure Data Factory ForEach Activity