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...

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...

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...

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...

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...

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...

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...