Posts
  • Isaac @ MSDN

    Another Cool Tool

    • 0 Comments
    Hi Folks, Oops! I missed another neat tool in my last post. Simon Sabin has created a utility called SpatialViewer that lets you draw geometries. Better yet, he's posted the thing to Codeplex so you can futz around with it. I'm always looking...
  • Isaac @ MSDN

    Some Cool Tools for SQL Server Spatial

    • 1 Comments
    Hi Folks, I'm finally getting back in the rhythm of things after the hollidays. While I work on my next spatial indexing post, I thought I'd highlight a few very cool tools that people have built to work with SQL Server Spatial. Morten Nielsen has...
  • Isaac @ MSDN

    Mistakes Pay?

    • 2 Comments
    Hi Folks, I guess I wasn't paying enough attention while I was on my end-of-year vacation, since I read right over the last paragraphy of Paul Ramsey's recent post : That kind of community responsiveness practically cries out for... a five pound...
  • Isaac @ MSDN

    Latitude-Longitude Ordering

    • 16 Comments
    Hi Folks, If you've been following the spatial forum over at MSDN, you've probably run across this thread . In short, we've ignited quite a controversy with the coordinate ordering for the well-known text and well-known binary we use for the geography...
  • Isaac @ MSDN

    SQL Server Spatial on the Web

    • 2 Comments
    Hi Folks, Now that our initial spatial support has shipped, there has undestandably been an uptick in discission on the web. It seemed time for a bit of a link post. Besides this blog, the forum I'm most involved in is the Kamai Spatial forum on...
  • Isaac @ MSDN

    Spatial Indexing Part 3: Faster Primary Filtering

    • 4 Comments
    Hi Folks, Last time we talked about a simple primary filter. (See previous installments: 1 , 2 .) We stopped short, however, of showing how this primary filter would actually make anything faster. Recall that our simple grid index defines a table...
  • Isaac @ MSDN

    Spatial Indexing Part 2: A Simple Spatial Indexing Scheme

    • 5 Comments
    Hi Folks, Let's continue with the discussion of spatial indexing form last time . If you already know a lot about spatial indexing these first few posts are going to be a lot of background---hopefully I don't make too many mistakes. :) We're going...
  • Isaac @ MSDN

    Spatial Indexing Part 1: Why a Spatial Index?

    • 7 Comments
    Hi Folks, If you've seen one of my recent spatial talks, you've seen me walk through the basics of how our indexing works. I'm going to do roughly the same thing here over a series of blog posts, except that I'm (eventually) going to go into a few...
  • Isaac @ MSDN

    Get yer spatial!

    • 7 Comments
    I'm happy to say that our latest community technology preview (CTP), officially dubbed the "November CTP" for obvious reasons, has been released. You can get it here . This CTP has all of the spatial funcitonality we've been talking about: Planar...
  • Isaac @ MSDN

    After the Webcast

    • 8 Comments
    I had a few technical problems with the webcast that pushed our start time back about five minutes, but after switching to a different machine things went fine. I'm now recorded and online here . I generally don't like giving these webcasts, as I find...
  • Isaac @ MSDN

    Webcast: Introduction to Spatial in SQL Server

    • 3 Comments
    Hi Folks, Tomorrow morning ---1 November at 9:00AM PST PDT* ---I'll be giving a webcast on MSDN presenting the basics of the new spatial capabilities in SQL Server 2008. Tune in here . Cheers, -Isaac --- * I hate daylight savings time....
  • Isaac @ MSDN

    In or Out?

    • 5 Comments
    I've been stalling, trying not to say too much about spatial until it's actually available. The code has all been in for some time now, but its been waiting for its release vehicle: the next CTP. Hopefully it should be in your hands in a few weeks. ...
  • Isaac @ MSDN

    Measurement Type

    • 2 Comments
    I got an interesting Connect item recently asking for a measurement type. (Yes, we do read these!) Essentially, the request was for a unit-aware value. From the request: When we need to store measurements types in a table, we are faced with a problem...
  • Isaac @ MSDN

    Where's the Beef?

    • 0 Comments
    One of the most common things people want to know about spatial support in SQL Server is when they can get their hands on it. While I don't manage the final CTP schedule, I can say that all of the bits are in (modulo a few DCRs and the inevitable bug...
  • Isaac @ MSDN

    Making Change

    • 4 Comments
    Raymond Chen has a post today about making change, which reminded me of an interesting problem. American currency (or most currencies, for that matter) has the desirable property that the greedy solution to giving change results in giving change using...
  • Isaac @ MSDN

    Directions Interviews Ed Katibah

    • 2 Comments
    For those of you who aren't conent with the slow trickle here, Ed Katibah, our lead spatial PM, recently answered questions for Directions Magazine . Cheers, Isaac
  • Isaac @ MSDN

    One Type, Two Types...

    • 10 Comments
    This is a little bit less of an introductory post than the last one , but there was quite a bit of discussion about our decision to split our spatial types in two---one for our planar ("flat-Earth") model and one for our ellipsoidal ("round-Earth") model...
  • Isaac @ MSDN

    SQL Server Spatial Support: An Introduction

    • 32 Comments
    I’ve been pretty quiet around here, and at least part of the reason is that we’ve been pretty tight-lipped about what we’ve been up to. We’ve now gone public—we’re providing support for geospatial data in our next version of SQL Server, codenamed Katmai...
  • Isaac @ MSDN

    Medians Revisited

    • 0 Comments
    A couple posts---and a long time---ago, I wrote about computing medians in T-SQL . Adam Mechanic has a new post on his blog that explores a few other solutions. It looks like the better of the two, which he credits to Joe Celko, bests my solution by a...
  • Isaac @ MSDN

    Simple Spatial Search

    • 0 Comments
    Hi folks, I gave a talk about storing simple spatial data at SQL Server Connections last week. The conference has put slides and sample code online. Hopefully this is of use to some folks out there---if it is, please drop me a line! Cheers, ...
  • Isaac @ MSDN

    At long last, a post: Medians in T-SQL

    • 4 Comments
    Well, shoot. Start a blog and then never post to it---not the best use of bits. I can't promise that this will be the beginning of a post-filled revolution, but it will hopefully be of some use. Assume you have a schema like: sales(city varchar...
  • Isaac @ MSDN

    Introduction

    • 0 Comments
    Hello World, and welcome to my blog. For those who don't know me---which is probably most of you---I am a program manager for the SQL Server engine, particularly for various aspects of engine programmability. I plan to keep this space as on-topic as...
Page 3 of 3 (72 items) 123