Join me 15 Mar 2018 at noon ET for Introduction to Change Detection with SSIS, another free webinar sponsored by Enterprise Data & Analytics. Change detection is the central component for Incremental Load data integration patterns. In this presentation I discuss and demonstrate three change detection patterns: – No Change Detection – Brute-Force Change Detection …
Continue reading Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018
Category:SSIS
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!
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
The Recording for Introduction to SSIS is Now Available
If you missed the live presentation do not despair: The recording for my free webinar Introduction to SSIS is now available (registration required)! Enjoy! :{>
Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
My friend and brother, Patrick LeBlanc (@patrickdba), built a cool Power Bi Dashboard (and database!) to help K12 education systems track students and student activities such as attendance. Better yet, he gives it away! He gives away the code and he shares a free Guy in a Cube video walking through the features. Patrick emailed and …
Continue reading Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
Free Webinar: Introduction to SSIS – 15 Feb 2018
Join me Thursday 15 Feb 2018 at noon ET for Introduction to SSIS – a free webinar from Enterprise Data & Analytics. Abstract: Join SSIS author Andy Leonard as he presents Introduction to SSIS! In this webinar, Andy covers the following topics: – Build your first SSIS package, a data warehouse ETL stage loader – Deploy …
Continue reading Free Webinar: Introduction to SSIS – 15 Feb 2018