SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections

In business we often hear the phrase, “We had a good quarter.” Immediately, we know this means a three month span where sales and profits have been aggregated together for the company. Take a company like Costco that might have $65 billion in total sales during the 4th Quarter (October, November and December). Of course, this total comes not from a single sale of a 65 billon dollar yacht, rather from millions of sales of common items like snacks, drinks, clothes, and light bulbs. We know how to use GROUP BY and SUM to calculate totals and combine similar data. In the case of Costco we group by calendar quarter and then sums on the sales. Although aggregates are commonly used with numbers, they can also be used with spatial land coordinates to assemble them together, much like a jigsaw puzzle. Let us learn about Spatial Unions.

Read More

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

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…
Read More

SQL SERVER – SSRS 2008 R2 – MapGallery – World Map

SQL Server 2008 R2 has negatively integrated ability to work with maps. There are few ways how one can select map and use them in their projects. The one I recently came across was MapGallery. By default SQL Server 2008 R2 is enabled for USA maps. This is quite a common request from developers around the globe that they want the same feature available in their own country.

Read More

SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010

Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… you…
Read More

SQLAuthority News – Delivering Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

SQL Server Community is very strong community world-wide. In India SQL is considered as one of the most popular technology. Chennai is the only city in India where there are more than 3 SQL Server MVPs are from. My MVP friends has arranged one of the very first whole day…
Read More
Menu