THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is a Data Philosopher at Andy Leonard Consulting, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.

PASS Summit 2009 - Applied SSIS Design Patterns

A couple weeks ago, I learned my proposal for a spotlight session entitled "Applied SSIS Design Patterns" had been accpeted by the PASS Summit 2009 speaker selection committe. Cool! I've never done a PASS Summit spotlight session.

The abstract for the presentation follows:

Applied SSIS Design Patterns

"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! In this spotlight session, Andy Leonard defines design patterns applicable to SSIS, and then demonstrates their use to develop SSIS solutions. The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more; then demonstrate how to leverage the principles just described by applying them to every day SSIS development. Demonstrations will also include migration through the application lifecycle, deployment, and maintenance.

There are lots of other cool spotlight sessions. Check them out here, and I hope to see you at the PASS Summit 2009!

:{> Andy


Published Wednesday, June 17, 2009 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Barry said:

Hi Andy,

Are the slides/ handouts for this spotlight session available to download anywhere?  I would be interested in reading about the topic further.


February 2, 2010 4:43 PM

andyleonard said:

Hi Barry,

  Even better - you can get the session in its entirety by ordering the PASS DVDs (

:{> Andy

February 2, 2010 4:51 PM

Leave a Comment


This Blog



My Company

Community Awards

Friend of Red Gate

Contact Me


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement