Overview
- Extensive coverage of automation using PowerShell and T-SQL
- Detailed discussion and examples on metadata-driven automation
- Comprehensive coverage of automated responses to break/fix scenarios
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (9 chapters)
Keywords
About this book
The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise.
Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market.- Extensive coverage of automation using PowerShell and T-SQL
- Detailed discussion and examples on metadata-driven automation
- Comprehensive coverage of automated responses to break/fix scenarios
What You Will Learn
- Automate the SQL Server build process
- Create intelligent, metadata-drive routines
- Automate common maintenance tasks
- Create automated responses to common break/fix scenarios
- Monitor multiple instance from a central location
- Utilize T-SQL and PowerShell for administrative purposes
Who This Book Is For
Expert Scripting and Automation for SQL Server DBAs is a book for SQL Server database administrators responsible for managing increasingly large numbers of databases across their business enterprise. The book is also useful for any database administrator looking to ease their workload through automation. The book addresses the needs of these audiences by showing how to get more done through less effort by implementing an intelligent, automated-processes service model using tools such as T-SQL, PowerShell, Server Agent, and the Management Data Warehouse.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Expert Scripting and Automation for SQL Server DBAs
Authors: Peter A. Carter
DOI: https://doi.org/10.1007/978-1-4842-1943-0
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: The Editor(s) (if applicable) and The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2016
Softcover ISBN: 978-1-4842-1942-3Published: 28 July 2016
eBook ISBN: 978-1-4842-1943-0Published: 27 July 2016
Edition Number: 1
Number of Pages: XVI, 284
Number of Illustrations: 5 b/w illustrations, 127 illustrations in colour
Topics: Database Management