THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

PASS Summit 2009 - From Zero to SSIS

I learned a couple weeks back my proposal for a pre- or post-conference seminar entitled "From Zero to SSIS" had been selected as an alternate at the PASS Summit 2009. I was a little disappointed,  but then I looked at the incredible speakers and topics selected for pre- and post-conference seminars here

These seminars offer a fantastic opportunity for anyone interested in drilling deeper into database and business intelligence topics.

Here's the abstract I submitted:

From Zero to SSIS

In this extended session, Andy Leonard covers the SSIS development spectrum and lifecycle from introduction, through design and development, into performance tuning, and finally maintenance. Topics of note include:

 - Introductory topics:
    Connections,
    Control Flow,
    Data Flow,
    Package Execution properties and start-up flow.
 - Design considerations:
    Are you loading a data warehouse or simply creating a copy of production for reporting or warm standby purposes?
    Scripting in the Control Flow.
    Scripting in the Data Flow.
 - Advanced design:
    Powerful SSIS design patterns.
 - Beyond Advanced Design
 - Undocumented design: (Attend and see!)
 - Package properties
 - SSIS Expression Language
 - The Secret Life of EventHandlers
 - Logging:
    Built-in logging 
 - Package Configurations
     Built-in package configurations
 - Let's Take This Outside
    Custom logging.
    Custom configurations.
 - Execution Environments.
 - The Art and Science of Deployment.
     To MSDB or not to MSDB?
 - Zen and Performance Tuning.
    Putting the flow into Data Flows.

I'm not sure of all the ways an Alternate session gets promoted to an Accepted - I know it can happen if a selected session cannot be delivered for some reason. But I'll tell you what: if a bunch of you comment on this message indicating you're interested in this one-day seminar, I will forward a link to the SqlPass people. There's still no guarantees, but I figure it's worth a shot.

:{> Andy

Published Monday, June 15, 2009 7:30 PM 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

Comments

 

Sankar Reddy said:

Andy,

If I am attending SqlPass then I definitely would be interested in this session.

June 16, 2009 2:36 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement