My latest Article is up on sql-server-performance. It comes from watching one of the cool videos on TED where the presenter remodelled the World’s landmass based on the number of minutes US news spent on stories from that country – it was quite dramatic.
In the article I explore using SQL 2008 Spatial to do something similar with CO2 emissions. I run through the data process, some simple cleanup and the Reduce() method. I then use the STBuffer() to increase or decrease the area of a Geography, starting with just circles and then ending with modifying the countries themselves.
The Article is in two parts:
http://www.sql-server-performance.com/articles/dev/Powerful_Geographical_Visualisations_SQL_2008_Spatial_Part1_p1.aspx
http://www.sql-server-performance.com/articles/dev/Powerful_Geographical_Visualisations_SQL_2008_Spatial_Part2_p1.aspx
Let me know what you think.