Expert Scripting and Automation for SQL Server DBAs

Expert Scripting and Automation for SQL Server DBAs

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 inve...

Full description

Bibliographic Details
Main Author: Carter, Peter A. (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2016.
Subjects:
Computer science.
Database management.
Computer Science.
Database Management.
Online Access:Full Text via HEAL-Link
Table of Contents:
  • Introduction
  • 1. T-SQL Technique for DBAs
  • 2. PowerShell Fundamentals
  • 3. SQL Server Agent Multi-server Environments
  • 4. Metadata Driven Automation.-5. Automation Techniques with SSIS
  • 6. Building an Inventory Database
  • 7. Automating Instance Builds
  • 8. Driving Automation through Monitoring
  • 9. Automating Routine Maintenance and Break/Fix Scenarios. .

Similar Items