Thank You, Members of the PASS Board of Directors

Today, 15 Jan 2021, is the last day of PASS. I’d like to thank everyone involved in the creation, management, and administration of the organization over its 20+ year history. PASS impacted my career in a very positive way. I didn’t always agree with the decisions of PASS leadership, and I was vocal about a …
Continue reading Thank You, Members of the PASS Board of Directors

Getting Started With ADF (Azure Data Factory)

Here’s a sample of a live stream I recorded today about Getting Started with ADF (Azure Data Factory)! You can view the full video here. Be sure to click Follow to be alerted when I stream live! :{> Need Help With ETL or Your Enterprise Data Warehouse? At Enterprise Data & Analytics, we believe you should ask …
Continue reading Getting Started With ADF (Azure Data Factory)

SSIS 2019 Extension v3.11.1 Now Available

The Microsoft SSIS Team released an update to version 3.11 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11.1 (Current Version): Release Date: December 28th, 2020 Build Version: 15.0.2000.150 Tested against Visual Studio 2019 16.8 Bug fixes: Fixed an issue that …
Continue reading SSIS 2019 Extension v3.11.1 Now Available

Wrapping Up 2020

It’s that time of year again; that time when bloggers and others share their thoughts about the year that was and the year to come. “2020 was ____.” I complete this sentence three ways, listed below. Feel free to add your thoughts in the comments. “Different” …is the first word that leaps to mind. The …
Continue reading Wrapping Up 2020

Azure DevOps, Git, and SSIS

After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS

SSIS and the Future – December 2020 Edition

My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition

SSIS 2019 Extension v3.11 Now Available

The Microsoft SSIS Team sent SSIS developers an early Christmas present this year: a new SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11 (Current Version): Release Date: December 23th, 2020 Build Version: 15.0.2000.149 Tested against Visual Studio 2019 16.8 Whats’ new: Make creating SSISDB optional in IR Creation Wizard. …
Continue reading SSIS 2019 Extension v3.11 Now Available

Why Do I Like to Stream?

For as long as I can remember, I’ve always enjoyed learning – whether it’s learning something new and different, or learning something new and different about a topic in which I already possessed some knowledge. I confess: It’s a rush for me. To my knowledge, I’ve created no knowledge. With few exceptions, I learned everything …
Continue reading Why Do I Like to Stream?