Now here's an interesting use of the spatial support in Microsofts SQL Server 2008: Battleship.
Using points, linestrings and hit-testing, Craig developed a small battleship game you can play by executing some stored procedures:
EXEX NewGame 'Craig'
EXEC Cheat 13,4
EXEC Shoot 13,4,1,1 -- Miss
EXEC Shoot 13,4,3,1 -- Hit
EXEC Shoot 13,4,3,2 -- Sunk
I'm not sure this was what Microsoft had in mind, but definitely nice work Craig!