dbatools' recipes for Data Professionals
2022TL; DR
Come and get some ideas from how I have automate some of our DBA's boring tasks.
Session Details
As data professionals, in most of the scenarios that we need to accomplish a task, we can click around dozens of times, run different scripts, move results around, go back and forth and we will end repeating everything every single time.
We all know that will never be to run "just once", so being able to re-use processes is a must-have!
This will be a session full of demos where I will share different recipes (scripts) that I use to fulfil common needs.
Whether it is to replicate permissions, refresh databases (within or not availability groups), export configs and versioning them with GIT, among others, dbatools PowerShell module is my way to go!
We will also see how we can add some other commands from different modules to improve our final results!
3 things you'll get out of this session
Speakers
Cláudio Silva's other proposed sessions for 2026
Accelerating Query Store data analysis with sp_QuickieStore - 2026
dbatools - Wheel of Fortune - 2026
Performance of a T-SQL query - The mystery, the investigation and the root cause! - 2026
Cláudio Silva's 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