Sessions I Submitted to the PASS Summit 2010

Introduction

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.

Conclusion

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