I blogged a while back on PgMap, a freeware ArcGIS extension for directly connecting to PostGIS. ST-Links, the makers of PgMap, sent out an e-mail this morning announcing that PgMap and QMap (the equivalent technology for interacting with SQL Server 2008 spatial data) have been combined into a single tool called SpatialKit. This move comes […]
Posts under sql server spatial
My blogging has been slower this time around because I’ve been doing a lot of booth duty. This is my thrid conference this year and some of our other staff are getting to go to the sessions. I did, however, go to the SQL Server SIG a little while ago. Ed Katibah had a few […]
There is no direct upgrade yet so you need to remove the November CTP. Apparently, the uninstall doesn’t always work well (hey, it’s beta). Luckily, Tim’s post straightened me out. This worked for me. More accurately, the guidance in Michael’s comment worked for me.
Installing the the SQL Server 2008 November CTP side-by-side with SQL Server 2005 is very straightforward. On the previous build of my machine, I had them both running just fine. After my system crash, I began setting things up again. Because I had been working with 2008 before the crash, I installed that first and […]
So it’s been about a month since the release of the SQL Server 2008 November CTP. I’ve been dabbling with it and have made several posts about it. I still have a lot more digging to do with it but here are my impressions after a month:
UPDATE: Microsoft has announced that they will address this issue in an upcoming CTP. They plan to implement longitude-latitude ordering in WKB and WKT for both the geography and geometry types. In a response to my previous post, Brian Flood mentioned the ongoing discussion about SQL Server 2008 and the “switching” of X and Y […]
Update (7/1/2011): I wrote this post early in the SQL 2008 CTP. I no longer use the method described here. If you found this post via StackOverflow or some other Q&A site, I highly recommend this post by Vish as a more efficient way of doing things: http://viswaug.wordpress.com/2008/09/29/inserting-spatial-data-in-sql-server-2008/ I’m in the process of using SharpMap […]