I've replied to your post at http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/28729874-1199-4dcb-a39b-bd63e504d93d

You work in the healthcare industry and you've got no budget? You surprise me 😉

Well, yes... but in that case you've probably got other problems. Like no support 😉

You don't need Sedonos equations. Just use SQL Server's own STDistance() method to accurately calculate the distance on the ellipsoid model of the spatial reference system in which your geography...

Hi Rehman,

You can check out "Beginning Spatial with SQL Server 2008" (http://www.amazon.com/Beginning-Spatial-Server-Experts-Voice/dp/1430218290), which has chapters covering the following topics:

1. Defining Spatial Information

2....

Are we talking 'metaphorical' father and son relationships here, as in the nodes in a graph that may be described as 'parents' and 'children', or do you really mean a...

A (sort of related) point:-

Unless I'm mistaken, the Entity Framework still doesn't support CLR UDTs on the server. That pretty much makes it a no-no if you're planning on using...

Agree with David - although this article was only stated to cover FOR XML, you've totally wasted the opportunity to demonstrate some of the other XML features of SQL Server...

Oh, please don't get me wrong - it's absolutely still a useful script - I was just drawing people's attention to the fact that such features are inbuilt in SQL...

Of course, if you are using SQL Server 2008, you don't need to use spherical approximations such as this - just use the inbuilt spatial functions:

Point1.STDistance(Point2)

STDistance() gives a more accurate...

I think you're making this more complicated than it needs to be! You can construct the WKT representation of a point by concatenating together the string values of each coordinate,...

Another good article. Well done.

Readers might want to note that the spatial reference identifier not only refers to projected spatial reference systems as suggested, but to geodetic spatial reference systems...

Nice article - you seem to have laid out a good foundation of topics to cover. There are just a couple of points I wanted to add:

The SQL Server-native geography...