Announcing Data Engineering Fridays!

I’m excited to announce Data Engineering Fridays! I can hear some of you thinking, … “What are Data Engineering Fridays, Andy?” That’s an awesome question! I’m glad you asked. Data Engineering Fridays is a weekly stream, between 24 May and 23 Aug 2024, in which I lead a discussion about data engineering-related topics. The 24 …
Continue reading Announcing Data Engineering Fridays!

SQL Server Integration Services Extensions Updates

It’s been a while since I blogged about SSIS extensions to Visual Studio. For that, I apologize. During my hiatus, The Microsoft SSIS Team appears to have separated the SSIS extensions for Visual Studio 2019 and Visual Studio 2022. The latest version of the Visual Studio 2019 SSIS extension is version 4.5, updated on my …
Continue reading SQL Server Integration Services Extensions Updates

Testing New SSIS Extensions – Some Basics

Featured image test tube drawing attribution: Test Vectors by Vecteezy. How do I test new SQL Server Integration Services (SSIS) extensions and updates to Visual Studio? I have a collection of virtual servers that run locally on my laptop. SSIS extensions for Visual Studio 2019 and Visual Studio 2022 are now separate downloads (see the …
Continue reading Testing New SSIS Extensions – Some Basics

Laid Off? Or the Beginning of Your Next Opportunity?

Updates: The “opp23” limited-time offer has expired. I may make similar offers in the future. The best way to learn of offers from me is to subscribe to my mailing list and check the checkbox labeled “I would like to receive more information about products, services, events, communications, and offers.” If you signed up for …
Continue reading Laid Off? Or the Beginning of Your Next Opportunity?

Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022

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

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

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! :{>

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