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.
Himanshu talks about FILESTREAM and SQL Server Client and their advantages. He discusses the challenges of implementing these new features in this release. He also describes improvements that have been made in the 2008 release.
As a developer for the Relational Engine, Miles dealt with scalar expressions and data types. He worked on the improvement to add new DATETIME types and discusses the challenges of implementing multiple calendars (focused on the Islamic calendar).
Jun Fang is a Development Lead in the SQL Server team. He led a team that was responsible for data type, sparse columns and wide table, and spatial support features. Team pioneered the CLR feature in SQL, providing the extensibility framework for both
internal and external programming interface.
Jing Chang is a Tester in the SQL Server Entity Framework. She discusses her job as a tester for SQL Server and the challenges of her work. She works with entity frameworks, mapping and metadata. She also gives us an example of her daily life.
Bruno talks about his work on the Engine team, developing the syntax for the new MERGE operator, which according to data warehousing metrics is much faster than in previous versions of SQL Server. He also talks about his background in client-side languages
and how that helped him become part of…
Roger Fleig talks about working as a test manager for the SQL Server engine. He also discusses his challenges including adding a large number of new features, innovations and changes to SQL Server 2008 without breaking anything, and operating the testing
on the same scale as customers.