Tag Archives: Denali

SQL Server 2012 – What’s New for Spatial?

Posted on March 7, 2012 by alastaira

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

Posted on September 11, 2011 by alastaira

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

Posted on July 29, 2011 by alastaira

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

Posted on July 26, 2011 by alastaira

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