DownloadThe Portobello Bookshop Gift Guide 2024

Learn dbatools in a Month of Lunches

Rob Sewell author Chrissy LeMaire author Jess Pomfret author Cláudio Silva author

Format:Paperback

Publisher:Manning Publications

Published:7th Jul '22

Should be back in stock very soon

Learn dbatools in a Month of Lunches cover

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! Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible.

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!

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.

"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


"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

ISBN: 9781617296703

Dimensions: 235mm x 186mm x 24mm

Weight: 713g

400 pages