Expert Scripting and Automation for SQL Server DBAs

Peter A. Carter

$173.95 $156.57

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
28 July 2016

SQL Server & MS SQL

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

What You Will Learn

Automate the SQL Server build process

Create intelligent, metadata-drive routines

Automate common maintenance tasks

Create automated responses to common break/fix scenarios

Monitor multiple instance from a central location

Utilize T-SQL and PowerShell for administrative purposes

Who This Book Is For Expert Scripting and Automation for SQL Server DBAs is a book for SQL Server database administrators responsible for managing increasingly large numbers of databases across their business enterprise. The book is also useful for any database administrator looking to ease their workload through automation. The book addresses the needs of these audiences by showing how to get more done through less effort by implementing an intelligent, automated-processes service model using tools such as T-SQL, PowerShell, Server Agent, and the Management Data Warehouse.

By: Peter A. Carter
Imprint: APress
Country of Publication: United States
Edition: 1st ed.
Dimensions: Height: 254mm, Width: 178mm, Spine: 16mm
Weight: 5.743kg
ISBN: 9781484219423
ISBN 10: 1484219422
Pages: 284
Publication Date: 28 July 2016
Audience: College/higher education , Professional and scholarly , Primary , Undergraduate
Format: Paperback
Publisher's Status: Active

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.

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.

PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Expert Scripting and Automation for SQL Server DBAs

Peter A. Carter

$173.95 $156.57

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S