Blog

Insights & optimisations

Technical articles about SQL Server performance, C#/.NET development, and building reliable systems in financial services.

Coming February 2026

I cut a bank's report from 15 minutes to under 2 minutes. Here's exactly how.

The full technical breakdown of optimising an SFTR reporting pipeline — 47 table scans, 12 correlated subqueries, and the indexed views that fixed everything.

SQL Server Performance SFTR
Coming February 2026

5 SQL Server default settings that are silently killing your performance

Your SQL Server has been misconfigured since the day it was installed. MAXDOP, cost threshold, memory settings — these defaults cost you real money.

SQL Server Configuration Quick Wins
Coming March 2026

Stop adding indexes every time a query is slow. Here's why it makes things worse.

The index-for-everything approach creates write overhead, confuses the query optimiser, and hides the real problems in your workload.

SQL Server Indexing Myths
Coming March 2026

Building SEC compliance reporting from scratch in 90 days

10,000 daily transactions, zero errors, T+1 deadlines. How I built a complete FINRA reporting system — architecture decisions, testing strategy, and lessons learned.

C# .NET SEC Architecture
Coming March 2026

Your developers can't read execution plans. That's costing you real money.

A 5-minute crash course on reading SQL Server execution plans — the single most valuable debugging skill for any backend developer.

SQL Server Tutorial Execution Plans
Coming April 2026

Regulatory reporting is the silent database killer

What compliance teams don't understand about performance — and what DBAs don't understand about regulatory deadlines. Bridging the gap.

SFTR MiFID II Performance
Stay Updated

New articles coming soon

Follow me on LinkedIn for weekly SQL Server tips and performance insights. Longer articles will appear here as they're published.

Follow on LinkedIn