Public Preview – SSIS Azure DevOps Build and Deploy Tasks

Microsoft announces the public preview for SSIS Azure DevOps Tools, which includes the SSIS Build and SSIS Deploy Azure DevOps tasks! I was honored to present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019 where I demonstrated these new tasks in action. Check them out! :{>

Overcome Challenges of Lifting and Shifting SSIS to Azure

Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure

The First DataSoup Virtual Summit is Live!

Frank La Vigne (@Tableteer | LinkedIn | DataDriven) and I are honored to announce the first DataSoup Virtual Summit! Awesome Speakers! Speakers at first DataSoup Virtual Summit are intelligent, world-renowned experts (plus me!). Head over to the speaker page and check them out. A Virtual Summit is… Different If you sign up to view DataSoup, …
Continue reading The First DataSoup Virtual Summit is Live!

Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

I am honored to deliver From Zero to ADF – a full-day pre-conference training event held Friday, 04 Oct 2019 – the day before SQL Saturday 907 – Pittsburgh! Abstract From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud …
Continue reading Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure

Join me 17 Sep 2019 at 12:00 PM EDT for Overcome Challenges of Lifting and Shifting SSIS to Azure! We help customers lift and shift data, databases, Analysis Services (SSAS), Power BI, and Integration Services (SSIS) to Azure at Enterprise Data & Analytics. Lifting and shifting SSIS to Azure-SSIS is our fastest-growing segment of business, …
Continue reading UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure

Updated: SSIS Catalog Logging and Reporting in the Enterprise

The SSIS Catalog, first introduced with the release of SQL Server 2012 Integration Services (SSIS 2012), is a big step forward in Data Integration Lifecycle Management (DILM) with SQL Server Integration Services (SSIS). Like all software, the SSIS Catalog performs some tasks admirably and other tasks… not so admirably. In this post, I will share …
Continue reading Updated: SSIS Catalog Logging and Reporting in the Enterprise

Azure-SSIS Starts Faster

I had the honor to deliver “Moving Data with Azure Data Factory at SQL Saturday – Atlanta this weekend. Because Azure changes daily, I fired up an Azure-SSIS instance Integration Runtime the morning of my presentation and walked through my demo. I play a game I call, “What’s Changed in Azure!” It’s a fun game. …
Continue reading Azure-SSIS Starts Faster

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