Spatial Ed's blog

Information and news on spatial data support in Windows Azure SQL Database, SQL Server and environs...

Setting Up A Delayed Sending Rule For Email In Microsoft Outlook

Author: Ed Katibah, Microsoft SQLCATReviewer: Abdallah Fateen, Microsoft Introduction A few weeks...

Author: Spatial Ed Date: 12/17/2012

Updated Spatial Features in the SQL Azure Q4 2011 Service Release

The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL...

Author: Spatial Ed Date: 12/13/2011

Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September 2011 Service Release

In Microsoft SQL Server 2012 (previously known as SQL Server Code-Name “Denali”), all...

Author: Spatial Ed Date: 11/15/2011

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3

We have just released a new white paper, New Spatial Features in SQL Server Code-Named...

Author: Spatial Ed Date: 08/08/2011

Spatial Support Coming to the SQL Server Entity Framework

Some of you may not have heard that spatial support is coming in the next version of the SQL Server...

Author: Spatial Ed Date: 06/23/2011

Spatial Aggregates in SQL Server Denali

  SQL Server Code-named “Denali” is currently available as a Community Technology Preview...

Author: Spatial Ed Date: 04/27/2011

Spatial Support for Persisted Computed Columns In Denali CTP1

A few weeks ago, in the whitepaper, New Spatial Features in SQL Server Code-Named “Denali” Community...

Author: Spatial Ed Date: 01/25/2011

Database Compatibility Levels: Getting Existing Spatial Databases Ready For Denali

With the availability of the new SQL Server code-named “Denali” CTP1 release, some of you will be...

Author: Spatial Ed Date: 01/17/2011

New Functions Added To The SQL Server Spatial Tools CodePlex Project

Two new functions have been added to the SQL Server Spatial Tools CodePlex Project:...

Author: Spatial Ed Date: 12/30/2010

FME Webinar: Practical Techniques for Loading Data into SQL Server

One of the most often asked questions about SQL Server Spatial is “How do I load data into the...

Author: Spatial Ed Date: 12/09/2010

A Short Discussion On The ShortestLineTo() Method

In a recent post to the SQL Server Spatial Forum, the subject of finding the closest point from one...

Author: Spatial Ed Date: 11/19/2010

New Spatial Features in SQL Server Code-Named “Denali” CTP1

  We have just released a white paper, New Spatial Features in SQL Server Code-Named “Denali”...

Author: Spatial Ed Date: 11/09/2010

Loading ANSS Earthquake Data Into SQL Server 2008

The Advanced National Seismic System (ANSS) maintains a comprehensive catalog of worldwide seismic...

Author: Spatial Ed Date: 04/20/2010

Spatial Data Support Coming To SQL Azure

Last Wednesday (March 17th), Dave Robinson of the SQL Azure Team announced upcoming support for...

Author: Spatial Ed Date: 03/21/2010

Inside Microsoft SQL Server 2008: T-SQL Programming – Source Code and Spatial Data for Chapter 14

In the previous post, the content for Chapter 14, Spatial Data, was presented.  This post will...

Author: Spatial Ed Date: 12/22/2009

Inside Microsoft SQL Sever 2008: T-SQL Programming, Chapter 14, Spatial Data

In a shameless bit of self-promotion, I’d like to call attention to the new book, Inside Microsoft...

Author: Spatial Ed Date: 12/17/2009

My Overheating IBM ThinkPad T60p Laptop

My faithful old IBM T60p laptop has been with me for years.  Over time, and every so slowly, it...

Author: Spatial Ed Date: 11/13/2009

A Spatially-Enabled Dinner In Austin, Texas: Some Observations Outside the Office

Not having posted for a while, I thought I'd take a few minutes and provide some thoughts on spatial...

Author: Spatial Ed Date: 10/07/2009

Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 2

In a long past post, Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 1b...

Author: Spatial Ed Date: 06/06/2009

Update to the SQL Server Spatial Tools project on CodePlex

As Isaac noted in his most recent post, the SQL Server Spatial Tools project on CodePlex has been...

Author: Spatial Ed Date: 06/05/2009

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 5

The Report Builder, a component of Reporting Services, described in this post will be available as a...

Author: Spatial Ed Date: 05/18/2009

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 4

In the previous posts I indicated that this would be the last post in this series but it turned out...

Author: Spatial Ed Date: 05/18/2009

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 3

In the previous posts we have covered items 1,2 and 3 of the workflow.  In this post we address...

Author: Spatial Ed Date: 05/16/2009

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 1

I was recently presented with the problem of taking a US States dataset, in geographic coordinates,...

Author: Spatial Ed Date: 05/10/2009

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 2

In the previous post we covered items 1 and 2 of the workflow.  In this post, we will cover...

Author: Spatial Ed Date: 05/10/2009

Address Geocoding With SQL Server 2008 Spatial

In his new book, Beginning Spatial with SQL Server 2008, Alastair Aitchison describes how to create...

Author: Spatial Ed Date: 03/10/2009

Loading GeoNames Data Into SQL Server 2008 (the PowerShell, bcp way...)

In the first installment on this topic, I used a commercial text editor, EditPad Pro, to perform the...

Author: Spatial Ed Date: 01/20/2009

Loading GeoNames Data Into SQL Server 2008 (yet another way...)

In his post last year, Integrating Virtual Earth and GeoNames, Johannes described how to load the...

Author: Spatial Ed Date: 01/13/2009

Where is Ed?

After a rather lengthy hiatus, I'm back to blogging once again.  I was awakened from my reverie...

Author: Spatial Ed Date: 12/29/2008

Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 1b

"Fixing" Polygon Ring Orientation in SQL Server 2008 using T-SQL In the last installment,...

Author: Spatial Ed Date: 08/19/2008

GeoWeb 2008 Conference Dinner Cruise Photos (and SQL Server 2008 Spatial ;-)

On the Wednesday night GeoWeb 2008 dinner cruise around Vancouver harbor, several folks who had...

Author: Spatial Ed Date: 07/25/2008

WORKING WITH INVALID DATA AND THE SQL SERVER 2008 GEOGRAPHY DATA TYPE, PART 1

As many of you have already discovered, the Geography data type in SQL Server 2008 is very strict...

Author: Spatial Ed Date: 07/25/2008

GETTING YOUR PROGRAMS READY FOR THE UPCOMING GEOGRAPHY COORDINATE ORDER SWAP

For those of you who have programs which work with November CTP (CTP-5) and February CTP (CTP-6) and...

Author: Spatial Ed Date: 03/24/2008

TRAVELING WITH SQL SERVER 2008 SPATIAL

I travel quite a bit and have the need to carry a bit of equipment with me. This includes a laptop...

Author: Spatial Ed Date: 03/21/2008

CHANGING THE BLOG NAME...

By popular request (well, at least the request of Abe on Spatially Adjusted...), I've changed the...

Author: Spatial Ed Date: 03/05/2008

SQL SERVER SPATIAL BUGS...

As part of the Microsoft SQL Server 2008 February CTP Bug Bash Contest, we are looking for spatial...

Author: Spatial Ed Date: 03/05/2008

Introduction

Welcome to my first blog effort. Many of you in the spatial world may already know me. For everyone...

Author: Spatial Ed Date: 02/28/2008

NEW SPATIAL FEATURES IN The SQL SERVER 2008 FEBRUARY CTP

Now that the February CTP (CTP-6) for SQL Server 2008 is available, it's time to let folks know what...

Author: Spatial Ed Date: 02/28/2008