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.
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…
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.
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.
Torsten Grabs gibt einen Überblick über seine Arbeit an Microsoft SQL Server 2008 als Lead Program Manager. Er erläutert seinen Beitrag zu „Data Warehousing“ und beschreibt anhand eines Beispiels an der Tafel „Query Optimization“
und deren Vorteile für die Kunden.
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 work…
In this tutorial, Drew DiPalma will walk you through the steps to connect Azure Machine Learning to Azure SQL Data Warehouse. You'll be able to follow along to build and train a model using a sample data set.
Cesar Galindo-Legaria arbeitete an Erstellungs- und Nutzungsvorgängen von Partitionstabellen und räumlichen Abfragetabellen. Seine drei Hauptaufgaben waren spezielle Verarbeitungen, parallele Partitionstabellen und Tabellenausführungen, u. a. von geographischen
und räumlichen Tabellentypen.
In this tutorial, Drew DiPalma, walks through how to create a new Azure SQL Data Warehouse database with the AdventureWorksDW sample data set. Drew then shows how to quickly connect and build a dashboard of the data using PowerBI.