Another Way to Use 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 subscription …
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

SSIS Catalog Browser v0.9.12.0

When I tinker with SSIS Catalog Compare, SSIS Catalog Browser is affected. SSIS Catalog Browser is free, SSIS Catalog Compare is not free. I recently used SSIS Catalog Compare on a consulting engagement to migrate contents of an SSIS Catalog from one server to another. During the migration, I found references were not processed as …
Continue reading SSIS Catalog Browser v0.9.12.0

SSIS in SQL Server 2022 CTP 2.0

SQL Server 2022 Community Technology Preview 2.0 is available, and it includes the SSIS Catalog! Create an SSIS Catalog At the time of this writing, the SSIS 2022 Catalog is similar (identical, perhaps) to the SSIS 2019 Catalog. Connect to a SQL Server 2022 instance using SSMS and right-click the Integration Services Catalogs node in …
Continue reading SSIS in SQL Server 2022 CTP 2.0

Updated SSIS Extension v3.16 for Visual Studio 2019

On 1 Jun 2021, the Microsoft SSIS Team released an update to version 3.16 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019. An operative bullet for this version: Version 3.16 is the latest general availability (GA) version, which does not support target server version …
Continue reading Updated SSIS Extension v3.16 for Visual Studio 2019

Rarely Say Never

Years ago, I responded privately to my brother and friend, Buck Woody (@BuckWoodyMSFT | LinkedIn) when he shared (excellent) advice about when to shrink a SQL Server database (spoiler alert: rarely). I asked Buck, “If shrinking a SQL Server database is nearly always bad, why not remove the feature from SQL Server?” (paraphrased). Buck’s response …
Continue reading Rarely Say Never

Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

I am honored to deliver a full day pre-conference session at the PASS Data Community Summit 2022! My precon is titled “A Day of Azure Data Factory.” Register today! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: – Version control …
Continue reading Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!