Expert scripting and automation for SQL Server DBAs [electronic resource] / Peter A. Carter.
2016
QA76.6
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Expert scripting and automation for SQL Server DBAs [electronic resource] / Peter A. Carter.
Author
Carter, Peter A. author.
ISBN
9781484219430 (electronic book)
1484219430 (electronic book)
9781484219423
1484219430 (electronic book)
9781484219423
Published
[Berkeley, CA] : Apress, 2016.
Distributed
New York, NY : Distributed to the book trade worldwide by Springer,
Copyright
©2016.
Language
English
Description
1 online resource : illustrations.
Other Standard Identifiers
10.1007/978-1-4842-1943-0 doi
Call Number
QA76.6
Dewey Decimal Classification
005.13
004
004
Summary
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 inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market. Extensive coverage of automation using PowerShell and T-SQL Detailed discussion and examples on metadata-driven automation Comprehensive coverage of automated responses to break/fix scenarios.
Note
Includes index.
Access Note
Access limited to authorized users.
Source of Description
Online resource; title from PDF title page (SpringerLink, viewed August 9, 2016).
Available in Other Form
Print version: 9781484219423
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources
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. .
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. .