Browse by Tags
Hi Folks, I'm mostly recovered from a machine crash---hard drives are the bane of the computer world---and will hopefully get to do a little more blogging soon. For now, I just want to note that our first spatial white paper just went live. This
Read More...
Hi Folks, As we continue to shut down SQL Server 2008, our first release candidate has been released . In addition, the RC0 of the Feature Pack, which includes the System CLR Types package, is available here . This package includes the spatial functionality
Read More...
Hi Folks, As a vague part of what has become an ongoing spatial road show, I find myself in Vancouver, BC this week at the SIGMOD conference. I don't know how many readers I have attending this event, but if there are any, please feel free to track
Read More...
Hi Folks, One of the most common questions about the spatial support in SQL Server is how to visualize results. To illustrate the problem, consider a query over zip code data: select id, shapegeog from zipcodes where id like '981%' The results, while
Read More...
Hi Folks, We have one more upcoming pre-release before we're done with SQL Server 2008, and while I've posted a few articles about the coordinate order swap, there's another exciting piece we're releasing: our builder API. Let's say you wanted to write
Read More...
Hi Folks, I'll be at TechEd next week, so look me up if you're going to be in Orlando next week and want to chat. Michael Rys and I will be giving an overview spatial presentation (DAT320) at 10:15 on Thursday, and I'll be showing off some development
Read More...
A common general SQL question just popped its head up in the Spatial Forum : when presented with a SQL query, in which order are the parts executed? To be concrete, consider the following table and query: T: x 0 1 2 SELECT x FROM T WHERE x <> 0
Read More...
Hi Folks, In previous posts about our new geography type, I've discussed ring orientation and too-large polygons , but there is much more information to mine. I'm going to continue here with a discussion of edges. This post may be a little dense for those
Read More...
Hi Folks, I've been asked a few times how to find out what spatial columns are defined in a database. We don't have any special table for this, but you can easily find out by looking at the usual system views: SELECT ta.name as table_name, co.name as
Read More...
Hi Folks, Perhaps it is surprising, based on the content here, that I'm not a full-time spatial head here in SQL Server land. (We leave that job to Ed .) I have, of course, been spending a lot of time on spatial, but it turns out I have other responsibilities
Read More...
Hi Folks, In my last indexing post , I filled in most of the details about our multi-level grid index. Let me clean up a few lingering questions about our planar grid. We'll do this Q&A style: Q: What happens if I set the maximum number of cells-per-object
Read More...
Hi Folks, I recently got contacted via email with the following problem: ... I have 2 complex polygons, representing district boundaries. The polygons look correct, but I'm getting exceptions when I try to create the type. I've attached the wkt polygons
Read More...
Hi Folks, We don't call them betas, but that's basically what CTPs are: they let us suss out problems before we drop a final product on everyone. Well, we've found a regression in the February CTP spatial support that we'd like to let you know about.
Read More...
Hi Folks, I just thought I'd take a few moments clarify the upcoming coordinate order swap for the geography type. Here's a quick FAQ on the issue: What exactly is the change? We are swapping the coordinate order for well-known text (WKT) and well-known
Read More...
Hi Folks, Well, it looks like Ed finally started blogging. (I'll try not to let him take too much pressure off me and slide worse than I have.) In his first post , he reveals what new spatial functionality is available in the most recent CTP. We have
Read More...
