Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar! Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun
Tag:SSIS
The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available
The recording of my free webinar – Introduction to Lifting and Shifting SSIS to the Cloud – is now available (registration required). Abstract How does an enterprise lift and shift SSIS projects from SSIS Catalogs on-premises to the Azure Data Factory Integration Runtime? What are the best practices? Do SSIS lifecycle management tools exist to …
Continue reading The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available
ADF Execute SSIS Package Activity
The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity
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
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
Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018