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
Category:SSIS Catalog
Honored to Present Intelligent Data Integration at SQL Saturday – Virginia Beach!
SQL Saturday 839 – Virginia Beach has three precons scheduled for 07 June. That’s three opportunities for you to learn from, “A couple really smart people – plus me!” Who are these smart people? Andrew Kelly and John Morehouse will be speaking on Core Level Performance Monitoring and Managing and Architecting Azure Data Platform, respectively. …
Continue reading Honored to Present Intelligent Data Integration at SQL Saturday – Virginia Beach!
Honored to Present Intelligent Data Integration at SQL Saturday – Dallas!
SQL Saturday 841 – Dallas has four precons scheduled for 31 May. Four. If you have ever organized a SQL Saturday or similarly-sized event, you know this takes a lot of hard work. Hat’s off to the organizers! I describe the precon presenters as, “A bunch of really smart people – plus me!” Chris Hyde, …
Continue reading Honored to Present Intelligent Data Integration at SQL Saturday – Dallas!
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
“That was Worth the Price of the Course!”
I’m delivering Expert SSIS today. I hear the statement that is the title of this post each and every time I deliver this training. The advice and demonstrations are all based on experience… hard-fought-and-won experience. Sign up for the next delivery. Two days, live, online – with me! Join me and level-up your SSIS! Register …
Continue reading “That was Worth the Price of the Course!”
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 Design Pattern: Use Script Tasks for ETL Instrumentation
I consider scripting in SQL Server Integration Services (SSIS) my data integration “get out of jail free” card. Why? If I cannot find a way to accomplish some requirement using SSIS’s built-in objects – tasks, containers, Data Flow components, etc. – I can usually write .Net code to fulfill the requirement. As stated in the …
Continue reading SSIS Design Pattern: Use Script Tasks for ETL Instrumentation
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?