I am excited to announce Enterprise Data & Analytics has scheduled Azure Data Factory (ADF) and SQL Server Integration Services (SSIS) courses through Dec 2021! We have updated the public training schedule at the Live ADF and SSIS Class Season Pass and Training pages. In all, there are seven delivery blocks scheduled – each containing …
Continue reading Learn ADF and SSIS For One Year and Save Money!
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
Where’s the SSIS Dropdown Menu in Visual Studio 2019?
Just the other day, I was whining to communicating with friends on the Microsoft SSIS team about the SSIS dropdown menu in Visual Studio 2019, sharing “The SSIS dropdown menu is missing.” In Visual Studio 2017 (SQL Server Data Tools), the SSIS dropdown menu is prominently displayed alongside other top-level dropdown menu items: The SSIS …
Continue reading Where’s the SSIS Dropdown Menu in Visual Studio 2019?
How to Skip SSIS Package Validation
A new feature in version 3.9 of the Visual Studio 2019 SSIS extension is “skip package validation.” I’ve tested the functionality and it works well. Here’s how you set it up: First, install the Visual Studio 2019 SSIS version 3.9 extension. Next, open Visual Studio 2019 and click Tools > Options: Navigate to Business Intelligence …
Continue reading How to Skip SSIS Package Validation
Integration Services Extension v3.9 is Available
Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for all target server version except SSIS 2017. Release Notes: Version 3.9 (Current Version): Release Date: August 24th, 2020 Build Version: 15.0.2000.128 Tested against Visual Studio 2019 16.7 …
Continue reading Integration Services Extension v3.9 is Available
A New Podcast: Impact Quantum
Frank La Vigne and I are not busy enough, so we started a new podcast named Impact Quantum! We did a Data Driven Podcast episode about it called Frank and Andy Go Quantum. Our first show is titled Quantum is Coming and is available! :{>
Azure DevOps and the SSIS Development Lifecycle on LinkedIn Live
I was honored to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT 18 Aug 2020. This is a condensed version of a larger presentation that goes by the same name. This version lasted about 20 minutes and is packed with information about basic build automation using Azure Pipelines with SSIS. I …
Continue reading Azure DevOps and the SSIS Development Lifecycle on LinkedIn Live
Free! Azure DevOps and the SSIS Development Lifecycle Presentation
I’m excited to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT Tuesday, 18 Aug 2020! This time, though, I am trying something new – LinkedIn Live! That means there’s no registration and no sign-up. Just show up at LinkedIn and attend. I’m not sure if you need to be following me on …
Continue reading Free! Azure DevOps and the SSIS Development Lifecycle Presentation
Azure Resource Groups Save Money
I delivered Master the Fundamentals of Azure Data Factory earlier this week and, as always, it was a blast! My disclaimer slide proved accurate, once again. Anyone who works in Azure groks the maxim: Change happens. Managing Bucks Cost management in Azure is important. No one wants to wake up to a larger-than-expected bill at …
Continue reading Azure Resource Groups Save Money
Honored to Present From Zero to ADF at SQLBits 2020!
I’m honored to deliver a Training Day at SQLBits 2020, which is now a virtual event! My training day will be delivered 30 Sep 2020 and is titled From Zero to Azure Data Factory. The agenda is: From Zero to Azure Data Factory is designed to jumpstart data engineering and data integration developers, introducing them …
Continue reading Honored to Present From Zero to ADF at SQLBits 2020!
On Over-Engineering…
Some who follow me on Twitch (you may follow me at https://twitch.tv/andyleonard) – have seen me live-code the demo project for the second edition of Building Custom Tasks for SQL Server Integration Services (link to the first edition). The demo project is a custom task named Execute Catalog Package Task: While writing about parsing the …
Continue reading On Over-Engineering…