I’ve been learning git and… it’s been challenging. I’ve written about my experiences: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied In this post I discuss some benefits of distributed version control. But first, I’d like to share this caused no small number …
Continue reading Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control
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.
SSIS Extension 3.4 Available for Visual Studio 2019
The SSIS team announces the General Availability (GA) of the SQL Server Integration Services Projects – version 3.4 – extension for Visual Studio 2019. If you have not SSIS in Visual Studio 2019, it’s… different. Enjoy! :{>
Error – Failed to Start the Integration Runtime
“There I was…” Andy, circa 2020 I confess it had been a while since I created an Azure Data Factory (ADF) instance – too long, in fact. I’ve learned it’s important to build a data factory every now and then to make sure I haven’t missed anything new that has been recently added. Plus, I …
Continue reading Error – Failed to Start the Integration Runtime
Announcing SSIS Catalog Browser v0.9.1.0
I am excited to announce a fairly substantial update to SSIS Catalog Browser! What’s New? In a word, speed. The #1 complaint I received from customers using previous versions of SSIS Catalog Browser – especially customers with more than a few SSIS packages and projects in their SSIS Catalog – was related to the amount …
Continue reading Announcing SSIS Catalog Browser v0.9.1.0
Free Webinar: Using Parameters in Azure Data Factory – 15 Jan 2020
Join Microsoft Data Platform MVP Andy Leonard for Using Parameters in Azure Data Factory 15 Jan 2020 at 12:00 PM EST! Azure Data Factory (ADF) uses parameters to extend and add flexibility to data integration. Andy Leonard discusses and demonstrates using parameters with ADF pipelines! Register today! :{>
Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!
I am honored to present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020! The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps – …
Continue reading Honored to Present Azure DevOps and the SSIS Development Lifecycle at Hampton Roads SQL Server User Group 15 Jan 2020!
Announcing GA of the Integration Services Projects Extension for Visual Studio 2019
The Microsoft SSIS Team announces the general availability (GA) of the SSIS Projects for VS2019 version 3.3! In this version, the biggest change is that we removed Power Query Source for SQL Server 2017 and Microsoft Oracle Connector for SQL Server 2019. Since this version, if you want to use these two components in this …
Continue reading Announcing GA of the Integration Services Projects Extension for Visual Studio 2019
In 2020, Two Full Training Days, Two Continents
It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents
Honored to Present From Zero to ADF at SQLBits 2020 in London!
Honored to Present From Zero to ADF at SQLBits 2020 in London 1 Apr 2020! When I look at this list of SQLBits Training Day presenters, I think, “Wow! That’s a lot of really smart people… plus me!” Registration is open now. Register today! :{>
Free Stuff for People Who Give Back: Announcing 2020 Scholarship Application
Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who work for charities and non-profit organizations. I am honored to …
Continue reading Free Stuff for People Who Give Back: Announcing 2020 Scholarship Application