Archive:
- November 2026 (4)
- October 2026 (6)
- 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 (7) Indexes (4) internals (12) linux (7) MongoDB (2) MR2 (2) Optimization (7) Performance (9) Performance Tuning (3) postgres (8) Powershell (3) RCSI (2) sql (2) SQL Server (30) Statistics (2) Version Store (2) windows server (3)
Categories:
Docker (2) Linux (5) MongoDB (2) PostgreSQL (8) Powershell (2) SQL (1) SQL Server (31) Windows Server (3)
Tag: Powershell
-
Using Files in UNC Paths with PowerShell in SQL Server Agent
In this post, we’ll look at how PowerShell job steps may have issues connecting to network locations from within SQL Server Agent job steps. Timeless Backup Job When working with SQL Server backups, I bet we’ve all seen agent jobs that look like this: It’s a classic backup job – run the backup using T-SQL…
-
How Many MR2s still on the road – MongoDB Version
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 Toyota Mk1 MR2s and performed…
-
How Many Mk1 Toyota MR2s are still on the road, or currently being restored in the UK? – Answers in Data
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 a fairly active member of…