One Way to Extract SQL Server 2017 Installation Media

In my post titled SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2 I wrote about storing the SQL Server 2017 Developer Edition installation media in a directory. But I failed to explain how I do this. This is how I store the SQL Server 2017 Developer Edition installation media …
Continue reading One Way to Extract SQL Server 2017 Installation Media

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 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

SSIS, Docker, and Windows Containers, Part 2 – Executing SSIS, v0.1

In my last couple 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). In this post, I show my next step: executing an SSIS package …
Continue reading SSIS, Docker, and Windows Containers, Part 2 – Executing SSIS, v0.1

SSIS, Docker, and Windows Containers, Part 1 – Why?

In my first post in this series, SSIS, Docker, and Windows Containers, Part 0 – Getting Started, I covered: Installing docker Choosing a Container OS Pulling a test image Pulling a Windows Container with SQL Server installed interacting with with your instantiated container In this post I reveal my ultimate goal and then travel down …
Continue reading SSIS, Docker, and Windows Containers, Part 1 – Why?

Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

Enterprise Data & Analytics Welcomes Shannon Lowder!

I am honored and thrilled to welcome Shannon Lowder (@shannonlowder | blog | LinkedIn) to the Enterprise Data & Analytics team! Shannon is a data engineer, data scientist, BimlHero (though not listed on the page at the time of this writing), and shepherd of the Biml Interrogator open source project. If you use Biml to generate SSIS …
Continue reading Enterprise Data & Analytics Welcomes Shannon Lowder!

The 2:00 AM Test

I’m working with a collection of clients these days providing data integration, cloud, and DevOps advice. I love architecture work! My clients love the results. Everyone wins. Kent Bradshaw and I are tag-teaming with a couple clients who are converting data integration from other platforms to SSIS. In a recent meeting Kent mentioned “the 2:00 …
Continue reading The 2:00 AM Test