Category Archives: SQL Server

SQL Server Spatial

Learning SQL Server spatial.

Microsoft SQL Server, has had supported for spatial for quite sometime. It never really interest me until recently when we are working on mapping system. It’s all started when we were task to do project management consulting for LLM which is responsible for the country toll highways. It’s a pain to watch those guys working with spatial object in Oracle.

From then on we know, that we can’t ignore this. With the emergence of web mapping services such as Google Map and Microsoft Bing Map, couple with the affordability and ubiquity of GPS enabled devices. Microsoft SQL Server spatial is made easy if you are .Net developer and understand the concept of CLR and it’s hosting. From .Net developer point of view it’s just another class , another datatype, with a set of inheritance, properties and method.

Part 2