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!

SSIS Catalog Browser v0.9.10 is Available

I am excited to share the latest release of SSIS Catalog Browser, and it’s still free at DILM Suite! A feature I forgot to mention in the video is the “Check for Update” menu item: If you are running the current version – beginning in version 0.9.10.0 – clicking Help>Check for Update will display a …
Continue reading SSIS Catalog Browser v0.9.10 is Available

Technology Marketing Template

This month (May 2022), I mark 47 years since I first flipped toggle switches representing hexadecimal bytes and machine code commands into a Motorola 6800 processor trainer. I remember the thrill of watching the program successfully execute. I still experience a thrill when code runs as intended (usually after much debugging). I was recently inspired …
Continue reading Technology Marketing Template

After Azure Subscription Disabled, Restart ADF Triggers

A couple / three days after delivering the April 2022 edition of Master the Fundamentals of Azure Data Factory (the next delivery is 20 May 2022 – check out Enterprise Data & Analytics Training to register and save money!), I got an email from Azure informing me my account had been disabled because I reached …
Continue reading After Azure Subscription Disabled, Restart ADF Triggers