The Data Integration Lifecycle Management Suite (DILM Suite) is a collection of tools designed to reduce the friction of managing SQL Server Integration Services (SSIS) across its lifecycle. DILM Suite helps enterprise data engineers and data teams compare, package, deploy, and maintain SSIS solutions with greater consistency, visibility, and control by replacing manual, error-prone processes …
Continue reading Use SSIS Framework Manager to Build an SSIS Application
Announcing: SSIS Lifecycle Advisory
I’ve launched a new fixed-scope advisory offer for organizations running SSIS in production. Many teams do not have an SSIS problem.They have a lifecycle management problem. Deployments feel risky.Change visibility is limited.Governance is inconsistent.Modernization questions keep piling up. The SSIS Lifecycle Advisory is designed to help teams get clear on: deployment and release risk governance …
Continue reading Announcing: SSIS Lifecycle Advisory
SSIS 2016 and SQL Server 2016 End-of-Life 14 Jul 2026
A tip o’ the hat to Brent Ozar who included a link in his 9 Feb 2026 newsletter to the SQLFingers post titled “SQL Server 2016 Ends in July. Here’s What Will Break.“ Regarding SQL Server 2016, SQLFingers says: After July 14, 2026: No more security patches No more support calls No longer compliant You …
Continue reading SSIS 2016 and SQL Server 2016 End-of-Life 14 Jul 2026
Video: One-Shotting an App with Claude Code – Jan 2026
On 08 Jan 2026, I recorded this video of me using Claude Code to “one-shot” the development of a Windows application. What does one-shot mean? Andy’s definition: A one-shot is when a developer interacts with AI and the results are generated correctly on the first attempt. Enjoy!
Honored to Present Using AI To Be Your Data Engineering Partner at Day of Data Jax 2026
Stephen and I are honored to present a full day of training titled Using AI To Be Your Data Engineering Partner in-person 01 May 2026 at Day of Data Jax 2026! Abstract Stop building pipelines the slow way. AI is transforming data engineering, and the gap between those who’ve adapted and those who haven’t is …
Continue reading Honored to Present Using AI To Be Your Data Engineering Partner at Day of Data Jax 2026
Upgrading from SSIS – Can We Talk?
A Tale of Two Worlds At the outset of 2026, I live in two worlds. I continue to support clients who use SSIS for enterprise data engineering. Some of the enterprises are small-ish by comparison. Others are huge. Some friends also continue to support these clients and clients like them. That’s World 1. World 2 …
Continue reading Upgrading from SSIS – Can We Talk?
2025: A Number Containing Two 2’s, One 5, and a 0
All the cool kids are writing year-in-review posts. I reckon I’ll write this one. For me, 2025 has been a year filled with different. Some of the different has been very cool; some has not been cool at all. If you’ve stumbled onto this post / newsletter (I’m writing this on my blog at andyleonard.blog …
Continue reading 2025: A Number Containing Two 2’s, One 5, and a 0
Separating Concerns in SSIS
I recently read a social media post from a data engineer that I found both encouraging and heartbreaking. This data engineer shared that he used an AI engine to successfully convert an SSIS package, roughly 1MB in size, into a different data engineering platform. Why encouraging? First, it is genuinely encouraging that AI engines are …
Continue reading Separating Concerns in SSIS
Install Durandal Memory MCP Server to Mitigate AI Context Fatigue
The following is an excerpt from a 200+ page document titled AI-Assisted Data Engineering Development Playbook: How I Set Up a Virtual Server (Virtual Machine) for Modern Data Engineering for sale at DELMSuite.com, but available – free – to paid subscribers of my newsletter: Engineer of Data. The phrases context fatigue, attention degradation, instruction drift, …
Continue reading Install Durandal Memory MCP Server to Mitigate AI Context Fatigue
Join me 17 Dec 2025 for A Day of Azure Data Factory Live, 1-Day Training
Unlock the potential of your cloud-data strategy and step into the future with confidence. Join us LIVE on 17 Dec 2025 for “A Day of Azure Data Factory”, a powerful 1-day online training designed for professionals like you aiming to master Azure Data Factory (ADF). This hands-on session, led by industry expert Andy Leonard, covers: …
Continue reading Join me 17 Dec 2025 for A Day of Azure Data Factory Live, 1-Day Training