
Archive:
- October 2026 (4)
- 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) RCSI (2) sql (2) SQL Server (27) SQL Server Agent (1) Statistics (2) Version Store (2)
Categories:
Docker (2) Linux (4) MongoDB (2) PostgreSQL (8) Powershell (2) SQL (1) SQL Server (27)
Category: 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 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…