Monthly Archives: July 2011
Spatio-temporal Event Processing with StreamInsight, SQL Server Denali, and Bing Maps – Part 1
Following a recent conversation with Isaac Kunen from the StreamInsight team, I decided that I should find out more about Microsoft’s complex event processing engine. Technology moves so fast that there are probably a hundred topics that I wish I’d … Continue reading
sp_help_spatial_geography_histogram and Indexing geography data in SQL Server Denali
Working with spatial data involves many dark arts, and performance tuning spatial indexes is perhaps the blackest of all of them. Although there are only a few parameters to configure: GRIDS, CELLS_PER_OBJECT, and BOUNDING_BOX, the number of different index combinations … Continue reading
CaSe-SEnsItIvtY when Handling Multiple Spatial Columns in Safe FME Transformations
Some spatial data formats can store only a single logical set of features. Any given ESRI shapefile, for example, can store only POINTs, LINESTRINGs, or POLYGONs – not a mixture of each type of geometry. What’s more, all of those … Continue reading
Determining the Geographic Extent of Spatial Features in a SQL Server Table
I’ve been using the SQL Server Denali CTP(s) for just over 6 months now. As a result, I’ve become accustomed to some of the new features and forget that they aren’t generally available in production environments yet… it always comes … Continue reading
Alastair Aitchison 