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
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. :{>
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! :{>
Azure DevOps and the SSIS Development Lifecycle Recording is Available!
Azure DevOps and the SSIS Development Lifecycle was recorded 3 Apr 2020. Enjoy! :{>
Using Parameters in ADF Recording is Available
The recording for Using Parameters in Azure Data Factory is available. Enjoy! :{>
Azure Data Factory Execution Patterns Recording is Available!
The recording for Azure Data factory Execution Patterns is available! Enjoy. :{>
Free Training for People Who Have Lost Their Jobs
Update: I am unable to offer free training to people who lost their job due to the pandemic at this time. Thank you to everyone who took advantage of this offer. I hope the training helped. – Andy I saw a tweet earlier today from another friend who has been laid off as a …
Continue reading Free Training for People Who Have Lost Their Jobs