Tag Archives: Denali

SQL Server 2012 – What’s New for Spatial?

So Microsoft launched SQL Server 2012 today, and you can download the SQL 2012 Express edition right now from http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx No doubt there will be lots of people writing blog articles about the various new features – AlwaysOn, Column Store … Continue reading

Posted in Spatial, SQL Server | Tagged , , , , | 7 Comments

Can’t Cast from SqlGeometry to SqlGeometry and Other Strange Version Conflicts with SQL Server Denali Microsoft.SqlServer.Types

I came across a curious error earlier today when attempting to use a SqlDataReader to read a column of geometry data from a SQL Server table: System.InvalidCastException: Unable to cast object of type ‘Microsoft.SqlServer.Types.SqlGeometry’ to type ‘Microsoft.SqlServer.Types.SqlGeometry’ SqlGeometry to SqlGeometry… … Continue reading

Posted in Spatial, SQL Server | Tagged , | 1 Comment

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

Posted in SQL Server | Tagged , , | Leave a comment

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

Posted in SQL Server | Tagged , , | 6 Comments

A Good Week for Updates–Bing Maps and SQL Server Denali CTP3

It’s been a good week for updates from Microsoft… Bing Maps At the beginning of the week, there was a new version of the Bing Maps AJAX API rolled out (version 7.0.20110630165515.17). There’s a list of changes at http://msdn.microsoft.com/en-us/library/gg675211.aspx but, … Continue reading

Posted in Bing Maps, Spatial, SQL Server | Tagged | Leave a comment

Nearest-Neighbours, Voronoi Diagrams, and Finding your nearest SQL Server Usergroup

As somebody interested in all things spatial, I was delighted that the community corner at SQLBits8 featured an interactive mapping application. Many people commented on how much work had obviously gone into the user interface: the ability to add “pushpins” … Continue reading

Posted in Spatial, SQL Server | Tagged , | 19 Comments

SQL Server Spatial Coordinate Calculation Precision

In a previous post, I discussed a little about the precision with which SQL Server stores coordinates in the geometry and geography datatype. To summarise: Well-Known Text, the format from which spatial data is most commonly created in SQL Server, … Continue reading

Posted in Spatial, SQL Server | Tagged , , | 3 Comments