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 […]
2026-06-12
4,776 reads
Ever just need a quick visualization of some numbers to get a rough idea of the trend, like this
2026-04-15
2026-04-10
849 reads
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 […]
2026-03-16
2,289 reads
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.
2026-02-09
1,829 reads
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.
2025-03-04 (first published: 2025-03-03)
2,829 reads
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
5,466 reads
2020-04-14
587 reads
2017-05-01
915 reads
2017-03-31
971 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Training the next generation
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers