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

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