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

Sessions I Submitted to the PASS Summit 2010


I'm borrowing an idea and blog post title from Brent Ozar (Blog - @BrentO). I am honored the PASS Summit 2010 (Seattle, 8 - 11 Nov 2010) would consider allowing me to present. It's a truly awesome event. If you have an opportunity to attend and read this blog, please find me and introduce yourself.

If you've built a cool solution to a business or technical problem; or written a script - or a bunch of scripts - to automate part of your daily / weekly / monthly routine; or have some advice on community or career development; I urge you to submit an abstract (or four) to present at the PASS Summit 2010. The Call for Speakers is open until 5 Jun 2010!

I submitted the following four sessions to the PASS Summit this year:

Applied SSIS Design Patterns, Part 2 (Level 400 Spotlight)

"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.

ETL With SSIS (Pre- / Post-Conference)

SQL Server MVP Andy Leonard spends a day walking you through creating an ETL Solution in SSIS to load a Relational Data Warehouse.

Topics include:
 - A Brief SSIS Refresher: Business Intelligence Developer Studio
 - Relational DW Design Concepts: Dimensions and Facts
 - The Dimension
 - The Date Dimension
 - The Fact
 - Externalized Metadata
 - Logging
 - Execution Strategy
 - Monitoring and Maintenance 

Database Design for Developers (Level 200)

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.

Build Your First SSIS Package (Level 100)

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.


Not every submission is selected and that's ok. As I stated earlier, I'm honored to participate in the PASS Summit in any capacity. I hope to see you there!

:{> Andy

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



Brent Ozar said:

Good luck, and can't wait to see you in Seattle, sir!

May 26, 2010 7:27 AM

ktegels said:

Andy: is it fair to say that you really teaching good cube design rather than relational/normalized design?

Just curious,


May 26, 2010 8:46 AM

andyleonard said:

Hi Kent,

  Not me. I don't know enough about MOLAP to instruct anyone on cube design.

:{> Andy

May 26, 2010 9:32 AM

Adam Machanic said:

Kent: Isn't "good cube design" an oxymoron on some level? (I'll leave now before getting pelted with too many rocks)

May 26, 2010 9:44 AM

Steve Jones said:

Best of luck, Andy. They sound like good sessions and I'm sure at least one will get picked.

May 26, 2010 11:05 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement