Analytics in Action

Archive for January, 2013

Introduction to Spatial Queries in SQL SERVER 2012

The amount  of spatial data  captured in databases is increasing exponentially. This includes data from mobile phones, GPS units through to home detention bracelets used for home arrests. Typically these devices capture information such as latitudes and longitudes.  The spatial capabilities  of...

Introduction to Stored Procedures in SQL Server

A Stored Procedure is a SQL statement stored in a SQL Server database. They can be triggered with a short "EXECUTE" statement. Common functions of stored procedures include retrieving, modifying and deleting data. They are typically designed to accept one...