Automating SQL Server with dbatools

Automating SQL Server with dbatools

1hIntermediate2022-11-03

Authors

Jess Pomfret

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.

Skills covered

SQL ServerDatabase AdministrationDatabase ManagementMicrosoftDeep Dive (X:Y)

Concepts

Introduction

  • Why dbatools
  • What you should know
  • Setting up your environment

What Is dbatools

  • Introducing dbatools
  • Installing and updating the module
  • Find the command you need
  • Running your first command

Get Information

  • Get a list of SQL Servers in your environment
  • Get database status across your estate
  • Check database last backup times
  • Get SQL Server patch levels
  • Review SQL Server Configuration Settings
  • Find failed SQL Agent jobs

Set Information

  • Set databases online or offline
  • Discover and apply recommended data compression levels
  • Update database compatibility levels
  • Insert data into SQL Server tables

Migrations Made Easy with dbatools

  • Migrate whole instances with one line of code
  • Simple database migrations
  • More advanced database migrations
  • Migrating logins
  • Exporting documentation

Conclusion

  • Continue your learning
40,000 Toman