I added Catalog Statistics to the latest version of SSIS Catalog Browser – version 0.9.2.1. I like the idea for a number of reasons but I am definitely biased; I built it. There are additional improvements over the previous release, but the improved performance from v0.9.1.0 is still there. Take SSIS Catalog Browser version 0.9.2.1 …
Continue reading SSIS Catalog Browser v0.9.2.1
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. :{>
Azure DevOps, Software Development, and Git Part 3 – Command-Line
I’m writing about my journey with git, sharing my experiences along the way. The series to date: Azure DevOps, SSIS, and Git Part 0 – Getting Started Azure DevOps, Software Development, and Git Part 1 – Applied Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control In this post I cover command-line …
Continue reading Azure DevOps, Software Development, and Git Part 3 – Command-Line
Azure DevOps, Software Development, and Git Part 2 – Distributed Version Control
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
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