22-25 April 2026 
SQLBits 2011
Relational Modeling for Extreme DW scale
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
This session is delivered with Alexei Khalyako of the SQL Server Customer Advisory Team (SQLCAT) . Alexei has been with Microsoft since 10+ years. The world has an unlimited appetite for data storage. While the architects are hyping on about Cloud, Map/Reduce, MPP and Complex Event Processing– there is still an old school of businesses that rely on good old fashioned relational databases for analysis and storage. Some SQL CAT team members still hold the banner high on good old data modelling. This session is your chance to meet a few of those men. We will walk you through hard earned field lessons, doing TB sized installations. We will let you know what our experience shows will work, and what doesn’t, if you are going to build a large data warehouse. We will talk about how you go from a Kimball logical model to something that will actually work inside SQL Server. It IS our hope that when you design a new system you will avoid the worst pitfalls.
Speakers
Thomas Kejser's previous sessions
BigData vs. Data Warehousing
: We are looking at the dawn of a new workload: BigData. In this session I will talk about what BigData is, and which BigData technologies Microsoft are working on.
DW Design With The Product Team
This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.
Relational Modeling for Extreme DW scale
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
Finding the Limits
In this session, I will take simple SQL statements, the stuff you write every day, and bump up the scale until things start breaking
Designing and Tuning high speed data loading
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server so come here my talk on the options you have.
Designing High Scale OLTP systems
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server. This talk focuses on lessons learned when using high end hardware and stressing it.