Bart Vernaillen

I'm an experienced MSSQL DBA with a strong passion for automation through PowerShell, problem-solving, and simplifying complex processes. I thrive on finding efficient solutions and streamlining operations, constantly looking for ways to enhance performance and reduce manual effort. My motto is: "Do it right the first time, and save time later."

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.