Automating SQL Server with dbatools
1hIntermediate2022-11-03
Authors

Jess Pomfret
Database Platform Architect and Microsoft MVP
Course details
If you want to learn more about automating SQL Server, you’ve come to the right place. Did you know you can use the open-source PowerShell module dbatools to manage your SQL Server estate? In this course, instructor Jess Pomfret covers the skills you need to know to automate SQL Server with dbatools, helping you optimize your workflow, database performance, and overall server management experience.
Learn about the history of dbatools and why it should become one your trusted go-to tools, as Jess shows you how dbatools can accomplish most of the tasks available in SQL Server Management Studio. Find out how to handle multiple instances, databases, and logins at the same time, as well as gather and set information, change configurations, and migrate instances. Upon completing this course, you’ll be prepared to keep building on your new skills so you can become a more effective and efficient database administrator.
Learn about the history of dbatools and why it should become one your trusted go-to tools, as Jess shows you how dbatools can accomplish most of the tasks available in SQL Server Management Studio. Find out how to handle multiple instances, databases, and logins at the same time, as well as gather and set information, change configurations, and migrate instances. Upon completing this course, you’ll be prepared to keep building on your new skills so you can become a more effective and efficient database administrator.
Skills covered
SQL ServerDatabase AdministrationDatabase ManagementMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Why dbatools
- 02 - What you should know
- 03 - Setting up your environment
1. What Is dbatools
- 04 - Introducing dbatools
- 05 - Installing and updating the module
- 06 - Find the command you need
- 07 - Running your first command
2. Get Information
- 08 - Get a list of SQL Servers in your environment
- 09 - Get database status across your estate
- 10 - Check database last backup times
- 11 - Get SQL Server patch levels
- 12 - Review SQL Server Configuration Settings
- 13 - Find failed SQL Agent jobs
3. Set Information
- 14 - Set databases online or offline
- 15 - Discover and apply recommended data compression levels
- 16 - Update database compatibility levels
- 17 - Insert data into SQL Server tables
4. Migrations Made Easy with dbatools
- 18 - Migrate whole instances with one line of code
- 19 - Simple database migrations
- 20 - More advanced database migrations
- 21 - Migrating logins
- 22 - Exporting documentation
Conclusion
- 23 - Continue your learning