(Ebook) Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter (auth.) ISBN 9781484219423, 9781484219430, 1484219422, 1484219430

(Ebook) Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter (auth.) ISBN 9781484219423, 9781484219430, 1484219422, 1484219430

Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse.

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.

• 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 audien
*Free conversion of into popular formats such as PDF, DOCX, DOC, AZW, EPUB, and MOBI after payment.