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

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

2019 – A Blog in Review

I write this 12 Dec 2019. Thus far in 2019 – 348 days in, counting this post – I’ve posted 124 posts at andyleonard.blog(). Roughly, that’s one post every three (~2.8) days. According to the WP-Statistics plugin, this blog has had just under 60k visitors and you have visited over 155k pages year-to-date. From the …
Continue reading 2019 – A Blog in Review

Public Preview – SSIS Azure DevOps Build and Deploy Tasks

Microsoft announces the public preview for SSIS Azure DevOps Tools, which includes the SSIS Build and SSIS Deploy Azure DevOps tasks! I was honored to present Azure DevOps and the SSIS Development Lifecycle at the PASS Summit 2019 where I demonstrated these new tasks in action. Check them out! :{>

Overcome Challenges of Lifting and Shifting SSIS to Azure

Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure

The First DataSoup Virtual Summit is Live!

Frank La Vigne (@Tableteer | LinkedIn | DataDriven) and I are honored to announce the first DataSoup Virtual Summit! Awesome Speakers! Speakers at first DataSoup Virtual Summit are intelligent, world-renowned experts (plus me!). Head over to the speaker page and check them out. A Virtual Summit is… Different If you sign up to view DataSoup, …
Continue reading The First DataSoup Virtual Summit is Live!

Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

I am honored to deliver From Zero to ADF – a full-day pre-conference training event held Friday, 04 Oct 2019 – the day before SQL Saturday 907 – Pittsburgh! Abstract From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud …
Continue reading Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure

Join me 17 Sep 2019 at 12:00 PM EDT for Overcome Challenges of Lifting and Shifting SSIS to Azure! We help customers lift and shift data, databases, Analysis Services (SSAS), Power BI, and Integration Services (SSIS) to Azure at Enterprise Data & Analytics. Lifting and shifting SSIS to Azure-SSIS is our fastest-growing segment of business, …
Continue reading UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure