SQL Server 2008 - Adventure Works Racing Community

Adventure Works Racing Community is a demo that highlights several new capabilities introduced in SQL Server 2008 such as Spatial, FILESTREAM and Data Mining.

The application lets users upload videos to a SQL Server database and stores them in the file system using FILESTREAM. It takes advantage of the spatial support in SQL Server to associate the location where each video was shot. This allows users to select a place on a map and watch a video that is geographically closest to the chosen location. Data Mining is used to analyze historical purchases and target each user with ads based on this information.

Lessons

  • Demo: Adventure Works Racing Community
    Demo: Adventure Works Racing Community
    Adventure Works Racing Community is a demo that highlights several new capabilities in SQL Server 2008 such as Spatial, FILESTREAM and Data Mining. The demo is built around the concept that Adventure Works Cycles has decided to launch an online community for bicycle racing enthusiasts. This web…
  • Presentation: Adventure Works Racing Community
    Presentatio​n: Adventure Works Racing Community
    Adventure Works Racing Community is a demo that highlights some of the new capabilities of SQL Server 2008 such as Spatial, FILESTREAM and Data Mining. This presentation is provided as a useful resource to show the main architectural concepts shown in the Adventure Works Racing Community demo.

The Team

This Training Course is the result of effort from a lot of different people. Here is a list of those responsible for creating, editing, developing & testing this Training Course.

Creative Commons License

© 2012 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.