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

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! :{>