Louis Tochon

SQL Server vs MongoDB: When the cloud is your adversary (Always Encrypted vs Queryable Encryption)

When the cloud admin is the threat: how SQL Server and MongoDB let you query encrypted data, and what each approach costs.

Split, Sort, Collapse: how SQL Server survives an overlapping unique update

How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.

When an idle transaction starves the worker pool (THREADPOOL)

How a forgotten transaction exhausted SQL Server's worker pool, triggered THREADPOOL waits, and only DAC could fix it.

Measuring the real performance cost of SQL Server XE buffers

Are Extended Events always lightweight? See how a bad config converts event loss into query latency through DMVs.

How Row Goal shapes your SQL Server query strategy by hunting for pierogis

Mastering SQL Server Row Goals and how TOP, EXISTS, and FAST N influence execution plans and how to avoid performance traps in your queries(…)

SQL Server 2025 In-Memory: New Cleanup Features & SQLBits 2026 Insights

SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.

Beyond TDE and TLS: Bridging the Data Security Governance Gap in Lower Environments

Why one layer is never enough, why dev environments are your biggest GDPR gap, and how to industrialize their governance.

Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025

Migrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.

SQL Server 2022 CU23: Database Mail is broken, but your alerts shouldn’t be

SQL Server 2022 CU23 bug freezes your emails? Bypass Database Mail using dbatools and PowerShell to resend blocked alerts.

Scaling Data Governance: Why ABAC is My Favorite Delphix DCT Feature

ABAC in Delphix Data Control Tower automates governance via tags, providing granular control and full autonomy for developers.