James Fee GIS Blog

Geospatial Technology, Web Mapping and Spatial Services

James Fee GIS Blog header image 4

Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS

July 21st, 2008 · 9 Comments · GIS

Regina Obe has developed a table to compare the new SQL Server 2008 with PostgreSQL/PostGIS (with MySQL thrown in there to boot).  The table does a wonderful job showing the comparative strengths and weaknesses of all three relational databases.

SHARETHIS.addEntry({ title: “Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS”, url: “http://www.spatiallyadjusted.com/2008/07/21/comparing-sql-server-2008-mysql-and-postgresqlpostgis/” });

[Read more →]

Tags:····

Microsoft Whitepaper - Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

July 17th, 2008 · 13 Comments · GIS

Isaac Kunen blog’s about the first spatial whitepaper Microsoft has released.
Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
Says Isaac: “This paper is a bit of an odd duck: it isn’t SQL Server, or even Microsoft specific in any way. It’s just a little introduction to the use of spatial data.” [...]

[Read more →]

Tags:···

MapDotNet Server 2007 v6.5

January 3rd, 2008 · 2 Comments · GIS, MapDotNet Server

I’ve been getting a demonstration ready to go for a client using MapDotNet Server (MDNS) and figured it was a great time to update to the latest version. Version 6.5 was released December 17, 2007 and is a huge update. Improvements include:

Now uses Microsoft’s Windows Communication Foundation (WCF)
Support for the November CTP of [...]

[Read more →]

Tags:···

Microsoft SQL Server 2008 Spatial Will Be Supported on Free Express Versions

November 20th, 2007 · 41 Comments · ArcSDE, ESRI, Microsoft, OpenLayers, SQL Server, Virtual Earth

I just got this tidbit of information from a friend who talked to Ed Katibah (lead Program Manager for SQL Spatial).
Spatial datatype, methods and indexes will be supported equally on all SQL Server editions (Express, Workgroup, Standard and Enterprise) at no extra charge. That means anyone who wants to use the SQL Server 2008 [...]

[Read more →]

Tags:·······

MapDotNet Support for SQL Server 2008 Spatial

November 12th, 2007 · 4 Comments · Manifold, MapDotNet Server, Microsoft, SQL Server

I’m sure many of us on the MapDotNet email list got the news that full support for SQL Server 2008 Spatial is right around the corner.
MapDotNet Server 6.5 is currently undergoing beta testing and will be released in November 2007. In addition to support for SQL Server 2008, it will provide support for the new [...]

[Read more →]

Tags:······