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 Presentation Submissions


It is always an honor to present – always. This year I have submitted four presentations to the PASS Summit 2011. You can view my submissions, as well as those of others, here.

A Day of SSIS in the Enterprise
Pre-conference session, 7 hours

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.

“I See a Control Flow Tab. Now What?”
Regular session, 75 minutes

This highly-interactive, demo-intense presentation is for database professionals and developers who are just getting started with SSIS or want to know more about SSIS package development. Attend and learn how to build SSIS packages from the ground up from SQL Server MVP and author Andy Leonard!

Managing Teams
Regular session, 75 minutes

Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, lessons learned, and war stories and from years of managing and leading teams.

SSIS in the Enterprise
Regular session, 75 minutes

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!

“So You Want to be a Database Professional?” (Added after I realized I could submit one more regular session)
Regular session, 75 minutes

Andy Leonard facilitates a discussion about becoming a database professional, compares and contrasts the many different careers included in the field "database professional", provides tips on career management and professional growth, and advises attendees about personal branding in a corporate environment.


There are a lot of great submissions to this year’s Summit and I wish everyone the very best!


Published Thursday, May 5, 2011 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


No Comments

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement