عنوان

Expert scripting and automation for SQL Server DBAs /

(Number (ISBN

1484219430

(Number (ISBN

9781484219430

Erroneous ISBN

9781484219423

Number

b431490

Title Proper

Expert scripting and automation for SQL Server DBAs /

General Material Designation

[Book]

First Statement of Responsibility

Peter A. Carter

Specific Material Designation and Extent of Item

1 online resource (xvi, 284 pages) :

Other Physical Details

illustrations (some color)

Text of Note

Includes index

Text of Note

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.

0

Text of Note

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

Scripting languages (Computer science)

Number

Number

Edition

Class number

Carter, Peter A.

Ohio Library and Information Network.

Date of Transaction

20160910031717.7

Cataloguing Rules (Descriptive Conventions))

pn

Electronic name

[Book]

Y