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.
Auflage
Sprache
Verlagsort
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
127
5 s/w Abbildungen, 127 farbige Abbildungen
XVI, 284 p. 132 illus., 127 illus. in color.
Maße
Höhe: 25.4 cm
Breite: 17.8 cm
Gewicht
ISBN-13
978-1-4842-1942-3 (9781484219423)
DOI
10.1007/978-1-4842-1943-0
Schweitzer Klassifikation
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.
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.