SQL Server 2005 has some new GIS data types. How many of you are GIS savvy? Well I’ll by the first one to admit that I don’t work with GIS data. But I am starting to look at SQL Server 2008 and trying to encourage our GIS guy to look at the new GIS data types within SQL Server. Today the Redmond Magazine has an article where John Baleja, senior product manager at mapping software provider ESRI says “…will be easier integration with other applications, more security and possibly better performance.” Now as I already said I know very little about GIS data, but this statement by an ESRI management type would lead me to believe that have GIS data types in SQL Server 2008 might be a big deal, a good thing, and something worth looking at. When I told our GIS guy about this article, the GIS data types, and suggested he might want to look at how SQL Server 2008 might support storing his layers of GIS data he said something like “I must not have enough to do if I’m thinking how SQL Server 2008 will support GIS”. I see these new data GIS data types as an opportunity to determine if we can leverage SQL Server 2088 to better support our existing environment. I’m interested in hearing your comments about the new Spatial Data types in SQL Server 2008. Will these new data type really make your environment more security, and provide a boost in performance for your GIS data stores? For you GIS types out there do you see value in migrating your GIS data into SQL Server 2008?
About Greg Larsen
Started my IT career as a programmer. Became a DBA in 1985. Started working with SQL Server as a DBA in 1999. Holds a MCITP. Is a PASS chapter leader for the Olympia Area SQL server User Group. Freelance writer with a main focus on SQL Server.