/dev/reading

Learn dbatools in a Month of Lunches

Automating SQL server tasks with PowerShell commands
by Chrissy LeMaire, Rob Sewell, Jess Pomfret and Cláudio Silva
The cover of Learn dbatools in a Month of Lunches
4.67/5 on Goodreads
ISBN 9781617296703
Published in 2022
400 pages

Description

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month!

In Learn dbatools in a Month of Lunches you will learn how to:

  • Perform instance-to-instance and customized migrations
  • Automate security audits, tempdb configuration, alerting, and reporting
  • Schedule and monitor PowerShell tasks in SQL Server Agent
  • Bulk-import any type of data into SQL Server
  • Install dbatools in secure environments

Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool.