Cláudio Silva

I work as a Data Platform Architect. I love performance tuning and I'm also a PowerShell lover who automates any process that needs to be done more than a couple of times. I'm a Microsoft Data Platform MVP and an active SQL Server and PowerShell community member. Also, I'm a contributor to open-source projects such as dbatools (https://dbatools.io) and dbachecks (https://dbachecks.io). I blog at https://claudioessilva.eu .

Proposed Sessions for 2026

Performance of a T-SQL query - The mystery, the investigation and the root cause!

A query that was 3 times slower on an identical system! But why?! Weren't the statistics, nor the execution plan shape. I will share what I have checked. Tools, methods to compare results and finally the root cause of it! Even better, I will give you a way to remember to check it next time!

Accelerating Query Store data analysis with sp_QuickieStore

Learn how to troubleshoot performance issues faster using Query Store and the free sp_QuickieStore procedure, with practical demos you can apply immediately.

dbatools - Wheel of Fortune

Ad voice: Want to play Wheel of Fortune dbatools style? Come and join us on a demo-driven session where you will be the player and we gift you with some next-level demos using dbatools!

Previous Sessions

Let me show you why data types still matter

Selecting the right data types is still important. Let's see some examples of why!

Writing T-SQL code for the engine, not for you "more demos" by popular demand

Often because of how quickly we want to write a T-SQL query we create more extra work for the engine. People underestimate the power of rewriting a T-SQL query, but in the right cases, it will provide better performance. Let's look at some scenarios where this is true!

Hear me out - Don't go offline because of your index deployment strategy

Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.

Lift and Shift with dbatools - Azure SQL Managed Instance edition

Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.

Administrating SSRS without boring web based clicks

Automate SSRS management using Microsoft's PowerShell module