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.
Speakers
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.