SQLBits 2010

SSIS Dataflow Performance tuning

Need to eek out a bit more oomph from your dataflows. This session might be of some use.

Buiding highly performant data flows takes more than just dragging a few boxes onto the design surface and wiring them up. In this session I'll talk about SSIS's buffer architecture, synchronous and asynchronous transformations, performance tuning knobs and, most important of all, designing for performance.

Jamie Thomson's previous sessions

Real world SSDT

SQL Server Data Tools (SSDT) provide a new declarative model for building SQL Server databases. Come and learn more from Craig and Jamie who have both been using SSDT to do that for many months.

A lap around the SSIS Catalog

SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. Come to this session to learn what it does and how its going to change how you do SSIS development.

Back to the SSIS Future

A look at the new SSIS features in SQL Server code-named Denali

SSIS Dataflow Performance tuning

Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.

SSIS Dataflow Performance tuning

Need to eek out a bit more oomph from your dataflows. This session might be of some use.