click to
look inside
Look inside
Manning Early Access Program (MEAP) Read chapters as they are written, get the finished eBook as soon as it’s ready, and receive the pBook long before it's in bookstores.
You can see any available part of this book for free.
Click the table of contents to start reading.

Learn dbatools in a Month of Lunches you own this product

Automating SQL server tasks with PowerShell commands
Chrissy LeMaire, Rob Sewell, Jess Pomfret, Cláudio Silva
  • MEAP began August 2019
  • Publication in July 2022 (estimated)
  • ISBN 9781617296703
  • 400 pages (estimated)
  • printed in black & white
filed under

placing your order...

Don't refresh or navigate away from the page.
eBook Our eBooks come in DRM-free Kindle, ePub, and PDF formats + liveBook, our enhanced eBook format accessible from any web browser. $33.59 $47.99 you save $14 (30%)
Learn dbatools in a Month of Lunches (eBook) added to cart
continue shopping
go to cart

print book Receive a print copy shipped to your door + the eBook in Kindle, ePub, & PDF formats + liveBook, our enhanced eBook format accessible from any web browser. $41.99 $59.99 you save $18 (30%)
FREE domestic shipping on orders of three or more print books
Learn dbatools in a Month of Lunches (print book + eBook) added to cart
continue shopping
go to cart

This is an excellent resource to use for advancing your skills with advanced administration for SQL servers, regardless of the number of servers you are administering.

Joseph Houghes
Look inside
An effective DBA is an efficient DBA. And if you work with SQL Server, dbatools is a lifesaver. With over 500 commands, this free and open source PowerShell module has the horsepower to automate just about every task you can imagine—and then some! 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.

about the technology

Want to automate tasks for thousands of SQL servers at once? Want to migrate an entire SQL server using just the command line? dbatools can do all that—and more. A free and open source PowerShell module, dbatools offers over 500 commands for automating SQL Server from the command line. Boasting advanced options unavailable in official tools, dbatools makes it easy to automate tasks including mass exports for simplified disaster recovery, tempdb configuration, and improving an instance’s security posture.

about the book

Learn dbatools in a Month of Lunches is a practical hands-on guide to automating SQL Server with PowerShell and the awesome dbatools module. You’ll master techniques you can immediately put into practice, from daily duties like backups and restores right through to performing security audits. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. Each lesson delivers another skill that you can use to speed through your core tasks as a SQL Server DBA!

what's inside

  • Installing dbatools in secure environments
  • Bulk-import any type of data into SQL Server
  • Instance-to-instance and customized migrations
  • Schedule and monitor PowerShell tasks in SQL Server Agent

about the reader

For database administrators familiar with SQL Server and PowerShell.

about the author

Chrissy LeMaire is a dual Microsoft MVP, awarded for her work with both SQL Server and PowerShell. She is an international speaker and the creator of the popular PowerShell module, dbatools. She has over 20 years of IT experience and currently works for General Dynamics Information Technology at NATO Special Ops HQ in Belgium.

Rob Sewell is a passionate automator who has been recognized as an MVP by Microsoft. He is a keen community contributor as an event organizer, speaker and open-source contributor.

Cláudio Silva is a database professional, automator, and contributor of the open-source PowerShell module dbatools.

Jess Pomfret is a SQL Server Database Engineer and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell.

FREE domestic shipping on orders of three or more print books

A great book that holds your hand on the journey from a beginner who has never used dbatools all the way to an expert!

Paul Broadwith

If you have not heard of dbatools, prepare to make managing your SQL Server infrastructure easier with the combination of it and PowerShell!

Wayne Mather

One of, if not THE best, technical books I have read, this book brings joy and life to automating DBA tasks through PowerShell, so much fun.

Ben McNamara

This book and dbatools are a very serious game changer for doing automation, get out of the dark ages and look at these tools!

Steve Atchue

This book is a must for a busy SQL Server database professional.

Arthur Zubarev