Expert Scripting and Automation for SQL Server DBAs (1st Edition)

Expert Scripting and Automation for SQL Server DBAs (1st Edition)

AUTHOR: Peter Carter

PUBLISHER: Apress

PAGES: 280

ISBN-10: 1484219422; ISBN-13: 978-1484219423

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.

About the Author
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.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

Disclaimer

Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.

Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.

HRMS & Payroll Web Application

Web Application Payroll Register

Pinoy web application payroll register is a data process that all lists of total information for every pay period upon approved by payroll approver before saving to the payroll register like total gross pay, total overtime, total allowances, total of each type of deduction, and total net pay. The computation for each individual employee like gross pay, net pay, withholding tax, overtime pay and other deduction amount seen in payslip report are stored in database table payroll register. read more »

Mortgage Loan Calculator

Calculate your Mortgage Loan using this mortgage calculator. It's important to calculate mortgage monthly amortization payment to know how much you can afford for investing house & lot, car or other loans. read more »

2018 TRAIN Law Tax Calculator

TRAIN Law Tax Calculator to allow individuals to have an idea on how much their monthly salary deduction of withholding tax, sss, pagibig, philhealth contribution and salary net pay. read more »

2018 BIR Train Income Tax Rates and Tax Tables

The Bureau of Internal Revenue (BIR) has circularized the Revised Withholding Tax Table which should be used in computing tax withheld on every payment of employee compensation. The Table is effective from January 1, 2018 to December 31, 2022. Under the TRAIN law, there will be revised rates of the individual income tax effective on January 1, 2023. read more »

HRMS Employee Data Entry

HRMS Employee Data Entry is a process to capture employee’s information data and documents. Pinoy Web Application create basic data entry form how to gather employee's data in Personal Details, Job Information, Allowance and 201 Files that manageable and easy to access or retrieve information. read more »