My PASS Summit 2019 Presentations

SSIS DevOps and Azure Containers I was honored to co-present SSIS DevOps and Azure Containers with Sreeja Pullagura and Elizabeth Baron. Liz and Sreeja work for Teach for America, a really cool non-profit headquartered in NYC. This was their very first time presenting at the PASS Summit. We were even featured on PASStv! . You …
Continue reading My PASS Summit 2019 Presentations

PASS Summit 2019, Coming Down

During the PASS Summit 2019, Frank and I worked hard to deliver several DataDriven *DataPoint*’s.Here’s a list: *DataPoint* Andy is on the Way to Seattle for PASS 2019 *DataPoint* Andy Arrives at PASS 2019 *DataPoint* PASS 2019 Welcome Reception *DataPoint* Hanging Out with #SQLGeeks at PASS 2019 *DataPoint* Andy Speaks with SentryOne CEO Bob Potter …
Continue reading PASS Summit 2019, Coming Down

DILM Suite Applications

‘Twas the Saturday before the PASS Summit 2019 and all through Andy’s office… During my Azure DevOps and the SSIS Development Lifecycle presentation I may have an opportunity to demonstrate some DILM Suite applications: SSIS Catalog Browser, SSIS Framework Community Edition, SSIS Framework Browser, and Catalog Reports. All four applications are free. SSIS Framework Community …
Continue reading DILM Suite Applications

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

SSIS Is Not Dead (Or Dying)

A few weeks ago I began hearing a rumor that SSIS had a couple years of life remaining. “In two years or so,” according to the rumor, “SSIS will die and be replaced with Azure Data Factory.” Is Microsoft capable of such a move; deprecating a technology? Yep. Remember SQL Server Notification Services? I can …
Continue reading SSIS Is Not Dead (Or Dying)

Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020

I am honored to co-present a full-day post-conference workshop – Intelligent Data Integration with SSIS and Azure Data Factory – with Sandy Winarko, Principal Program Manager at Microsoft – Azure Data Governance, Cloud & Artificial Intelligence (AI), at Difinity 2020 in New Zealand! Details Full Day Workshop Level: 300 Post-Conference: 20th of Feb 2020 This …
Continue reading Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020

“It’s Past 10 July 2019 and We Still Have SSIS 2008 in Production…”

I am writing this post 10 Jul 2019. Yesterday, support ended for SQL Server 2008 and 2008 R2. Many are still running SQL Server 2008 and 2008 R2 in production, and many are using SSIS 2008 and 2008 R2 in production as well. If you are reading this post and thinking or saying, “Yep. He’s …
Continue reading “It’s Past 10 July 2019 and We Still Have SSIS 2008 in Production…”

Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording

Enjoy the recording of the free Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording! Another free webinar presented by Enterprise Data & Analytics as part of the Summer O’ ADF 2019.

Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters

UPDATE: You may view the recording of this webinar at Azure Data Factory, Azure-SSIS, and Pipeline Parameters Recording. Enjoy! :{> Join me 8 Jul 2019 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar titled Azure Data Factory, Azure-SSIS, and Pipeline Parameters! In this free webinar, we build on the demonstration from …
Continue reading Free Webinar: Azure Data Factory, Azure-SSIS, and Pipeline Parameters

The Recording for Designing a Basic SSIS Execution Framework

As will sometimes happen when one chooses to type in demos, things went awry in the last demo. I choose to type in demos because I don’t want to create the false impression that SSIS Just Works the first time, every time. After the webinar ended I spent some time troubleshooting. The issue appears related …
Continue reading The Recording for Designing a Basic SSIS Execution Framework