SQL Behind the Scenes – English

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…

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.

Carolyn talks in detail about the new reporting features of SQL Server 2008 as well as Report Builder 2.0, and describes how easy it is now for users to access data and create rich reports with data visualizations.

Tatyana Yakushev is a Developer in the SQL Server Analysis Services Team.  She discusses working as a Data Mining Developer on the Analysis Services Team as well as Data Mining for Microsoft Office.

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.

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…

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

As a Lead for the Build Operations team Cate manages the build labs and component builds for SQL. She talks about her role of ensuring that all components get built properly, on time, as well as fixing any breaks. She discusses her biggest accomplishment - moving SQL Server 2008 builds to the…

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.

Nikita Shamgunov talks about working with Semi-structured Data as the main owner of XML within SQL Server 2008, as well as engineering challenges for upgrading XML.