Expert Scripting and Automation for SQL Server DBAs
Buch in deiner Nähe kaufen
Beschreibung
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
There is a trend in the market toward asking database administrators to manage increasingly large numbers of databases. This trend is accelerated by the adoption of cloud and hybrid-cloud databases in which portions of an application's data are held in the cloud, and portions are held locally. Further accelerating the trend is the typical scenario in which individual enterprise applications each run on their own database instances, all of which must be managed. Database administrators are being called upon to keep with a burgeoning number of instances, and automation is the key. This book provides those administrators with much-needed and valuable help in automating their work and manage more databases than ever before, and easier than ever before.
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
Autor*in
Peter A. Carter
Themen in »Expert Scripting and Automation for SQL Server DBAs«
PowerShell Server Agent Central Management Server Management Data Warehouse Patching T-SQL Monitoring