PDC 2009 is next week – I’ll be Building Location Aware Applications with the SQL Server Spatial Library at Session SVR33 – Tuesday

I will be presenting at PDC next week with Ed Katibah and Torsten Grabs on uses of the SQL Server Spatial library (SQLTypes).   The session will be on Tuesday at 12:30pm.    Title: Building Location Aware Applications with the SQL Server Spatial Library Abstract: Did you know that the new SQL Server 2008 Spatial Types are…

0

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 VIII: WiE uses SQL Server Integration Services (SSIS) to synchronize SQL Data Services (SDS) with SQL Server 2008.

  In the previous article we covered using the use of INSERT triggers along with the new Spatial data-type support in SQL Server 2008 to implement “spatial rules” for our location-based service.  All that remained was to implement a mechanism to make all the location data hosted by SQL Data Services visible SQL Server 2008. …

2

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

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