Isaac @ MSDN
StreamInsight 2012 on Academy Live
Hi Folks, As part of the SQL Server 2012 launch, I've contributed a presentation on StreamInsight...
Date: 03/08/2012
Map Projections
Cute! Although I’m guessing that people who really are into maps have a slightly higher view of...
Date: 11/14/2011
PASS Wrap-Up
Hi Folks, I just wrapped up my talk the 2011 PASS Summit. Here are a few quick thoughts:...
Date: 10/17/2011
Alastair on Spatiotemporal with StreamInsight
Alastair Aitchison has started a series on doing spatiotemporal analysis using StreamInsight and the...
Date: 08/05/2011
Introducing Checkpointing in StreamInsight 1.2
Hi Folks, As I mentioned some a few posts ago, I recently made a move to the StreamInsight team....
Date: 07/25/2011
The Database Shuffle
Hi Folks, As I mentioned in my previous post, I recently moved from my old home in the SQL Server...
Date: 04/20/2011
It’s Alive!
Hi Folks, Many years ago I kicked up this blog. It started with a trickle of general posts on SQL...
Date: 03/30/2011
Filter: One Odd Duck
Hi Folks, Over at his blog, Nicklas Avéns questions the behavior of Filter. He's right: Filter is a...
Date: 03/04/2010
Spatial Data Type Structure
Hi Folks, As part of a larger effort to document our protocols, SQL Server has just released...
Date: 08/10/2009
The Sphere is Finite
Hi Folks, The title of this post states the obvious: the area of a sphere is finite. We even...
Date: 07/09/2009
New Stuff in SQL Spatial Tools
Hi Folks, Marko Tintor from our Serbia team just dropped some new functionality into the SQL Server...
Date: 06/02/2009
The Plane, the Sphere, and the Ellipsoid
Hi Folks, We all know that the sphere isn’t the plane, and that an ellipsoid is different as well,...
Date: 06/01/2009
SQL Server Spatial Indexing
Hi Folks, This post contains no new information; it’s just a rollup of links to spatial indexing...
Date: 05/28/2009
London Spatial Event
Simon Sabin asked me to pass along information about a free spatial event that he and Johannes...
Date: 04/09/2009
The Spatial Library without the Server: Bug and Workaround
Hi Folks, Jason Follas recently ran across a lingering issue when using our spatial library without...
Date: 02/23/2009
The Geography Hemisphere Limitation
Hi Folks, It occurs to me that I haven’t posted anything about the hemisphere limitation for the SQL...
Date: 02/06/2009
Good Spatial Blog Resources
Hi Folks, While I continue to procrastinate, here are some excellent spatial resources to peruse....
Date: 12/11/2008
Puzzle Solution
Last time, I posted a question sent to me by Rob Mount. So what solutions exist other than the...
Date: 12/08/2008
PDC and a Nice Geographic Puzzle
Hi Folks, At PDC I gave a talk largely inspired by topics raised here and in the spatial...
Date: 12/05/2008
Frequently Asked Question: How do I load shapefiles?
This has come up a few times now. Multiple questions deserve at least one answer, right?...
Date: 11/04/2008
Off to PDC
Despite my relative youth, I can be a bit of a fuddy-duddy. Fighting my natural impulses, I’ve...
Date: 10/24/2008
Nearest Neighbors
Hi Folks, Spatial users often want to find the object nearest a given point. This operation, usually...
Date: 10/22/2008
A Few Strange Functions
Hi Folks, A post on the spatial forum last week caught my attention for entirely non-spatial...
Date: 10/16/2008
Conference Correction
Hi Folks, Unfortunately, I need to correct an earlier post of mine. I will not be speaking at...
Date: 10/09/2008
Upcoming Conferences
Hi Folks, I'd like to let everyone know about a few conferences that I'll be at in the near...
Date: 09/17/2008
The Gnomonic Projection and Operations on the Globe
Let's talk about projections---or at least about one very special projection: the gnomonic...
Date: 09/02/2008
Is my spatial index being used?
I've seen a problem commonly phrased something like: I have X million records in a spatial table,...
Date: 08/29/2008
Connecting With Connect
Hi Folks, This post is motivated by some recent discussion I've seen in the various tubes. I...
Date: 08/15/2008
New Goodies in SQL Spatial Tools
Hi Folks, Marko Tintor, one of our spatial developers, just uploaded a bunch of new functionality to...
Date: 08/14/2008
The Imprecise Nature of Geometry
Hi Folks, Let's kick this off with what may be a surprising result. What should this code...
Date: 08/07/2008
CodePlex: SQL Server Spatial Tools
Hi Folks, I've just published a new project on CodePlex: SQL Server Spatial Tools. The core...
Date: 08/01/2008
Curves on a Round Earth
Hi Folks, When we talk about lines on the Earth, we don't really mean straight lines: we following...
Date: 07/28/2008
Spatial White Paper: Mapping and Coordinate Systems
Hi Folks, I'm mostly recovered from a machine crash---hard drives are the bane of the computer...
Date: 07/17/2008
RC0 is Out: Spatial Notes
Hi Folks, As we continue to shut down SQL Server 2008, our first release candidate has been...
Date: 06/10/2008
And the Conferences Keep Coming
Hi Folks, As a vague part of what has become an ongoing spatial road show, I find myself in...
Date: 06/09/2008
Eye Candy of the Highest Order
Hi Folks, One of the most common questions about the spatial support in SQL Server is how to...
Date: 06/02/2008
Our Upcoming Builder API
Hi Folks, We have one more upcoming pre-release before we're done with SQL Server 2008, and while...
Date: 05/30/2008
Coming to TechEd
Hi Folks, I'll be at TechEd next week, so look me up if you're going to be in Orlando next week and...
Date: 05/30/2008
Evaluation Order
A common general SQL question just popped its head up in the Spatial Forum: when presented with a...
Date: 05/06/2008
Edges on the Globe
Hi Folks, In previous posts about our new geography type, I've discussed ring orientation and...
Date: 05/03/2008
Where are my Spatial Columns?
Hi Folks, I've been asked a few times how to find out what spatial columns are defined in a...
Date: 04/15/2008
Connect and Implicit Casts
Hi Folks, Perhaps it is surprising, based on the content here, that I'm not a full-time spatial head...
Date: 04/10/2008
More on the Multi-Level Grid
Hi Folks, In my last indexing post, I filled in most of the details about our multi-level grid...
Date: 04/08/2008
The Unexpected Too-Large Polygon
Hi Folks, I recently got contacted via email with the following problem: ... I have 2 complex...
Date: 04/05/2008
February CTP Optimizer Issue
Hi Folks, We don't call them betas, but that's basically what CTPs are: they let us suss out...
Date: 03/10/2008
The Upcoming Geography Coordinate Order Swap---A FAQ
Hi Folks, I just thought I'd take a few moments clarify the upcoming coordinate order swap for the...
Date: 03/05/2008
Let Ed tell us what's new in the February CTP
Hi Folks, Well, it looks like Ed finally started blogging. (I'll try not to let him take too much...
Date: 02/29/2008
Basic Multi-Level Grids
Hi Folks, Last time, we highlighted several problems with a simple grid index. If you don't...
Date: 02/29/2008
Picking up on Indexing: Moving Beyond the Simple Grid
Hi Folks, Well, I never did complete my series of posts describing our indexing scheme. I guess I...
Date: 02/05/2008