22-25 April 2026

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 .

Cláudio Silva's Sessions

X-Raying Schema Operations: Adding and Removing ColumnsSQLBits 2025

Do you need to handle schema changes? Maybe create a new column on a busy table? Maybe drop a column to recover space. Do you know the pitfalls and what you should take into account? It's easy to halt a system when we aren't doing things in the best way. Come and learn important details that will allow you to plan these actions, in the best way possible, before running your scripts!

Writing T-SQL code for the engine, not for youSQLBits 2024

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!

Let me show you why data types still matterSQLBits 2024

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 demandSQLBits 2024

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 strategySQLBits 2023

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 editionSQLBits 2023

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 clicksSQLBits 2018

Automate SSRS management using Microsoft's PowerShell module

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

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_QuickieStoreSQLBits 2026

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 FortuneSQLBits 2026

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!

X-Raying Schema Operations: Adding and Removing ColumnsSQLBits 2025

Do you need to handle schema changes? Maybe create a new column on a busy table? Maybe drop a column to recover space. Do you know the pitfalls and what you should take into account? It's easy to halt a system when we aren't doing things in the best way. Come and learn important details that will allow you to plan these actions, in the best way possible, before running your scripts!

Writing T-SQL code for the engine, not for youSQLBits 2024

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!

Let me show you why data types still matterSQLBits 2024

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 demandSQLBits 2024

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!