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

The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available

Enjoy this recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes! <ShamelessPlug> 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 for large and challenging data engineering enterprises. …
Continue reading The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available

Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes

Join me 22 Jun 2020 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar – Configuring and Managing ADF Azure-SSIS Integration Runtimes! Abstract Azure Data Factory (ADF) includes Azure-SSIS Integration Runtimes, a mechanism by which SSIS packages are executed in Azure! Join Data Platform MVP Andy Leonard as he discusses and demonstrates …
Continue reading Free Webinar: Configuring and Managing ADF Azure-SSIS Integration Runtimes

Stop an Azure-SSIS Files Integration Runtime (Safely)

Recently, it happened to me. Again. I delivered another round of SSIS and ADF training, and I forgot to stop an Azure-SSIS integration runtime. I left it running for a few days and it cost me, well… more money than it would have cost me if I had remembered to stop it! Regarding the “Stop …
Continue reading Stop an Azure-SSIS Files Integration Runtime (Safely)

Moving Data with ADF Recording is Available!

I (re-)delivered the free webinar titled “Moving Data with Azure Data factory” 6 Apr 2020. I can hear you thinking, “Why did you re-deliver the webinar, Andy?” I failed to capture the recording when I first delivered the webinar 31 Mar 2020. It was all my fault. Apologies. Enjoy this recording! :{>

Error – Failed to Start the Integration Runtime

“There I was…” Andy, circa 2020 I confess it had been a while since I created an Azure Data Factory (ADF) instance – too long, in fact. I’ve learned it’s important to build a data factory every now and then to make sure I haven’t missed anything new that has been recently added. Plus, I …
Continue reading Error – Failed to Start the Integration Runtime