The Next Mastering the SSIS Catalog Course Delivery is 11 Jun 2019

I’m excited to announce the next delivery of Mastering the SSIS Catalog will be the morning of 11 Jun 2019! This half-day course brings you up to speed on the SSIS Catalog quickly and efficiently, and we have great fun along the way. About Mastering the SSIS Catalog Data integration is the foundation of data …
Continue reading The Next Mastering the SSIS Catalog Course Delivery is 11 Jun 2019

Honored to Present Moving Data with Azure Data Factory at SQL Saturday Atlanta 18 May!

I am honored to present Moving Data with Azure Data Factory at SQL Saturday 845 – Atlanta 18 May 2019! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in …
Continue reading Honored to Present Moving Data with Azure Data Factory at SQL Saturday Atlanta 18 May!

Free Webinar: Loading Medical Data with SSIS

Join Kent Bradshaw – Database Administrator, Developer, and Data Scientist – and me, Andy Leonard – Microsoft Data platform MVP, author, blogger, and Chief Data Engineer at Enterprise Data & Analytics as we present Loading Medical Data with SSIS at 12:00 PM EDT 17 Apr 2019. Join this webinar and learn: An SSIS design pattern …
Continue reading Free Webinar: Loading Medical Data with SSIS

In the Beginning…

As I stated in the post titled Writing a Technical Book, “I am often asked for more information about writing a technical book.” In a follow-up post titled, One Way to Write a Technical Book, I state, [here] “I share details of my approach to writing a technical book.” People reading these posts have asked …
Continue reading In the Beginning…

SSIS, Docker, and Windows Containers, Part 6 – Executing Packages in an SSIS Catalog in a Container

In the previous six posts I: examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0) shared why I want to do all this (Part 1) shared one way to execute SSIS on a container in Part 2 shared …
Continue reading SSIS, Docker, and Windows Containers, Part 6 – Executing Packages in an SSIS Catalog in a Container

SSIS, Docker, and Windows Containers, Part 5 – Deploying to the SSIS Catalog

In the previous five posts I: examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0) shared why I want to do all this (Part 1) shared one way to execute SSIS on a container in Part 2 shared …
Continue reading SSIS, Docker, and Windows Containers, Part 5 – Deploying to the SSIS Catalog

SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2

In my previous four posts I examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0). I shared why I want to do all this (Part 1). I shared one way to execute SSIS on a container in Part …
Continue reading SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2

SSIS, Docker, and Windows Containers, Part 3 – Adding the SSIS Catalog, Attempt 1

In my previous three posts I’ve examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0). I’ve shared why I want to do all this (Part 1). And I’ve shared one way to execute SSIS on a container in …
Continue reading SSIS, Docker, and Windows Containers, Part 3 – Adding the SSIS Catalog, Attempt 1