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 Training 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 Training Course Schedule for 2020 and 2021

Microsoft Azure Announces Project Bicep, an ARM DSL

Managing Azure Resource Manager (ARM) templates can be challenging. The Microsoft Azure team is aware of the challenges and has released a very early-alpha-v0.1 version of a new effort named Project Bicep (ARM… bicep… get it?). From the Github page: Bicep is a Domain Specific Language (DSL) for deploying Azure resources declaratively. It aims to drastically …
Continue reading Microsoft Azure Announces Project Bicep, an ARM DSL