SSDT Database projects from the ground-up

2013

TL; DR

Session Details

SQL Server Data Tools (SSDT) database projects bring SQL Server development into the modern era. Come along and learn how SSDT database projects can accelerate your SQL Server development and deployments. You will learn about declarative database development, code navigation, refactoring, automated builds, database unit testing and, most importantly, how you can make these tools work to your advantage.

3 things you'll get out of this session

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.