Monthly Archives: August 2011

SQL Azure – Keeping up with a Moving Target

Moving your data to the (public) cloud necessarily involves relinquishing some control over the setup and maintenance of the environment in which your data is hosted. Cloud-based hosting services such as Microsoft Azure are effectively just scalable shared hosting providers. … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

NoSQL, NoGIS… What’s with all the Negativity?

Databases are dull. So is geography. As a result, professionals in these fields have a habit of desperately trying to make themselves sound more interesting by inventing exciting memes – something that they can turn into a twitter #hashtag or … Continue reading

Posted in Spatial, SQL Server | Tagged , , , | 2 Comments

Spatial Applications in Windows Azure Redux (including Denali)

Several other people have already written on the subject of writing an Azure application that makes use of the SQL Server spatial datatypes. See, for example, Johannes Kebeck’s or Rex Hansen’s articles. However, having tried to answer a question on … Continue reading

Posted in Spatial, SQL Server | Tagged , , , | 11 Comments

Spatio-temporal Event Processing with StreamInsight, SQL Server Denali, and Bing Maps – Part 5

Yesterday, fellow Bing Maps MVP Nicolas Boonaert (blog) kindly tweeted a link to my series of posts about analysing spatio-temporal data using StreamInsight and Bing Maps. In addition to the generous words he said publicly, he also sent me a … Continue reading

Posted in Bing Maps, Spatial, SQL Server | Tagged , , , | 3 Comments

Spatio-temporal Event Processing with StreamInsight, SQL Server Denali, and Bing Maps – Part 4

Over the last few posts, I’ve been trying to use SQL Server StreamInsight to analyse a set of data recording outbreaks of  H5N1 avian flu. The data set is spatio-temporal – it contains both the location of each outbreak and … Continue reading

Posted in Bing Maps, Spatial, SQL Server | Tagged , , | 2 Comments

Spatio-temporal Event Processing with StreamInsight, SQL Server Denali, and Bing Maps – Part 3

At the end of my last post, I’d managed to stream some data representing cases of the H5N1 virus from a KML file into the StreamInsight engine, and streamed the results out again to a console window. Not particularly exciting, … Continue reading

Posted in Spatial, SQL Server | Tagged , | Leave a comment

Spatio-temporal Event Processing with StreamInsight, SQL Server Denali, and Bing Maps – Part 2

In my last post, I outlined a plan for conducting temporal analysis of a set of spatial data by streaming it through StreamInsight. Following this plan in something like a logical order, the first step is to obtain some source … Continue reading

Posted in Spatial, SQL Server | Tagged , , | Leave a comment