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
Regarding Return Pipeline Value Data Type
On last week’s exciting and thrilling episode of Data Engineering Fridays, I was stymied for a bit. You can watch me struggle with my code here – the struggle lasted for a while. I eventually figured it out. As an aside: I absolutely love streaming live-coding! Believe it or not, failing is one of my favorite parts. …
Continue reading Regarding Return Pipeline Value Data Type
SSMS v21 and SSIS
Regular readers of this blog know I am a fan of Star Trek. In fact, my beautiful bride and I recently finished streaming Star Trek: Deep Space 9. It was the first time either of us had watched the series start-to-finish and we enjoyed the characters and story lines. It is well-written. We agreed Worf’s …
Continue reading SSMS v21 and SSIS
Fabric Data Factory Pipeline Execution From Azure Data Factory
Visit the landing page for the Data Engineering Execution Orchestration Frameworks in Fabric Data Factory Series to learn more. I must begin this post with a simple – perhaps profound – statement: Koen Verbeeck (LinkedIn | @Ko_Ver) is a talented data engineer. Here’s why I begin this post with such a statement. If you’ve been following my …
Continue reading Fabric Data Factory Pipeline Execution From Azure Data Factory
Tinkering with AnalyticsCreator
I’ve been interested in data engineering code generation and automation for years. I was recently treated to a demo of AnalyticsCreator, a product I had hitherto not heard of. I was impressed with the live demo delivered by an in-house engineer. The engineer connected to a source database, selected several tables for import, selected a …
Continue reading Tinkering with AnalyticsCreator