Tag Archives: SQL Azure

Updating a SQL Server Table with Nearest Neighbours (Optimised for SQL Server 2012 / SQL Azure)

So I’ve been trying to think of some examples that make use of the Garmin POI data from my last post. Seeing as POI data naturally lends itself to nearest-neighbour queries, I thought I’d write a little about those. The … Continue reading

Posted in Spatial, SQL Server | Tagged , , , | 4 Comments

SQL Azure – Keeping up with a Moving Target

Moving your data to the (public) cloud necessarily involves relinquishing some control over the setup and maintenance of the environment in which your data is hosted. Cloud-based hosting services such as Microsoft Azure are effectively just scalable shared hosting providers. … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

Upcoming Spatial Precision Improvement in SQL Azure

In a previous post, I discussed a little about the approach that SQL Server 2008 uses when performing operations using the geometry and geography spatial datatypes, and the precision implications of performing calculations on a fixed size integer grid. Although … Continue reading

Posted in SQL Server | Tagged , | Leave a comment