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

SSIS Catalog Compare August Sale

For the month of August 2022, SSIS Catalog Compare Enterprise Edition yearly subscription is on sale for 60% off the regular yearly subscription rate! SSIS Catalog Compare facilitates Data Integration Lifecycle Management (DILM) and DevOps with SSIS by: Comparing SSIS Catalog metadata between data integration lifecycle tiers (Development, Test, QA, Production, etc.) Promoting (deploying) SSIS …
Continue reading SSIS Catalog Compare August Sale

Getting Started with Azure Automation

Azure Automation has been around for a few years now. I just got started because my brother and friend, Aaron Nelson (@SQLvariant), shared some automation he’s been working on. Once I got my head around the piece I’m about to share with you, Azure Automation started to make sense to me. Set Up an Azure …
Continue reading Getting Started with Azure Automation

Presenting Master the Fundamentals of ADF at SQL Saturday Boston!

I am honored to deliver Master the Fundamentals of ADF at SQL Saturday Boston 2022 (#1031) 7 Oct 2022! Abstract Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build fully managed ETL in the cloud – including SSIS. Join Andy Leonard – …
Continue reading Presenting Master the Fundamentals of ADF at SQL Saturday Boston!