Learn dbatools in a Month of Lunches: Automating SQL Server Tasks With Powershell Commands - Couverture souple

LeMaire, Chrissy; Sewell, Rob; Pomfret, Jess; Silva, Cláudio

Couverture souple

ISBN 10 : 1617296708 ISBN 13 : 9781617296703

Editeur : Manning Publications, 2022

Synopsis

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.

A propos du livre

À propos de l'auteur

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 problemsolving aspects of performance tuning and automating processes with PowerShell.

À propos de la quatrième de couverture

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!

Détails de l'édition

• Éditeur: Manning Publications
• Date d'édition: 2022
• Langue: anglais
• ISBN 10: 1617296708
• ISBN 13: 9781617296703
• Reliure: Broché
• Numéro d'édition: 1
• Nombre de pages: 400
• Coordonnées du fabricant: Pearson Benelux BV; productsafety@pearson.com; ; Kabelweg 37; Amsterdam; 1014 BA; Pays-Bas