Spatial Database Archives - SQL Authority with Pinal Dave

SQL SERVER – Validating Spatial Object as NULL using IsNULL

June 30, 2012

Spatial Database, SQL Function, SQL Spatial

Follow up questions are the most fun part of writing a blog post. Earlier I wrote about SQL SERVER – Validating Spatial Object with IsValidDetailed Function and today I received a follow up question on the same subject. The question was mainly about how NULL is handled by spatial functions. Well, NULL is…

SQL SERVER – Validating Spatial Object with IsValidDetailed Function

June 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Spatial Database, SQL Scripts, SQL Spatial

What do you prefer – error or warning indicating error may happen with the reason for the error. While writing the previous statement I remember the movie “Minory Report”. This blog post is not about minority report but I will still cover the concept in a single statement “Let us…

SQL SERVER – Finding Shortest Distance between Two Shapes using Spatial Data Classes – Ramsetu or Adam’s Bridge

March 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Spatial Database, SQL Function, SQL Spatial

Recently I was reading excellent blog post by Lenni Lobel on Spatial Database. He has written very interesting function ShortestLineTo in Spatial Data Classes. I really loved this new feature of the finding shortest distance between two shapes in SQL Server. Following is the example which is same as Lenni talk on…

SQLAuthority News – Speaking Online at Virtual Techdays – Aug 18, 2010 – Spatial Datatypes

August 17, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Spatial Database, SQLAuthority Author Visit

I am honored that I have been invited to speak at Virtual TechDays on Aug 18, 2010 by Microsoft. I will be speaking on my favorite subject of Spatial Datatypes. This exclusive Online event will have 30 deep technical sessions per day – and, attendance is completely FREE. There are…

SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success

August 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, Spatial Database, SQL Index, SQLAuthority Author Visit

I had great pleasure to attend very first SQL Data Camp at Chennai on July 17, 2010. This event was very unique as this was very first one-day SQL Event in whole Indian Subcontinent. The event was blast as there were so many back–to-back SQL Sessions with SQL Server MVPs.…

SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010

July 28, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

DBA, MVP, Spatial Database, SQL Joins, SQLAuthority Author Visit

Earlier this month, I got the opportunity to visit Malaysia for community sessions on June 29 – July 1, 2010 at Kuala Lumpur, Malaysia, which I would consider as valuable experience. I presented two different sessions at the event. The event was extremely popular in local community, and I had…

SQLAuthority News – The story of the world – Spatial Data types – July 24, 2010

July 24, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Spatial Database, SQL Server, SQLAuthority Author Visit

Today I will be speaking on the subject of Spatial Database at Community Tech Days at Ahmedabad. The event is absolutely FREE. We have so far received 500+ RSVP but there are only limited 250 seats are available. We are doing our best to inform everybody about their registration status. If you have received confirmation email, I suggest that you come in early enough to reserve the place.