Bart Vernaillen

BV is a SQL Server performance specialist with a focus on automation. He created the D-BART method: Detect, Blueprint, Automate, Report, Thrive; a practical approach that helps DBA-teams standardize and scale operations without scaling effort. He’s the author of PlanInspector and WorkloadInspector, tools for smarter query plan analysis, and regularly shares hands-on insights through talks, tools, or blog posts.

Bart Vernaillen's Sessions

Use powershell to analyze a bunch of query plans.SQLBits 2025

In SQL Server, we can capture query plans using Extended Events—but then what? Analyzing a single query plan can be a complex task, but what if you have hundreds or even thousands of them? To simplify this, I wrote PowerShell code that parses the query plan XML and stores the extracted data in a database. This approach makes it much easier to identify performance issues and gain insights in a large set of query plans.

Analyse workload-level index usage with PowerShell and Query StoreSQLBits 2026

Introducing WorkloadInspector, an open-source PowerShell tool that analyses Query Store execution plans to understand index and index column usage across a workload and produce a reviewable, database-specific index change script.

Streamlining SQL Server management in larger environments.SQLBits 2026

Managing a few databases is easy; managing many is not. Standardisation and automation reduce operational risk, improve efficiency, and allow DBA teams to focus on high-value work. This session presents a structured, scalable approach.

Use powershell to analyze a bunch of query plans.SQLBits 2025

In SQL Server, we can capture query plans using Extended Events—but then what? Analyzing a single query plan can be a complex task, but what if you have hundreds or even thousands of them? To simplify this, I wrote PowerShell code that parses the query plan XML and stores the extracted data in a database. This approach makes it much easier to identify performance issues and gain insights in a large set of query plans.