andy.leonardcontact | technical blog | twitter | facebook | linkedin | personal blog
Learn SSIS from Andy!
||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||
||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||
||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||
||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||
||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||
||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||
||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.|
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.