Videos from Tech-Ed: Building Location-Aware Services with SQL Server 2008 Spatial – WiE Demo and Code Walkthroughs

It has been way too long since I’ve blogged.   I have no (good) excuse. I had the opportunity to attend and present at last week’s Tech-Ed conference and had a great time meeting customers and getting feedback and suggestions on SQL server and our developer tools. Our session on WiE (Building location-aware services using SQL…

1

Part VII – WiE Goes Spatial: Using SQL Server 2008 as a Spatial Rules Engine for Location-based Services.

In this second to last chapter in the series I’ll discuss leveraging SQL Server 2008’s support for spatial data types to implement the “spatial rules” for the WiE Community.    Specifically, this article will implement 2 examples of simple proximity rules that drive most location-based service scenarios: –          Proximity to a Point of Interest (fixed) –         …

2

Part VI – Visualizing WiE location information using the new server-side Virtual Earth ASP.Net Map Control

  In the previous article of this series I mentioned that we would next discuss how to visualize the GPS information we’ve been collecting and storing in SSDS.   This article looks at using Virtual Earth to visualize the location history for members.  For this implementation I chose to try out the brand new ASP.Net Virtual…

1

Part IV: WiE reaches for the Cloud…Implementing the SQL Server Data Services (SSDS) data model for the WiE Mobile Client.

The Implementation of WiERemoteModelSSDSForMobile The WiERemoteModel expects to store and retrieve data from SQL Server Data Services  (SSDS).   I won’t include the entire implementation of the WiERemoteModelSSDSForMobile in-line as we plan to eventually provide the entire project for download but I will highlight some of the key methods to explain the implementation. As we discussed in…

5

Part III: Implementing the SQL Server Compact local Model for the WiE Mobile Client.

In the first article in this series I introduced the concept for the WiE Community, a mobile and location aware social networking community.  In last week’s article we covered the high level architecture and the design for the WiE Mobile Client.  In this week’s article I’ll go into the next level of detail and cover…

4

Part II – The WiE Mobile Client: Architecture & Design – Collecting GPS data and storing it into a SQL Compact database.

  In last week’s article I introduced the WiE Community project I have started working on.    WiE is a location-based social networking community built to demonstrate an end to end application built on top of SQL Server Compact, SQL Server Data Services and SQL Server 2008.   In this week’s article I describe the overall architecture and…

4

What is WiE? What happens when you put Windows Mobile, SQL Server Compact, SQL Server Data Services, Sync Framework, WPF and SQL Server 2008 together?

Before joining Microsoft I had started my own company to market a software as a service offering to the specialty trade contractor segment of the construction industry.   Our service was called JIM (Job Intelligence Manager) and was a mobile project management application that enabled contractors to report their timesheets, job progress and location using their cell phones…

5