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!

Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

I am honored to deliver Master the Fundamentals of ADF at SQL Saturday Boston 2022 (#1031) 7 Oct 2022! Abstract Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build fully managed ETL in the cloud – including SSIS. Join Andy Leonard – …
Continue reading Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

Join Me at the PASS Data Community Summit 2022!

I am honored to deliver two training sessions at the PASS Data Community Summit 2022: A Day of Azure Data Factory is a full-day pre-conference session scheduled for Monday, 14 Nov 2022. In this session I cover version control integration, copying data, using parameters and metadata, design patterns (of course!), and more! Introduction to Azure …
Continue reading Join Me at the PASS Data Community Summit 2022!

Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

I am honored to deliver a full day pre-conference session at the PASS Data Community Summit 2022! My precon is titled “A Day of Azure Data Factory.” Register today! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: – Version control …
Continue reading Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

AndyStream for 8 Nov 2021

Frank and I are on Day 6 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – atomic habits and systems of execution. This morning I popped on for a few minutes to share information about the PASS …
Continue reading AndyStream for 8 Nov 2021

Join Me for LIVE Online SSIS and ADF Training 29 Nov – 1 Dec

It’s been a while since I delivered training live and online. Let’s fix that! Join me for Master the Fundamentals of ADF and Expert SSIS 29 Nov – 1 Dec.

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework

My Black Friday 2020 Sale is On!

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!

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