Azure Data Factory and SSIS Training 2020-Q4

Join me 16-19 Nov 2020 for four days of SQL Server Integration Services (SSIS) training! Days 1 and 2 focus on development using real-world data (I love AdventureWorks for demos, but real-world data is never that clean). Students complete 10 labs on days 1 and 2 and get to play the game What Will SSIS …
Continue reading Azure Data Factory and SSIS Training 2020-Q4

SSIS 2019 Extension v3.10 for Visual Studio 2019 Released

The Microsoft Azure-SSIS team released version 3.10 of the SQL Server Integration Services Projects extension a couple weeks back. I missed it until today because my writing is keeping me in my SSIS 2017 VMs and, truth be told, I am a little off my game the past few weeks. Apologies for this delayed post. …
Continue reading SSIS 2019 Extension v3.10 for Visual Studio 2019 Released

How to Promote SSIS Code in the Enterprise Lifecycle

I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have sysadmin privileges. 2. Test – another environment in which developers have sysadmin privileges. 4. Production – managed by production operations such as domain administrators, system administrators, …
Continue reading How to Promote SSIS Code in the Enterprise Lifecycle

Slowly Coming Back, October 2020 Edition

I share a lot. Because I share a lot, many people believe: I am an extrovert; and I share everything. Neither is accurate. I am an introvert with a strong desire to help others. My desire overcomes my introvert nature enough to keep me out there. truth be told? I’d rather be spending time with …
Continue reading Slowly Coming Back, October 2020 Edition

SSIS Catalog Browser Live Demo

I am delivering more and more live streaming sessions. The session for today (6 Oct 2020) was all about SSIS Catalog Browser, a free utility from DILM Suite. DILM Suite hosts several utilities to help with Data Integration Lifecycle Management (DILM). Most are free and many are open source. You should check it out! Enjoy …
Continue reading SSIS Catalog Browser Live Demo

ADF and SSIS Public Course Schedule for 2020 and 2021

Want to learn Azure Data Factory (ADF) and SQL Server Integration Services (SSIS)? The schedule for courses is available at the Enterprise Data & Analytics Training page. Sign up for a Season Pass and Save! ADF and SSIS courses are scheduled for 2020 and 2021. Choose the Live ADF and SSIS Class Season Pass and …
Continue reading ADF and SSIS Public Course Schedule for 2020 and 2021