Andy Leonard : SSIS, Design Pattern

Presenting Loading Data Warehouse Partitions with SSIS 2012 at SQL Saturday DC!

andyleonard — Mon, 19 Nov 2012 18:37:00 GMT

Join Darryll Petrancuri and I as we present Loading Data Warehouse Partitions with SSIS 2012 Saturday 8 Dec 2012 at SQL Saturday 173 in DC ! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this...(read more)

SSIS Design Pattern: Producing a Footer Row

andyleonard — Tue, 09 Oct 2012 11:00:00 GMT

The following is an excerpt from SSIS Design Patterns (now available in the UK!) Chapter 7, Flat File Source Patterns. The only planned appearance of all five authors presenting on SSIS Design Patterns is the SSIS Design Patterns day-long pre-conference...(read more)

Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

andyleonard — Wed, 19 Sep 2012 09:00:00 GMT

My fellow authors and I will be presenting a day-long pre-conference session titled SSIS Design Patterns at the PASS Summit 2012 in Seattle Monday 5 Nov 2012! Register to learn patterns for: Package execution Package logging Loading flat file sources...(read more)

Book Review: SSIS Design Patterns

andyleonard — Mon, 17 Sep 2012 13:05:56 GMT

Samuel Vanga ( Blog | @SamuelVanga ) has posted a review of our new book SSIS Design Patterns at his blog . Several of Sam’s statements struck me, but none more than this: Within a few hours of reading SQL Server 2012 Integration Services Design Patterns...(read more)

Learn SSIS from the Authors of SSIS Design Patterns at the PASS Summit 2012!

andyleonard — Wed, 22 Aug 2012 11:00:00 GMT

Jessica Moss ( blog | @jessicammoss ), Michelle Ufford ( blog | @sqlfool ), Tim Mitchell ( blog | @tim_mitchell ), Matt Masson ( blog | @mattmasson ), and me – we are all presenting the SSIS Design Patterns pre-conference session at the PASS Summit 2012...(read more)

Presenting at Ohio North SQL Server User Group 1 May 2012!

andyleonard — Fri, 20 Apr 2012 15:01:00 GMT

I am honored to present Using BIML as an SSIS Design Patterns Engine to the Ohio North SQL Server User Group 1 May 2012! This presentation is based on one of my favorite chapters in the upcoming book: SSIS Design Patterns scheduled for release this summer....(read more)

Updated SSIS Framework, Now Includes Reports

andyleonard — Wed, 07 Mar 2012 12:00:00 GMT

I have built a beta version of Linchpin People ’s SSIS Framework, now including much-requested reports. You can grab the updated copy here . I appreciate any feedback you care to share. :{>...(read more)

Designing an SSIS Framework

andyleonard — Fri, 16 Sep 2011 11:00:00 GMT

In preparation for SQL Saturday #84 – Kalamazoo , SQLBits 9 , and the PASS Summit 2011 ; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised...(read more)

Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

andyleonard — Wed, 07 Sep 2011 21:00:00 GMT

Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners...(read more)

Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

andyleonard — Tue, 19 Jul 2011 16:58:14 GMT

I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here . Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM...(read more)

Speaking at the Charlotte SQL Server Users Group Wednesday 18 May!

andyleonard — Mon, 16 May 2011 12:30:00 GMT

I am honored to present SSIS Design Patterns to the Charlotte SQL Server Users Group Wednesday, 18 May 2011! If you read this blog and will be in the area Wednesday, stop by and say Hi! :{>...(read more)

Presenting at SQL Saturday #70 - Columbia SC

andyleonard — Wed, 09 Mar 2011 12:00:00 GMT

Introduction I'm honored to be presenting at SQL Saturday #70 in Coumbia SC 19 Mar 2011! Its always good to travel to places where I don't have to suppress my accent (what accent? I talk normal. Everyone else sounds funny...) and repeat my order at Waffle...(read more)

Presenting at Roanoke Code Camp Saturday!

andyleonard — Mon, 07 Mar 2011 17:00:00 GMT

Introduction I am honored to once again be selected to present at Roanoke Code Camp ! An Introductory Topic One of my presentations is titled "I See a Control Flow Tab. Now What?" It's a Level 100 talk for those wishing to learn how to build their very...(read more)

Presenting Designing an SSIS Execution Framework to Steel City SQL 18 Jan 2011!

andyleonard — Wed, 12 Jan 2011 12:00:00 GMT

I'm honored to present Designing an SSIS Execution Framework (Level 300) to Steel City SQL - the Birmingham Alabama chapter of PASS - on 18 Jan 2011! The meeting starts at 6:00 PM 18 Jan 2011 and will be held at: New Horizons Computer Learning Center...(read more)

Presenting SSIS Design Patterns to Roanoke Valley SQL Server UG Tomorrow!

andyleonard — Tue, 11 Jan 2011 12:00:00 GMT

I am honored to present SSIS Design Patterns to the newly re-formed Roanoke Valley SQL Server Users Group Wednesday, 12 Jan 2011! The meeting starts at 6:00 PM ET and will be held at: Blue Ridge Library 28 Avery Row Roanoke, VA 24012 ( Map ) If you read...(read more)