PASS Precon Information: A Day of SSIS in the Enterprise

andyleonard — Fri, 08 Jul 2011 11:00:00 GMT

Matt Masson, Tim Mitchell, and I are presenting A Day of SSIS in the Enterprise Monday 10 Oct 2011! The following is cross-posted from the PASS Blog:

Today's post is from Andy Leonard who, along with Tim Mitchell, will be presenting "A Day of SSIS in the Enterprise". You can read more about his session here: http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1508.

Is there an audience that would benefit especially from this session?
Yep. Those getting started in SQL Server Integration Services development will get a jump start from topics presented by Matt Masson of the SSIS Developers Team at Microsoft, Tim Mitchell, SQL Server MVP, and me. Experienced SSIS developers are sure to pick up a tip or eight. And we'll be talking about features in SSIS Denali!
After having attended your seminar, what are two or three things that an attendee will be able to take back to the office and put to use right away?
Best Practices has to top that list. Tim, Matt, and I share from years of experience building solutions using SSIS. We three are also 60% of the author team of the upcoming book: SSIS Design Patterns, and we will be demonstrating patterns from the book. Finally, we'll be talking a lot about managing SSIS in the enterprise. After deploying SSIS solutions, developers often realize maintenance and support challenges. Some design decisions facilitate SSIS care and feeding, and we'll cover those!
What background should attendees ideally have to be fully prepared for your seminar?
Ideally, the attendee should have experience with SQL Server and a thirst for more data integration knowledge.
What experience are you, as a speaker, bringing to this session?
Tim , Matt, and I have decades of database integration experience. As a developer on the SSIS Team at Microsoft, Matt has visibility into myriad data integration use cases. As a consultant and trainer, Tim has delivered SSIS solutions to enterprises large and small. My experience spans consulting and managing a team of SSIS developers as we built a multi-year SSIS solution. I understand the challenges unique to developer teams that are part of an enterprise.

Go here to register for the 2011 PASS Summit.

:{>

Presenting at PASS Summit 2011!

andyleonard — Tue, 28 Jun 2011 11:00:00 GMT

Introduction

I am honored to be presenting at the PASS Summit 2011 11-14 Oct 2011 in Seattle! This year, I was selected to present a regular session and a pre-conference session. The pre-con is going to be fun. It’s a team effort with Tim Mitchell (Blog | @Tim_Mitchell| SQLPeople) and – even though he isn’t listed as a presenter – Matt Masson (Blog | @mattmasson).

Like me, Tim’s been using SSIS since it was released; and Matt’s on the SSIS developer team at Microsoft – he helps build SSIS! Our preconference session is going to be packed with information and advice for developing supportable SSIS packages.

SSIS in the Enterprise (Regular Session - Level 400)

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!

A Day of SSIS in the Enterprise (Preconference Session - Level 300)

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.

Conclusion

The PASS Summit is always a great place to network, make new friends, catch up with old friends, and learn cool stuff about SQL Server. If you read this blog and will be attending the PASS Summit this year, introduce yourself! I’m the fat guy with a fu.

:{>

Search results matching tags 'Developer Community', 'Presentations', and 'PASS Summit 2011'

PASS Precon Information: A Day of SSIS in the Enterprise

Presenting at PASS Summit 2011!