© 2016

Expert Scripting and Automation for SQL Server DBAs


Table of contents

  1. Front Matter
    Pages i-xvi
  2. Peter A. Carter
    Pages 1-22
  3. Peter A. Carter
    Pages 23-41
  4. Peter A. Carter
    Pages 43-75
  5. Peter A. Carter
    Pages 77-104
  6. Peter A. Carter
    Pages 105-156
  7. Peter A. Carter
    Pages 157-175
  8. Peter A. Carter
    Pages 177-204
  9. Peter A. Carter
    Pages 205-252
  10. Back Matter
    Pages 281-284

About this book


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.

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


PowerShell Server Agent Central Management Server Management Data Warehouse Patching T-SQL Monitoring

Authors and affiliations

  1. 1.BotleyUnited Kingdom

About the authors

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onwards. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Bibliographic information

Industry Sectors
Chemical Manufacturing
IT & Software
Consumer Packaged Goods
Materials & Steel
Finance, Business & Banking
Energy, Utilities & Environment