First published on MSDN on Jun 06, 2011
I’m really looking forward to attending the
again this year!
Last year we presented the
SSIS changes in the first public Denali CTP
. It was great to finally be able to show off some of the major features the SSIS team had been working on since the 2008 release. This year we’ll be showing off the latest code, and I find it incredible how much we’ve added to the product in the Denali release. I presented a "What’s New in Denali for SSIS” session
last month that covered the
upcoming Denali CTP
, and had to leave out a bunch of stuff to make it fit my 75 minute time slot!
I’m honored to be presenting a PASS Pre-Conference this year along with
. It will cover my favorite topic –
SSIS Design Patterns
A Day of SSIS in the Enterprise
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
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.
What else would like to see the SSIS team present at the PASS Summit? We’re looking for ideas! Topics can cover the existing versions of the product, as well as what we’re delivering in Denali.
Please let me know!