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...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Autor Corporativo: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress : Imprint: Apress,
2016.
|
Edición: | 1st ed. 2016. |
Temas: | |
Acceso en línea: | Texto Completo |
Tabla de Contenidos:
- 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. .