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

WiE project and source code posted to CodePlex!

Good Afternoon, I’ve just completed posting the WiE community project to CodePlex.  As this is my first CodePlex project I expect that I may have forgotten some steps so please let me know of any issues you experience and I will work to resolve them quickly. You can find the project at: http://www.codeplex.com/wie In the…

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 V: Keeping WiE Mobile Client in sync with the Cloud, a first pass at synchronization.

The Implementation of WiEModelWithLocalCache As we discussed in the previous articles, the data layer for the WiE Mobile Client is made up of “providers” that each implement the IWiEModel interface and work together to implement support for the occasionally disconnected mobile scenario.  Over the past two weeks article we covered the implementation of the local…

4

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

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