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 an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

PASS Summit 2010 Fun


The PASS Summit 2010 is fast approaching, and I'm honored to present two sessions and participate in several events. I look forward to meeting lots of SQL Server professionals - some of whom I already know via Twitter!

Tuesday, 9 Nov 2010

12:00 PM Birds of a Feather - I'll be hosting a table to talk about SSIS at lunch.

Wednesday, 10 Nov 2010

 10:15 - 11:45 AM Applied SSIS Design Patterns, Part 2 - "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! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-deocumented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns. This session includes patterns: - to migrate SSIS packages through your enterprise without editing connection managers; - to load data from variable-length row files; - to extend the functionality of the parent-child pattern to create SSIS execution groups. 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.

1:30 PM Lightning Talk - I'm doing my lightning talk on SSIS Development. My talk has a twist: My friend Allen White was messing with me about creating my slide deck. Then he suggested I go on stage and do the presentation from the deck he created for me, without seeing the deck beforehand. I'm in! I love a challenge! So I'll be working with showtune quotes Allen digs up and relating them to SSIS Development. To quote Buck Woody (Blog | @buckwoody), "I can't wait to see what I'll say!"


Thursday, 11 Nov 2010

2:30 - 3:45 PM Database Design for Developers - This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.


I look forward to the PASS Summit 2010. If you're there and read this blog, please introduce yourself!


Published Friday, October 29, 2010 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



NULLgarity said:

Andy - (as you already know) I'm headed out to the Summit this year.  Look forward to seeing you there!

October 29, 2010 8:52 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement