It is Possible to Execute SSIS in a Container

As the title of this post suggests, it is possible to execute SSIS in a container. How? I’ll share more details later – promise. One short version is: Run a container with the microsoft/mssql-server-windows-developer image (assign lots of RAM). Add the SQL Server installation files to the container. Execute SQL Server setup from a command line …
Continue reading It is Possible to Execute SSIS in a Container

Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!

I am honored to present Moving Data with Azure Data Factory at SQL Saturday 806 in Charlotte, NC 20 Oct 2018. This is the first time I am delivering this session. It still has that new presentation smell! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports …
Continue reading Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!

On Data Engineering in 2018

A few years ago I had a conversation with Scott Currie, the CEO of Varigence and inventor of Biml. Scott is one of the smartest people I know and I know a lot of very smart people. Whenever I have the opportunity to communicate with the very smart people I know, I often ask them – …
Continue reading On Data Engineering in 2018

Using SSIS Framework Community Edition Webinar 20 Sep

Join me 20 Sep 2018 at noon ET for a free webinar titled Using SSIS Framework Community Edition! Abstract SSIS Framework Community Edition is free and open source. You may know can use SSIS Framework Community Edition to execute a collection of SSIS packages using a call to a single stored procedure passing a single …
Continue reading Using SSIS Framework Community Edition Webinar 20 Sep

Introducing Azure Data Factory Design Patterns

I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns

Announcing the Fundamentals of Azure Data Factory Course!

I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!

Change to the SSMS Create Catalog Dialog

I’m glad to see a change in the Create Catalog dialog for creating an instance of an SSIS Catalog using SQL Server Management Studio (SSMS) version 17.9. The “Enable this server as SSIS scale out master” checkbox is now unchecked by default: I’m not sure if this changed in SSMS version 17.9 or an earlier …
Continue reading Change to the SSMS Create Catalog Dialog

Delete SSIS Catalog Folders With SSIS Catalog Compare

To delete a Catalog folder using SSIS Catalog Compare, right-click the folder and click Delete Folder: You are prompted to confirm folder deletion: If the folder contains additional Catalog artifacts, the user is prompted again to confirm the deletion of the folder and all contents: Let’s take a short break right here and consider some …
Continue reading Delete SSIS Catalog Folders With SSIS Catalog Compare

Anatomy of a Catalog Reference Script in SSIS Catalog Compare

A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare