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!
Join Me at the PASS Data Community Summit 2022!
I am honored to deliver two training sessions at the PASS Data Community Summit 2022: A Day of Azure Data Factory is a full-day pre-conference session scheduled for Monday, 14 Nov 2022. In this session I cover version control integration, copying data, using parameters and metadata, design patterns (of course!), and more! Introduction to Azure …
Continue reading Join Me at the PASS Data Community Summit 2022!
Using DILM Deployment Utility to Restore SSIS Catalog Folders
In this video, I demonstrate using DILM Deployment Utility 2022 – part of SSIS Catalog Compare 2022 Enterprise Edition – to restore the contents of an SSIS Catalog folder in a disaster recovery scenario. Question? Want to learn more? Please contact me. Enjoy! :{>
I’m Installing SSMS Version 18.12.1…
… and you can install it, too! Visit Download SQL Server Management Studio (SSMS) and have at it. :{>
Another Way to Use SSIS Catalog Compare to Migrate SSIS Catalog Folders
Update: SSIS Catalog Compare 2022 is generally available! SSIS Catalog Compare 2022 (Beta) is available at a dramatically-reduced yearly subscription rate at the time of this writing. The yearly subscription rate will increase when SSIS Catalog Compare becomes generally available (GA). Those willing to help out by testing the beta version (in Development and Test environments …
Continue reading Another Way to Use SSIS Catalog Compare to Migrate SSIS Catalog Folders
Using SSIS Catalog Compare to Migrate SSIS Catalog Folders
SSIS Catalog Compare 2022 (Beta) is available at a dramatically-reduced yearly subscription rate at the time of this writing. The yearly subscription rate will increase when SSIS Catalog Compare becomes generally available (GA). Those willing to help out by testing the beta version (in Development and Test environments only, please!) will enjoy the beta yearly …
Continue reading Using SSIS Catalog Compare to Migrate SSIS Catalog Folders
Update – Want to Test SSIS Catalog Compare?
SSIS Catalog Compare 2022 (Beta) is available at a dramatically reduced yearly subscription rate and is ready for testing! When SSIS Catalog Compare 2022 is released for general availability, the price will increase for new purchases. Users who purchase the beta version will enjoy the same (dramatically reduced) yearly subscription rate. If you are using …
Continue reading Update – Want to Test SSIS Catalog Compare?
On Broken References in the SSIS Catalog
I recently made this video to explain what I call “broken references” in the SSIS Catalog. In the video, I create and test a broken reference, and then demonstrate how SSIS Catalog Browser (and SSIS Catalog Compare) visualize broken references. Enjoy! What is a Broken Reference? It may help to define reference first. An SSIS …
Continue reading On Broken References in the SSIS Catalog