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

Execute SSIS Package in Azure-SSIS

If you browse to an instance of an Azure Data Factory SSIS Integration Runtime – aka Azure-SSIS IR – you may notice an icon / button that appears as shown above. There are two ways to reach the Execute SSIS Package functionality, via the Monitor page and via the Author page’s Connections tab. From the …
Continue reading Execute SSIS Package in Azure-SSIS

The Data Driven Podcast Season 3!

Frank and I have been working hard behind the scenes (mostly) to bring Data Driven podcast listeners a(nother) awesome season of Data Driven! We have two big announcements: The first episode of Data Driven Season 3 features an interview with John Lee Dumas of Entrepreneurs on Fire podcast! Mr. Dumas is our primary inspiration for …
Continue reading The Data Driven Podcast Season 3!

edges, Not Edge

I read about “The Edge” these days; a lot. I don’t believe The Edge is singular (unless we are speaking of U2’s guitarist). Instead, I believe we are smack dab (a Farmville-ism) in the middle of the age of edges. Edges What do I mean by “edges?” In the days of Architectures Past we designed …
Continue reading edges, Not Edge

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

Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!

I am honored to deliver Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019! Abstract Data Integration Lifecycle Management – or DILM – is challenging regardless of your chosen data integration platform. The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019!

Regarding SSIS Training…

This post was inspired by an email I recently sent to a prospective student of the Enterprise Data & Analytics training course titled From Zero to SSIS. The student asked very good questions about the value of training for certification vs. the value of training to gain knowledge. Both types of training are important; both …
Continue reading Regarding SSIS Training…

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