國立虎尾科技大學 |

Expert Scripting and Automation for SQL Server DBAs

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Expert Scripting and Automation for SQL Server DBAs/ by Peter A. Carter.
Author:	Carter, Peter A.
Description:	XVI, 284 p. 132 illus., 127 illus. in color.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-1943-0
ISBN:	9781484219430

Expert Scripting and Automation for SQL Server DBAs
Carter, Peter A.

Expert Scripting and Automation for SQL Server DBAs[electronic resource] /by Peter A. Carter. - 1st ed. 2016. - XVI, 284 p. 132 illus., 127 illus. in color.online resource.

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

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.

ISBN: 9781484219430

Standard No.: 10.1007/978-1-4842-1943-0doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Expert Scripting and Automation for SQL Server DBAs
LDR:03047nam a22003975i 4500 001 972040
003 DE-He213
005 20200704041527.0
007 cr nn 008mamaa
008 201211s2016 xxu| s |||| 0|eng d
020 $a 9781484219430 $9 978-1-4842-1943-0
024 7 $a 10.1007/978-1-4842-1943-0 $2 doi
035 $a 978-1-4842-1943-0
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Carter, Peter A. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1070187
245 1 0 $a Expert Scripting and Automation for SQL Server DBAs $h [electronic resource] / $c by Peter A. Carter.
250 $a 1st ed. 2016.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2016.
300 $a XVI, 284 p. 132 illus., 127 illus. in color. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 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. .
520 $a 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.
650 0 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484219423
776 0 8 $i Printed edition: $z 9781484219447
856 4 0 $u https://doi.org/10.1007/978-1-4842-1943-0
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)