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.
Louis Tochon
Louis Tochon specializes in SQL Server and Oracle database administration, with expertise in performance optimization, scripting, backup/restore, and high availability (Always-On). He is Microsoft Certified Azure Database Administrator Associate. He completed a master's thesis in cybersecurity at SICPA and worked as a SQL Server and Oracle DBA for almost two years at Lombard-Odier. Louis holds a Master's degree in Information Systems from HEC Lausanne. His industry experience covers mainly the banking sector.
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.
SQL Server Always-On: Centralizing Backup History Across Replicas
Replace brittle T-SQL links and manual checks with a central PowerShell orchestrator to reliably manage Always On backup data at scale.
Data Anonymization as a Service with Delphix Continuous Compliance
Context In the era of digital transformation, attack surfaces are constantly evolving and cyberattack techniques are becoming increasingly sophisticated. Maintaining the confidentiality, integrity, and availability of data is therefore a critical challenge for organizations, both from an operational and a regulatory standpoint (GDPR, ISO 27001, NIST). Therefore, data anonymization is crucial today. Contrary to a widely held belief, the risk…
The truth about nested transactions in SQL Server
Nested transactions in SQL Server don’t provide real isolation; @@TRANCOUNT rises, but only the main transaction controls locks.
Understanding XML performance pitfalls in SQL Server
A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.