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!
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Fabric Data Factory and Azure Data Factory Training – Summer 2025
I am excited to share Summer 2025 Azure Data Factory and Fabric Data Factory training deliveries from me! Join me for live and online full day training deliveries: A Day of Azure Data Factory – 25 Jun 2025 A Day of Fabric Data Factory – 16 Jul 2025 A Day of Azure Data Factory – …
Continue reading Fabric Data Factory and Azure Data Factory Training – Summer 2025
Getting Started with the SSIS Catalog in SSMS v21
SQL Server Integration Services (SSIS) is available in preview in SQL Server Management Studio v21.2.5. Here’s how to configure SSMS get started using the SSIS Catalog! Install or Update, then Modify, SSMS If you have not installed SQL Server Management Studio v21, you can grab the latest installation bits here. If you have already installed …
Continue reading Getting Started with the SSIS Catalog in SSMS v21
My Name is Andy, and I Vibe Code
Originally published at Engineer Of Data as a newsletter. Subscribe to my newsletter here. 50 Years Last month, I Celebrated 50 Years in Software. That link will take you to a recording of a show in which my youngest daughter, Emma, interviewed me to discuss this milestone. I think Emma is an excellent interviewer, but I biased. Embracing …
Continue reading My Name is Andy, and I Vibe Code
Metadata-Driven Fabric Data Factory Pipeline Orchestration From ADF
Blog Post Note / Disclaimer / Apology: This is a long blog post. It makes up for the length by being complex. I considered ways to shorten it and to reduce its complexity. This is the best I could do. – Andy Visit the landing page for the Data Engineering Execution Orchestration Frameworks in Fabric Data …
Continue reading Metadata-Driven Fabric Data Factory Pipeline Orchestration From ADF
Three Links to Stay Current on Microsoft Fabric
I’ve been following Microsoft Build online this week, and I’m particularly excited to watch a couple people I admire deliver the Closing Session 22 May 2025 at 11:30 AM PT – Scott Hanselman and Mark Russinovich. If you are unable to attend Build in person, you can register to attend many sessions online – for free. …
Continue reading Three Links to Stay Current on Microsoft Fabric