SQL Server’s DATEFIRST setting applies only to the current statement and cannot by set globally on a server. It also cannot be used in user defined functions (more…)11th November 2009 27th October 2009
Run Replay is a web app that allows runners to upload their running data (more…)8th September 2009
I have just finished building an sms driven results service for the Uphill to Wells Relay which sets off from the beach at Uphill, this Saturday. Runners will send their finish time at the end of each of six legs to a central number which will update the event results page and generate progress updates. (more…)11th February 2009
After many weeks of hectic preparation, Olly Hicks has finally set off on his Virgin Global Row, a daring attempt to be the first to row solo around the bottom of the globe. Having already proved his credibility with a transatlantic crossing under his belt, he has managed to attract an impressive list of supporters for this latest escapade.
My small role in the project was to create the embedded Google Maps tracking display for his website (more…)6th October 2007
Having been asked a number of times how to calculate the distance between a pair of co-ordinates in SQL Server I have finally got round to posting the function used by www.oceanracetrack.com in various places.
The function takes a Lat/Long start point and Lat/Long end point and returns the distance between them in nautical miles. (more…)1st August 2007
My brief was to create the first live web tracking for the Rolex Fastnet Race. The classic ocean yacht race from Cowes to Plymouth via the Fastnet rock off south-west Ireland.