Why I Built SSIS Framework Community Edition, by Andy Leonard

A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. Last week I published Why I Built SSIS Catalog Compare, by Andy Leonard, another excerpt from the book. This post is another excerpt of the same book. Enjoy! A …
Continue reading Why I Built SSIS Framework Community Edition, by Andy Leonard

Honored to Present Faster SSIS at SQL Saturday #721 – Raleigh 14 Apr 2018!

I am humbled, honored, and excited to present Faster SSIS at SQL Saturday #721 – Raleigh 14 Apr 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) …
Continue reading Honored to Present Faster SSIS at SQL Saturday #721 – Raleigh 14 Apr 2018!

The Recording for Introduction to DILM is Available

A big ol’ Farmville Virginia THANK YOU to everyone who attended my free webinar Introduction to DILM on 1 Mar 2018! The recording is now available (registration required). The next free webinar is Introduction to SSIS Design Patterns, Part 1 8 Mar 2018 at noon ET. I hope to see you there! Register today. Learn …
Continue reading The Recording for Introduction to DILM is Available

Introduction to SSIS Design Patterns, Part 1 – 8 Mar 2018

Join me 8 Mar 2018 at noon ET for another free webinar, Introduction to SSIS Design Patterns, Part 1! SSIS Design Patterns are tried and true data integration patterns built in SQL Server Integration Services (SSIS). Join author and international speaker Andy Leonard as he explores: – The Truncate and Load Staging Pattern – The …
Continue reading Introduction to SSIS Design Patterns, Part 1 – 8 Mar 2018

Why I Built SSIS Catalog Compare, by Andy Leonard

A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. This post is another excerpt of the same book. In fact, this is the chapter that follows the chapter on Catalog Browser (which is …
Continue reading Why I Built SSIS Catalog Compare, by Andy Leonard

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!

The Recording of Introduction to Biml is Available

The recording for Introduction to Biml is now available (registration required)! In this gentle introduction to Business intelligence Markup Language (Biml), author and BimlHero Andy Leonard walks through the basics of the Biml and BimlScript languages, demonstrating how to use Biml to generate several SSIS packages in minutes. Check out Introduction to Biml to learn …
Continue reading The Recording of Introduction to Biml is Available

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