Let’s face it: All the cool kids are playing in the cloud. And why wouldn’t they be? Microsoft Azure gets new features every week… sometimes every day! One shiny feature is Azure Data Factory Integration Runtime (ADFIR) which is new in Azure Data Factory version 2. In this post I will show you one way to …
Continue reading Lift and Shift SSIS Part 0: Creating the ADF Integration Runtime
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. :{>
How I Build an SSIS Test Virtual Machine
I use VirtualBox for my hypervisor engine. I started using it years ago when it was the first free hypervisor I found that supported 64-bit guests. In this post I share some thoughts about testing SSIS using a test virtual machine (VM). There are other awesome hypervisor platforms out there. In setting up a virtual …
Continue reading How I Build an SSIS Test Virtual Machine
SSIS Design Pattern: Controller Pattern
The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).
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
Dude, Where’s My Controls? (Visual Studio 2017 Behavior)
I’m coding along on the next release of SSIS Catalog Compare, happy as a clam, when I realize it’s time to add a new menu item. I open the form and… nothing. To say my heart sank would be an understatement. I had questions. “Dude, where’s my controls?” “What happened?!” “Will I be able to …
Continue reading Dude, Where’s My Controls? (Visual Studio 2017 Behavior)
On Output…
I’m going to be a little bold in this post and suggest if you are developing for SQL Server, the screenshot to the left and above shows something that is, well, wrong. I can hear you thinking, “What’s Wrong With That Output, Andy?” I’m glad you asked. I will answer with a question: What just …
Continue reading On Output…
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”