Two Recordings Available: SSIS Catalog and SSIS Lifecycle

Andy Leonard shares two recordings about using the SSIS Catalog to manage enterprise data engineering.

You Might Need an SSIS Framework

You might need an SSIS framework. “How can I tell if I need an SSIS framework, Andy?” I’m glad you asked. Does your enterprise: Practice DevOps? Execute lots of SQL Server Integration Services (SSIS) packages? Execute SSIS packages several times per day? Execute “SSIS in the Cloud” using the Azure Data Factory version 2 Integration …
Continue reading You Might Need an SSIS Framework

My Books

I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books

Introduction to the SSIS Lifecycle – 7 Jun 2018

Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018

“You Do Not Know What You Are Doing”

Peeves make lousy pets. Knowing this doesn’t help; I still keep a few pet peeves. One of my pet peeves is this statement, “You don’t know what you are doing.” Why is this a pet peeve? It denies the obvious fact that everyone one of us, everywhere, is still learning. “My Name is Andy and …
Continue reading “You Do Not Know What You Are Doing”

Catalog Browser, Version 0.6.2.0

If you’ve read this blog for a short time, you already know I have a passion for DevOps. You probably guessed I also have a passion for data engineering (My job title at Enterprise Data & Analytics is Chief Data Engineer). I believe successful software development is a combination of a software development platform, a …
Continue reading Catalog Browser, Version 0.6.2.0

My Learning Resources for SSIS

People often ask me, “Andy, where can I learn SSIS or learn more about it?” Well, you’re at one such location – my blog! I’ve been blogging about SSIS for about 10 years as I type this. There’s a lot posts here about SSIS – that’s the good news. The bad news is: There’s a …
Continue reading My Learning Resources for SSIS

Why I Built SSIS Framework Community Edition, by Andy Leonard

A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. Last week I published Why I Built SSIS Catalog Compare, by Andy Leonard, another excerpt from the book. This post is another excerpt of the same book. Enjoy! A …
Continue reading Why I Built SSIS Framework Community Edition, by Andy Leonard

The Recording for Introduction to DILM is Available

A big ol’ Farmville Virginia THANK YOU to everyone who attended my free webinar Introduction to DILM on 1 Mar 2018! The recording is now available (registration required). The next free webinar is Introduction to SSIS Design Patterns, Part 1 8 Mar 2018 at noon ET. I hope to see you there! Register today. Learn …
Continue reading The Recording for Introduction to DILM is Available