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

My PASS Summit 2011 Schedule

The PASS Summit next week! Taking a cue from my friend Aaron Bertrand (blog | @AaronBertrand), I thought I’d post my schedule so my faithful readers (both of you, except Mom who isn’t attending PASS this year…) would know where to catch me if you want to meet.

Monday 10 Oct 2011

8:30 AM – 4:30 PM: A Day of SSIS in the Enterprise – Room 611-612
In this day-long seminar, SQL Server MVPs Andy Leonard and Tim Mitchell - along with Microsoft SSIS Developer Matt Masson - demonstrate an SSIS development methodology for teams building enterprise-class solutions. Topics include:
- SSIS Design Patterns
- ETL Best Practices
- Metadata-Driven SSIS Execution
- Centralized Logging
- SSIS Frameworks
- Package Execution Monitoring
- Predictive Analytics
- Source Control
- ETL Auditing
- Deployment
- Security
The presentation team provides examples of SSIS Design Patterns from their upcoming book: SSIS Design Patterns; actionable demonstrations for building and maintaining SSIS packages in the enterprise; practical patterns that support ETL performance, instrumentation, and deployment; and pragmatic guidance for enterprise ETL Lifecycle Management.
They share from their experiences as consultants, developers in the enterprise, and experience managing teams of SSIS developers for years. The information and advice of this team is applicable in organizations of any size.

Tuesday 11 Oct 2011

6:30 PM – 8:00 PM: Welcome Reception & Quizbowl – Dell Ballroom

Wednesday 12 Oct 2011

8:15 AM – 10:00 AM: Day One Keynote – Dell Ballroom

10:00 AM – ~12:00 PM: EIM Experts Pods – Expo Hall Experts Pods Area

~11:30 AM – 1:30 PM: Chapter Lunch – Dining Hall

1:00 – 2:30 PM: SQL Server MVP Deep Dives 2 Book Signing – Between the Expo Hall and Dining Hall

3:00 PM – 4:15 PM: Lightning Talks – Room 201

Thursday 13 Oct 2011

8:15 AM – 10:00 AM: Day Two Keynote – Dell Ballroom

1:30 PM – 2:45 PM: SSIS in the Enterprise – Room 6E
Elegant solutions deliver function and form. SSIS - in Denali and previous versions - supports elegant design. In this presentation, SQL Server MVP and author Andy Leonard demonstrates key components of an SSIS Framework to facilitate SSIS development that performs and is manageable in the modern enterprise. You can have it all - fast ETL processes, execution lineage, real-time reporting, and historical auditing - and Andy will show you how!

Friday 14 Oct 2011

7:15 AM – 8:00 AM: SQL Server MVP Deep Dives 2 Book Signing – Room 211

8:15 AM – 10:00 AM: Day Three Keynote (David DeWitt!) – Dell Ballroom

11:30 AM – ~1:00 PM: Birds of a Feather – Dining Hall

~12:15 PM – 1:30 PM: PASS Board Meet and Greet / Q & A – Room 307-308

2:30 PM – 3:45 PM: Are you a Linchpin? Career management lessons to help you become indispensable – Room 4C4
Speakers: Andy Leonard, Andy Warren, Brent Ozar, Brian Kelley, Jeremiah Peschka, Kevin Kline, Louis Davidson, Stacia Misner, Thomas LaRock
Are consultants better than people who work for ‘regular’ companies? Perhaps it is the other way around? No classification of IT worker is inherently smarter or better than another. However, I believe that many successful SQL Server professionals share similar characteristics that shape their careers and success. Of course they have interesting differences as well! This session explores 20 years of my ideas, learning, and research on this topic. The session also highlights the experience of top SQL Server professions who will share personal thoughts on what has made them indispensible. The panel includes leading professionals from the consulting and corporate side of life as well as a mix of BI/relational and technology/leadership roles.
Brian's 20 year career in SQL Server and personal experience in working with and mentoring dozens of highly successful SQL Server professionals around the world adds unique value to this panel discussion.


If you read this blog and will be at the PASS Summit 2011, introduce yourself! I’m the fat guy with a fu.


Published Friday, October 7, 2011 11:45 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



unclebiguns said:

Like you're the only fat guy with a fu that'll be there.

Seriously the Friday session sounds great.  I need to get the DVD's since I won't be there.

October 7, 2011 9:44 PM

John Sterrett said:

I am cannot wait for the DVD's for this session as I am speaking at the same time.

October 10, 2011 9:18 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement