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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Enterprise Data & Analytics is a SentryOne Partner
Did you know Enterprise Data & Analytics is a SentryOne Partner? We are! And we are honored to partner with SentryOne. We may have been the first partner to sign up in support of Task Factory – SentryOne’s suite of SSIS components and tasks – and SentryOne Test – which supports BI Testing. The Data …
Continue reading Enterprise Data & Analytics is a SentryOne Partner
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)
The SSIS Catalog and SCCPAC Files
The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files
On Installing Integration Services Versions Side-by-Side
I do not recommend installing Integration Services versions side-by-side. Microsoft provides an article describing how to accomplish side-by-side installation of Integration Services, but the article has not been updated in over three years and the last SSIS version mentioned is 2016. Over the years, I have helped customers who have more than one version of …
Continue reading On Installing Integration Services Versions Side-by-Side
On Working From Home
Note: Featured image courtesy of the CNN article What is coronavirus and Covid-19? An explainer. I’ve been working from home for about 15 years at the time of this writing. A lot of people experienced working from home for the very first time recently, as we (the planet) locked down for the pandemic. Although I’ve …
Continue reading On Working From Home
Integration Services Extension for VS 2019 v3.6 Update
The SQL Server Integration Services Projects extension for Visual Studio 2019 was updated 20 Apr 2020. There are also recent updates to Visual Studio, Live Share, and the GitHub Extension for Visual Studio. Happy coding! :{>
Honored to Present at (Virtual) SQL Saturday Richmond (And a Cool Announcement)
17 Apr 2020 UPDATE: You can listen to Stevie Ray share about his presentation (and more) in this episode of the Data Driven Podcast: Stephen Leonard on STEM and the Frustration Inherent to Engineering. Or you can listen right here! I am honored and excited to deliver Azure DevOps and the SSIS Development Lifecycle at …
Continue reading Honored to Present at (Virtual) SQL Saturday Richmond (And a Cool Announcement)
Learn Azure Data Factory and SSIS and Save Money!
I am excited to announce two additional live, online training deliveries: SSIS Data Flows – 27-28 May 2020 SSIS Administration – 02-03 Jun 2020. Note: SSIS Data Flows is a prerequisite for SSIS Administration. SSIS Data Flows is the first two days of my four-day live, online From Zero To SSIS course – which I …
Continue reading Learn Azure Data Factory and SSIS and Save Money!
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! :{>