Video unavailable

SQLBits 2010

Designing and Tuning high speed data loading

If you want to understand how to load data into Sql Server very quickly then this is the session for you.

In almost all data warehouses there is a requirement to quickly get data into SQL Server. In this talk, I will present the different options you have: SSIS vs. T-SQL. We will look at some common design patterns for scalability and take a deeper look at how the Bulk API for SQL Server works.

Speaker

Thomas specializes in high scale performance tuning and data modeling and has built some of the largest SQL Server database in the world.

Thomas Kejser's Sessions

BigData vs. Data Warehousing

DW Design With The Product Team

Relational Modeling for Extreme DW scale

Finding the Limits

Lessons Learned from 128 Core OLTP Testing

Designing and Tuning high speed data loading

Designing and Tuning high speed data loading

Designing High Scale OLTP systems

Designing I/O systems for SQL Server

Introducing Project Madison