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>

A Day of SSIS in May

Introduction

I could run through the abstract for my submission to the SQLRally pre-con - and I will include much of it in this post.

But Wait There's More!

It's difficult to convey in writing my passion for SQL Server Integration Services. I like the platform - a lot. I love sharing SSIS with others for a bunch of reasons; chief among them is I had a difficult time learning SSIS and want to help as many people as possible over the hurdles that I experienced.

It's why I took vacation time in October to train people in Boston and why I'm taking more vacation time in December to do the same. I love delivering SSIS training! Nothing thrills me like seeing the lights come on or hearing a student say "So that's how you do that in SSIS!" I don't claim to be an expert - I claim to be experienced. But that's separate and distinct from a passion for ETL and SSIS.

Is SSIS perfect? Nope. But it's better than most people think. The chief complaint about SSIS is: It's difficult to learn. And that's a fair complaint - SSIS is not easy. But it is possible to learn SSIS. I know. I've trained hundreds of SSIS developers.

You can learn more about SSIS at A Day of SSIS, but first you have to vote here. My friend Joel Cochran (Blog | @JoelCochran) hired me for a day this summer to help him learn SSIS (and do some database design). You can read more about his experiences here and here.

Abstract

Get pragmatic advice for developing, maintaining, and managing SSIS in your enterprise. With a focus on developing SSIS packages with maintenance and management in mind, this day-long session covers SSIS Design Patterns for efficiently loading data, developing a centralized custom logging solution, and developing a metadata-driven SSIS package execution solution. Then, Andy demonstrates how to use this suite of applications to perform predictive analytics and continuously improve your SSIS ecosystem.

Take-Home Skills

  1. Incremental Load SSIS Design Patterns
  2. Metadata-driven SSIS Package Execution solution
  3. Centralized custom logging solution
  4. Log Analysis for Predictive Analytics
  5. Log Analysis for Continuous Improvement

Conclusion

There are lots of good candidates for SQLRally pre-conferences. I urge you to make your selections known by voting. I hope to see you in Orlando in May for A Day of SSIS!

:{> 

Published Monday, November 01, 2010 12:00 PM by andyleonard
Filed under: , ,

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

No Comments

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