大葉大學圖書館 |

Expert scripting and automation for SQL Server DBAs[electronic resource] /

紀錄類型:	書目-電子資源 : Monograph/item
杜威分類號:	005.13
書名/作者:	Expert scripting and automation for SQL Server DBAs/ by Peter A. Carter.
作者:	Carter, Peter A.
出版者:	Berkeley, CA : : Apress :, 2016.
面頁冊數:	xvi, 284 p. : : ill. (some col.), digital ;; 24 cm.
Contained By:	Springer eBooks
標題:	Scripting languages (Computer science)
標題:	Computer Science.
標題:	Database Management.
ISBN:	9781484219430
ISBN:	9781484219423
內容註:	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.
電子資源:	http://dx.doi.org/10.1007/978-1-4842-1943-0

Expert scripting and automation for SQL Server DBAs[electronic resource] /
Carter, Peter A.

Expert scripting and automation for SQL Server DBAs[electronic resource] /by Peter A. Carter. - Berkeley, CA :Apress :2016. - xvi, 284 p. :ill. (some col.), digital ;24 cm.

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--Uniform Titles:

SQL server.
Subjects--Topical Terms:

456266
Scripting languages (Computer science)

LC Class. No.: QA76.6

Dewey Class. No.: 005.13

Expert scripting and automation for SQL Server DBAs[electronic resource] /
LDR:02698nmm a2200325 a 4500 001 462471
003 DE-He213
005 20160727131549.0
006 m d
007 cr nn 008maaau
008 170223s2016 cau s 0 eng d
020 $a 9781484219430 $q (electronic bk.)
020 $a 9781484219423 $q (paper)
024 7 $a 10.1007/978-1-4842-1943-0 $2 doi
035 $a 978-1-4842-1943-0
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.6
072 7 $a UN $2 bicssc
072 7 $a UMT $2 bicssc
072 7 $a COM021000 $2 bisacsh
082 0 4 $a 005.13 $2 23
090 $a QA76.6 $b .C324 2016
100 1 $a Carter, Peter A. $3 636026
245 1 0 $a Expert scripting and automation for SQL Server DBAs $h [electronic resource] / $c by Peter A. Carter.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2016.
300 $a xvi, 284 p. : $b ill. (some col.), digital ; $c 24 cm.
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.
630 0 0 $a SQL server. $3 405561
650 0 $a Scripting languages (Computer science) $3 456266
650 1 4 $a Computer Science. $3 423143
650 2 4 $a Database Management. $3 463966
710 2 $a SpringerLink (Online service) $3 463450
773 0 $t Springer eBooks
856 4 0 $u http://dx.doi.org/10.1007/978-1-4842-1943-0
950 $a Professional and Applied Computing (Springer-12059)