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

Promoting SSIS Catalog Objects Between Lifecycle Management Tiers

Code promotion is essential to DevOps. One problem solved by SSIS Catalog Compare is code promotion via scripting between Development, Test, Pre-Production, and Production lifecycle management tiers*. In the video, I demonstrate: One gap (scripting all SSIS objects stored in the SSIS Catalog) in SSIS management tools shipped with SSMS. One way SSIS Catalog Compare …
Continue reading Promoting SSIS Catalog Objects Between Lifecycle Management Tiers