dbatools - Wheel of Fortune
Proposed session for SQLBits 2026TL; DR
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!
Session Details
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!
Spin the wheel and let luck be with you!
There are so many things we want to show you with dbatools that we couldn't decide - so now you decide!
Demos could include:
- Managing Availability Groups
- Migrating databases
- Refreshing test environments
- Masking sensitive data
- Checking we're meeting best practices
- Managing Logins, Users & Permissions
- Using Database Snapshots for Application Upgrades
- Document your entire SQL environment
- Backups and Restores
- Copy table data around
- Deploy tools including WhoIsActive & Ola maintenance scripts
- Patching SQL Servers
- Finding objects
- and others - who knows where the wheel may take us
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!
Spin the wheel and let luck be with you!
There are so many things we want to show you with dbatools that we couldn't decide - so now you decide!
Demos could include:
- Managing Availability Groups
- Migrating databases
- Refreshing test environments
- Masking sensitive data
- Checking we're meeting best practices
- Managing Logins, Users & Permissions
- Using Database Snapshots for Application Upgrades
- Document your entire SQL environment
- Backups and Restores
- Copy table data around
- Deploy tools including WhoIsActive & Ola maintenance scripts
- Patching SQL Servers
- Finding objects
- and others - who knows where the wheel may take us
3 things you'll get out of this session
- how to automate database administration tasks
- real examples for using dbatools
- depends on how the wheel falls
Speakers
Cláudio Silva's other proposed sessions for 2026
Performance of a T-SQL query - The mystery, the investigation and the root cause! - 2026
Accelerating Query Store data analysis with sp_QuickieStore - 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!
Jess Pomfret
jesspomfret.com
Jess Pomfret's other proposed sessions for 2026
Automating SQL Server Management with GitHub Actions and PowerShell - 2026
Data API Builder – Create an API for Your Database in Seconds - 2026
Jess Pomfret's previous sessions
Managing replication with dbatools
One of the most highly requested dbatools features was for commands to manage replication and now they're here.
In this session, we'll run through the available commands and how they can be used to build up and tear down replication.
Anyone can be an alphabet soup ally
Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally.
There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship.
This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.