Displaying information on an interactive map really isn’t that hard to do. My friends John & Bronwen have been doing this stuff for ages through their company Soul Solutions, and have done lots of talks about how to do this. They have the ability to take that stuff far beyond what I can, but as it’s a significant aspect of data visualisation, ...

Regular readers of my blog (at sqlblog.com – please let me know if you’re reading this elsewhere) may be aware that I’ve been doing more and more with spatial data recently. With the now-available SQL Server 2008 R2 Reporting Services including maps, it’s a topic that interests many people. Interestingly though, although many people have plenty ...

I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of said data. Given that it’s about one the larger types, this post should also count towards Michael Coles’ T-SQL Tuesday on BLOB data. I wrote recently about my experience with exploded data, but what I ...

The script below generates the geekiest Christmas card in the world.  To see it, follow these instructions: (1) Copy and paste the script below into SQL Server Management Studio 2008(2) Execute the script(3) Look at the ''Spatial Results'' tab in SSMS Merry Christmas! -- Begin copy here SELECT ...

The NJSQL user group is hosting a one-day Saturday SQL Server event at the Microsoft Iselin offices.  On October 24th Jacob Sebastian, Robert Pearl and I will be presenting on the following SQL Server topics: * T-SQL Defensive coding and exception handling best practices* Database forensics in SQL Server (''Who did it and ran?'')* SQL Server ...