In this post, I describe how to create an SSIS Catalog in SQL Server 2025 (RC) using SSMS v22 (Preview 3). Once configured, I describe how to test the installation using Visual Studio 2026 Insiders Community Edition. In earlier posts, I describe prerequisites: One Way to Install SQL Server 2025 One Way to Install SSMS …
Continue reading Create a SQL Server 2025 SSIS Catalog Using SSMS v22
One Way to Install SQL Server 2025
In this post, I describe one way to install SQL Server 2025 (using RC1) for on-premises testing. The major steps are: Get the bits Install SQL Server 2025 (RC) Get the Bits Navigate to the Microsoft Evaluation Center page for SQL Server 2025 (https://www.microsoft.com/en-us/evalcenter/sql-server-2025-download) and click the link for the 64-bit edition (there is no …
Continue reading One Way to Install SQL Server 2025
One Way to Install SSMS v22 (Preview 3)
In this post I describe how to install SQL Server Management Studio (SSMS) version 22, which is in preview at the time of this writing. Get the Bits To begin: Visit the Microsoft Learn article titled Install SQL Server Management Studio Click the link labeled “Download SSMS 22 Preview”: Remember where you save the file: …
Continue reading One Way to Install SSMS v22 (Preview 3)
Add the SSIS Extension to Visual Studio 2026 Insiders
In this post, I explain how to add the Integration Services extension to Visual Studio 2026 Insiders Community Edition. First, install Visual Studio 2026 Insiders Community Edition. Then… Add the SQL Server Integration Services Projects 2022+ Extension There is a lot of exciting news to announce! SSIS Extension Renamed First, the SSIS extension for Visual …
Continue reading Add the SSIS Extension to Visual Studio 2026 Insiders
Coming Soon – SSIS Framework Manager
On 9 Sep 2025, I posted a short video about SSIS Framework Manager, software I’ve dreamed about building for, well, for a long time now: I’m excited to reach this milestone! Reaching it has been quite the journey. I share more of the story in my newsletter titled “An SSIS Framework Odyssey: It’s taken a …
Continue reading Coming Soon – SSIS Framework Manager
Announcing AI Wednesdays!
My older son, Stephen, and I started working together recently. We’re excited to announce a new stream titled AI Wednesdays! Our first show is 13 Aug 2025 (Triskaidekaphobic, anyone? Not us!). You’ll be able to join us on LinkedIn, X, YouTube, Facebook, Twitch, and Rumble at 3:00 PM EDT. We plan to focus on how …
Continue reading Announcing AI Wednesdays!
Configure Security to Read Fabric Artifacts
My older son, Stephen, and I have been vibe coding information-dense solutions for Fabric lately. The latest application is Fabric Navigator, which simplifies navigation between Fabric Data Factory pipelines and notebooks. While Fabric Navigator includes links to instructions about configuring Azure and Fabric security to allow read access to Fabric Data Factory pipelines and notebooks, …
Continue reading Configure Security to Read Fabric Artifacts
Stephen Leonard, AI Engineer, Enterprise Data & Analytics
I’m excited to announce Enterprise Data & Analytics has an AI Engineer. I’m more excited to announce that EDNA’s AI Engineer is my older son, Stephen Leonard! I’ve mentioned I starting vide coding in earnest in March of this year (2025). The (released) results are free utilities now available at Data Engineering Lifecycle Management …
Continue reading Stephen Leonard, AI Engineer, Enterprise Data & Analytics
A New Endeavor and New (Free!) Product
Originally posted as an Engineer of Data newsletter. I started a new venture, and I’m excited to announce the launch of the very first product! To be fair, this is a beta version, designed specifically to be a minimally-viable product. If you’re not familiar with the concept of minimally-viable product design, I encourage you to …
Continue reading A New Endeavor and New (Free!) Product
SSIS Extension Updates – Jun 2025
Back in Jun 2024, I announced I was changing the way I report updates to the SQL Server Integration Services extension for Visual Studio (in a post titled SSIS Extension Updates – Jun 2024). I skipped the Mar 2025 update as there were no changes to report. I have a calendar reminder that reminds me to …
Continue reading SSIS Extension Updates – Jun 2025