Archive:
- October 2026 (5)
- September 2026 (5)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Concurrency (3) debian (4) docker (2) Execution Plans (6) Indexes (4) internals (11) linux (6) MongoDB (2) MR2 (2) Optimization (7) Performance (9) Performance Tuning (3) postgres (8) Powershell (3) Query Store (1) RCSI (2) sql (2) SQL Server (28) Statistics (2) Version Store (2)
Categories:
Docker (2) Linux (4) MongoDB (2) PostgreSQL (8) Powershell (2) SQL (1) SQL Server (28)
Month: September 2026
-
Optimizing Window Functions in Derived Datasets
In this post, we’ll look at some interesting behaviour I’ve stumbled across with window functions and derived datasets in SQL Server. I came across a query in a workload that was looking to get the most recent thing per group, a representative example in the Stack Overflow 2010 Database is below. The database is provided…
-
How Many MR2s still on the road – MongoDB Version
Last Updated: September 25, 2026 In my previous blog post, How Many Mk1 Toyota MR2s are still on the road, or currently being restored in the UK? we looked at how I used the UK’s MOT History API to download all the MOT data since 2005 and how I crudely filtered that down to just…
-
How Many Mk1 Toyota MR2s are still on the road, or currently being restored in the UK? – Answers in Data
Last Updated: September 14, 2026 In this blog post we look at a small project I was involved in to analyse publicly available UK MOT data to answer the above question (and more!) I am a huge fan of Toyota MR2 Mk1s and at the time of this project (early 2025), owned one myself. Being…
-
Filtered Indexes and Plan Parameterization
In this post, we’ll look at how filtered indexes in SQL Server work when the query is parameterised on the column of the filtered index. The query The following query in the Stack Overflow 2010 Database, provided under cc-by-sa 4.0 licence from Stack Exchange Data Dump, will find all users with the name John whose…
-
Installing MongoDB on Debian
In preparation for an upcoming project (stay tuned for more details), I needed to set up a MongoDB database server. In this post, we’ll walk through how to install and configure MongoDB on Debian 12. At the time of writing, Debian 13 is the most up to date stable version of Debian, though MongoDB is…