SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry

Taking SQL art from shamrocks and Easter eggs to something your DBA manager might actually care about. If you've been following my SQL spatial art series — shamrocks, Easter eggs, Christmas trees — you'll know I have a habit of finding increasingly creative misuses for SQL Server's geometry data type. Most of them have been […]

How to Draw Line Graphs in SSMS

Ever just need a quick visualization of some numbers to get a rough idea of the trend, like this

SQL Art, Part 3: Happy Easter Fun in SSMS

More spatial fun, this time for Easter.

SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)

Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]

GPX distance and time analysis in SQL Server

In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.

Comparing Two Geospatial Series with Python

Learn how to use Python and pandas to compare two series of geospatial data and find the matches.

The Linestring

Spatial Data Type

It Just Runs Faster - Spatial