Update 19 Sep 2022: I communicated with the Microsoft SSIS Team. They shared they are targeting preview of VS2022 Integration Services Extension for the end of CY22. Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022. On 28 Jul 2021, the Microsoft SSIS Team released an …
Continue reading Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022
31 Aug 2022 Blog Stuff
Every now and then I like to see how this blog is performing. I’ve published 1,615 posts. Many (999, if memory serves) were originally published on a different site before I left that site and started blogging here at andyleonard.blog. The 19 drafts are in various stages of incompleteness. I keep them around because I …
Continue reading 31 Aug 2022 Blog Stuff
Three New Azure Training Offerings
Enterprise Data & Analytics Training announces three options for learning Azure (from me!). Start today for free with our 7-day free trial! Azure QuickStart Monthly – Subscribe monthly for one low monthly cost. Azure QuickStart Yearly – Subscribe yearly and save. Get two months free! Azure QuickStart Premium – A yearly subscription that includes access to recordings of …
Continue reading Three New Azure Training Offerings
Getting Started with Azure Automation – Part 1 Video
A little ago, I blogged about Getting Started with Azure Automation. I’ve created this video for the first part of that post. To see the remainder of this video – plus recordings of all my training – sign up for Enterprise Data & Analytics Premium Level today! Enjoy. Learn More I’m presenting Master the Fundamentals of …
Continue reading Getting Started with Azure Automation – Part 1 Video
Video Training for One Way to Add an Existing Data Factory to Github Series
I created a new course as part of Premium Level at Enterprise Data & Analytics. Managing Code in Azure Data Factory is the latest addition to the growing collection of Azure content: Read the blog series: One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data …
Continue reading Video Training for One Way to Add an Existing Data Factory to Github Series
One Way to Add an Existing Data Factory to Github, Part 3
This is part of a series of posts. This post focuses on using Azure Data Factory with a GitHub repository. One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data Factory to Github, Part 2 One Way to Add an Existing Data Factory to Github, Part …
Continue reading One Way to Add an Existing Data Factory to Github, Part 3
One Way to Add an Existing Data Factory to Github, Part 2
This is part of a series of posts. This post focuses on connecting an Azure Data Factory to a GitHub repository. One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data Factory to Github, Part 2 One Way to Add an Existing Data Factory to Github, …
Continue reading One Way to Add an Existing Data Factory to Github, Part 2
One Way to Add an Existing Data Factory to Github, Part 1
This is part of a series of posts. This post focuses on creating a GitHub account and repository. One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data Factory to Github, Part 2 One Way to Add an Existing Data Factory to Github, Part 3 You …
Continue reading One Way to Add an Existing Data Factory to Github, Part 1
Confidence and SSIS Catalog as Code
That’s what we sell at Data Integration Lifecycle Management Suite: confidence. Confidence There’s no substitute for that feeling of confidence when SSIS Catalog Compare is used to compare two SSIS Catalogs and the comparison yields no differences. I cannot improve on testimonies from our customers: The question of comparing a Production SSIS Catalog with a …
Continue reading Confidence and SSIS Catalog as Code
SSIS Catalog Compare Code Promotion with DILM Deployment Utility
This post is a follow-up to my recent post titled Promoting SSIS Catalog Objects Between Lifecycle Management Tiers. DILM Deployment Utility is a great way to encapsulate SSIS Catalog folders as code in sccpac files. Drop the files in a git repo, add, commit, and push, and viola, scripts for your SSIS Catalog folder(s) and …
Continue reading SSIS Catalog Compare Code Promotion with DILM Deployment Utility