Chrissy LeMaire - Learn dbatools in a Month of Lunches: Automating SQL server tasks with PowerShell commands

Benefits of automated SQL Server installs

Automating SQL server tasks with PowerShell commands

Chrissy LeMaire, Rob Sewell, Jess Pomfret, and Cludio Silva

Foreword by Anna Hoffman

To comment go to liveBook

Manning

Shelter Island

For more information on this and other Manning titles go to

www.manning.com

For online information and ordering of these and other Manning books, please visit www.manning.com. The publisher offers discounts on these books when ordered in quantity.

For more information, please contact

Special Sales Department

Manning Publications Co.

20 Baldwin Road

PO Box 761

Shelter Island, NY 11964

Email: orders@manning.com

2022 by Manning Publications Co. All rights reserved.

No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by means electronic, mechanical, photocopying, or otherwise, without prior written permission of the publisher.

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in the book, and Manning Publications was aware of a trademark claim, the designations have been printed in initial caps or all caps.

Recognizing the importance of preserving what has been written, it is Mannings policy to have the books we publish printed on acid-free paper, and we exert our best efforts to that end. Recognizing also our responsibility to conserve the resources of our planet, Manning books are printed on paper that is at least 15 percent recycled and processed without the use of elemental chlorine.

ISBN: 9781617296703

We dedicate this book to our loving and supportive wives.

There are over 20 million active installs of Microsoft SQL Server, with continued growth month after month. The SQL Server/Azure Data Community also continues to grow, currently with over 77,000 members across more than 40 countries. The authors Chrissy LeMaire, Rob Sewell, Jess Pomfret, and Cludio Silva have spent many years being very active in this communityteaching, sharing, and empowering. They have been part of the charge that turned a technology into a community.

A couple of years ago, one of the authors and the creator of dbatools, Chrissy LeMaire, came on my show, Data Exposed, to show data professionals how to automate disaster recovery in SQL Server with dbatools. I was immediately struck by Chrissys charisma and ability to take complex topics and make them simple. She also made it clear that dbatools was built by and for the community and is free: Instance migrations and best practice implementations have never been safer, faster, or freer. dbatools enables data professionals to automate SQL Server tasks with PowerShell. Not only that, but dbatools also has a rich ecosystem of contributors, tests, and resources to make sure you can learn, report bugs, and contribute.

dbatools is something that all SQL Server professionals should consider learning, and this book is the perfect way to learn, with its combination of knowledge transfer, anecdotes, and hands-on labs. Microsoft is so confident in dbatools value that it has sponsored the project through Microsofts Free and Open Source Software Fund. dbatools empowers you to leverage automation, so you can stop doing repetitive tasks and sleep easily knowing you have the best practices implemented. In the process of learning dbatools, youll also become comfortable with PowerShell, which will help you more generally as a technical professional whether youre looking to work across databases, data engineering, and applications, or across operating systems, or even across on-premises and public cloud providers, like Microsoft Azure, which is covered in a later chapter.