Data Warehousing

Eric Hanson is a Lead Program Manager for CORE RDBMS processing. He coordinated and worked on data warehouse scalability related improvements and details the benefits of these for customers. He also talks about some other new features in SQL Server 2008.

As a Developer Lead on the Engine team Cesar worked on a number of new optimizations for SQL Server 2008.  The three biggest features were indexing for spatial and geographical data types, parallel execution for partitioned tables, and enhancements for star join processing.

Torsten Grabs is a Lead Program Manager on the SQL Server Engine Team. He discusses his work as a Lead Program Manager on Microsoft SQL Server 2008. He explains his contribution to Data Warehousing in SQL 2008, and its benefits to the customers. (Includes a white board example.) He also talks…

Alejandro worked primarily on scenario testing. His biggest challenges were the data warehousing scenarios.

Leo Giakoumakis is a Test Lead in the SQL Server team.  His team is responsible for the quality of query optimization, making sure that queries used in the new features are optimized properly and also that existing customers don’t see regression from their level of performance when upgrading…

Christian Kleinerman is a Group Program Manager and he has been working on SQL Server for 8 years. He talks about some of the key features in SQL Server 2008 that have been delighting customers. An explanation of Resource Governor is also provided.

Xin talks about the query optimization testing team and how they work to achieve the best performance and delivery. Technical difficulties and his work on the StarJoin features are detailed. He later talks about his position and experience on the team, starting work early in the process and…

Peter Zabback talks about his work as a developer and the primary features that he worked on. He talks about challenges like introducing new features without regressions and how this becomes increasingly complex.