Expert Scripting and Automation for SQL Server DBAs

• Κύριος συγγραφέας: Carter, Peter A. (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Θέματα: Computer science.; Database management.; Computer Science.; Database Management.

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

Πίνακας περιεχομένων:

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