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

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