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! :{>
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Source-Control SSIS Catalog Contents in Azure DevOps
I did a thing – actually a couple things – that I’ve been dreaming about for a while. In a couple recent blog posts – SSIS Catalog Compare Enterprise Generates SCCPAC Files and Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps – I walked through one way to source-control the …
Continue reading Source-Control SSIS Catalog Contents in Azure DevOps
Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps
I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control Azure DevOps, Software Development, and Git …
Continue reading Azure DevOps, Software Development, and Git Part 4 – Command-Line with Azure DevOps