home
publications
consulting
training
mentoring
presentations

andy.leonard

contact | technical blog | twitter | facebook | linkedin | personal blog

Learn SSIS from Andy!
Advanced SSIS Training
3 Days, You, SSIS, Tim Mitchell, Andy Leonard: 9-11 Mar 2015
Dallas, Texas
Details

Presentations

Managing Teams Level 100 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, war stories, and lessons learned from years of managing and leading teams.
Designing an SSIS Execution Framework Level 300 In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their life cycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Build Your First SSIS Package Level 100 This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
Database Design for Developers Level 200 This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.
Introduction to Incremental Loads Level 200 This session is for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.
SSIS Design Patterns, Part 1 Level 500 This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.
SSIS Design Patterns, Part 2 Level 500 Building on the demos and experience shared in SSIS Design Patterns, Part 1; SSIS Design Patterns, Part 2 explores package migration through enterprise SLDC tiers, loading variable-length files, and creating SSIS execution groups.
Bio:
Andy Leonard is an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs at SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.