alastair_aitchison.jpg

Alastair Aitchison

Alastair Aitchison is an independent developer, trainer, author and consultant specialising in spatial data reporting and analysis. His work has been used by the House of Lords, the police, political parties and various media agencies.
http://alastaira.wordpress.com http://alastaira.wordpress.com/feed/

So you heard about the new spatial functionality in SQL Server 2008, rushed back to your database and added geography and geometry columns to all your tables, eager to create the next Google Earth-beating application. You then click the Execute button and wait. And wait. And wait some more. (You get the idea). Spatial data is a rather unique beast, and designing efficient spatial queries requires specific techniques when compared to other, more traditional types of data. In this session, we look at how the SQL Server database engine satisfies spatial queries, the theory behind spatial indexes, demonstrate the effects of altering the bounding box, use the spatial system DMVs and stored procedures to your spatial database
SQL Server spatial features have not yet made it into mainstream usage and many developers still ask "But *why* would I use them?". In this session, I hope to answer that question by replicating the functionality of Google Maps using only SQL Server.

Blog posts RSS

Guess Who Reloaded for the Rainbow Jam 2016 02 Sep 2016
I recently enrolled to take part in the Rainbow Jam but, with somewhat of a lack of foresight, failed to realise I was going to be on holiday in France for most of the jam period, without either a computer … Continue reading →

Bulk-renaming files 31 Jan 2016
I recently found myself needing to rename around 100 files. The reason was that I had saved a series of video fragments from the middle of a much larger streaming video – so the fragment number of each filename was … Continue reading →

Unity Shadertoys (a.k.a Converting GLSL shaders to Cg/HLSL) 07 Aug 2015
If you’ve tried dabbling with shaders at all, you’ve probably come across ShaderToy – an online shader showcase with some pretty amazing examples of what’s possible in a few lines of shader code, inspired greatly by classic demoscene coding. Here’s … Continue reading →

Multiple Mice Input in Unity 04 Aug 2015
I’m a big fan of local multiplayer – as far as I’m concerned, being bundled up with your mates cajoling each other and screaming at the TV is the very essence of gaming. I had an absolute blast at the … Continue reading →

Learnings from Unite 2015 27 Jun 2015
I spent the last three days having a lovely time in Amsterdam attending the Unite Europe 2015 conference. This is just a place for me to gather my notes/thoughts while they’re still in my head:   Iestyn Lloyd’s (@yezzer) Dropship … Continue reading →