Completed: Microsoft Big Data Professional Program Capstone Project

I’m excited to announce that I’ve completed – with help from my friend and brother and co-host of the Data Driven podcast, Frank La Vigne (Blog | @Tableteer) – the Microsoft Big Data Professional Program Capstone project! The capstone is the last course requirement (of 10 courses) to complete the Microsoft Professional Program in Big …
Continue reading Completed: Microsoft Big Data Professional Program Capstone Project

The Recording for Introduction to Loading the Cloud with SSIS is Now Available

The recording for the free webinar titled Introduction to Loading the Cloud with SSIS is now available (registration required). Abstract The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. For more information on data integration in the cloud, …
Continue reading The Recording for Introduction to Loading the Cloud with SSIS is Now Available

Introduction to Loading the Cloud with SSIS – 29 Mar 2018

The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. Join me for  Introduction to Loading the Cloud with SSIS 29 Mar 2018 at noon ET to learn more. Register today! :{>

Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!

I am honored to announce I have been selected to deliver a full-day precon titled A Day of Intelligent Data Integration with SSIS and ADF at the Data Platform Summit 2018 in Bengarulu, India 7 Aug 2018! This will be my first appearance at the Data Platform Summit and my first visit to India. I …
Continue reading Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!

Free Webinar – Win a Free Book! Introduction to DILM 1 Mar 2018

Join me 1 Mar 2018 at noon ET for Introduction to DILM – a free webinar in which we explore Data Integration Lifecycle Management using SSIS as an example. One attendee will score an autographed copy copy of my latest book, Data Integration Life Cycle Management with SSIS! You must be present to win. In the …
Continue reading Free Webinar – Win a Free Book! Introduction to DILM 1 Mar 2018

SSIS Catalog Browser Video

Earlier today I went live on Facebook to share features of the latest update for SSIS Catalog Browser (which is FREE): What’s new? View Azure Data Factory version 2 Integration Runtime (aka SSIS in the Cloud) Values Everywhere Project Connections Project Connection References Package Connections Package Connection References :{>

Honored to Present Faster SSIS at SQL Saturday #719 – Chicago 17 Mar 2018

I am honored to present Faster SSIS at SQL Saturday #719 in Chicago 17 Mar 2018! Abstract: Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start …
Continue reading Honored to Present Faster SSIS at SQL Saturday #719 – Chicago 17 Mar 2018

Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell

If you’re new to PowerShell or just don’t know PowerShell, tinkering with Azure Data Factory Version 2 Integration Runtime (ADFv2 IR) can be intimidating. In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance, I walk you through the PowerShell part, sharing my (meager) knowledge of this awesome utility, assuming little (assuming nothing, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell

Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives

In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project I wrote about deploying, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives