SQLBits 2024

Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights

This session focuses on how dbatools has revolutionized automation for Database Administrators (DBAs) in the SQL Server realm. It delves into the utilization of various dbatools cmdlets and practical applications. Participants will gain insights into performing migrations, setting up availability groups, data management within databases, and the backup and restoration of databases. These techniques are derived from real-world client scenarios encountered during the presenter's consulting practice.
dbatools changed the landscape of automation for DBAs, bringing automation to the SQL Server world. In this session, you will learn how to use some of my favorite dbatools cmdlets and use cases. We'll look at how to perform migrations, build availability groups, manage data in databases, and backup and restore databases. The techniques you will learn in this session is based on experiences from real-world customer scenarios from my consulting practice.

Learning Objectives
Instance and database migrations
Building and configuring SQL Server instances
Advanced data management in databases
Backing up and restoring databases