Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Spatial Data in SQL Server 2008

All editions of SQL Server 2008 hav the new spatial data type geometry and geography (including express) and if you want to know more about doing interesting stuff with spatial data you really need to get to Microsoft’s offices… on 16 April for a dedicated SQL Server community event on this subject given by spatial… Read more

SQL Server Advent Calendar 22 – Spatial Data

Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008.. SQL Server 2008 now has data types to store points lines and polygons in 2 spatial data type, Geometry and Geography. I have already posted quite extensively on spatial data, but it is is one of my favourite new things… Read more

SQL Server 2008 Geo-Spatial functions and indexes

SQL Server 2008 enables the use of geo-spatial data or location intelligence in four ways: a new geography data type (there’s another one for 2D geometry), which can store points, lines, line segments and polygons A rich set of functions to make use of them, e.g. whether they intersect, how far are they away etc…. Read more

SQL Server 2008 & Virtual Earth

There’s a lot of buzz around Software plus Services (S+S) from Microsoft and others.  It’s all very simple as Eileen will tell you -  it’s when you use a service like GPS that’s remote and public and combine it with some software like CoPilot or TomTom on your GPS to find directions.  In a similar… Read more

SQL Server 2008 Spatial Data Types

Continuing my series of notes following the TechNet event last Thursday evening,  I wanted to explain that in SQL Server 2008 there are two new data types for storing spatial information; geometry and geography.  Unfortunately on Thursday I didn’t have the final release of CTP5 so my demo didn’t have the geography data type and… Read more