
Expert Scripting and Automation for SQL Server DBAs
Peter A. Carter(Author)
Apress
Published on 28. July 2016
Book
Paperback/Softback
XVI, 284 pages
978-1-4842-1942-3 (ISBN)
Article exhausted; check for reprint
Description
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.
More details
Edition
First Edition
Language
English
Place of publication
CA
United States
Target group
College/higher education
Professional and scholarly
Illustrations
127
5 s/w Abbildungen, 127 farbige Abbildungen
XVI, 284 p. 132 illus., 127 illus. in color.
Dimensions
Height: 25.4 cm
Width: 17.8 cm
Weight
5743 gr
ISBN-13
978-1-4842-1942-3 (9781484219423)
DOI
10.1007/978-1-4842-1943-0
Schweitzer Classification
Other editions
New editions

Peter A. Carter
Expert Scripting and Automation for SQL Server DBAs
Amplifying Productivity Through Automation
Book
05/2025
2nd Edition
APress
€64.19
Shipment within 10-15 days
Additional editions

Peter A. Carter
Expert Scripting and Automation for SQL Server DBAs
E-Book
07/2016
APress
€79.99
Available for download
Person
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.
Content
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.