I am really excited to be invited back to SQL Bits to do a full day of SSIS training. Once again, I’ll be covering my favorite topic – SSIS Performance Design Patterns. The content will be similar to the talk I gave at SQL Bits 9, with a couple of big changes. First, I’ll be co-presenting with John Welch, SQL MVP and SSIS Community Hero. John will add his own years of SSIS experience to the talk, and I expect he’ll do a great job of keeping me honest. Second, we’ve updated the talk with more Data Warehousing specific design patterns, and additional SQL Server 2012 content.

SQL Bits X takes place March 29th – 31st at the Novotel London West. Check the site for registration details.

I’ll be delivering two additional sessions relating to SSIS in SQL Server 2012 on the Friday and Saturday events.

SSIS in SQL Server 2012, Part 1: Developer Enhancements

The SQL Server 2012 release of SQL Server Integration Services (SSIS) includes a broad range of new features and enhancements designed to ease adoption for new users and increase productivity for experienced SSIS developers. In this demo intensive session, Matt Masson – Senior Software Development Engineer on the SSIS team – guides you through the new developer focused functionality in SQL Server 2012. We’ll look at the productivity enhancements in SQL Server Data Tools (formerly the Business Intelligence Development Studio), team development enhancements, and the new Change Data Capture (CDC) features that ship with the product. If you haven’t seen the new SSIS features in SQL Server 2012 yet, you won’t want to miss this session!

SSIS in SQL Server 2012, Part 2: Deployment and Management

The SQL Server 2012 release of SQL Server Integration Services (SSIS) includes a broad range of new capabilities designed to improve the deployment, management and monitoring of SSIS solutions. The core of these capabilities is the new SSIS Catalog. In this session, Matt Masson – Senior Software Development Engineer on the SSIS team – will take a deep look at the SSIS server, including its architecture, implementation and use.

Hope to see you there!