Expert Scripting and Automation for SQL Server DBAs - Image 1

Price loading...

Apress Expert Scripting and Automation for SQL Server DBAs

Name: Expert Scripting and Automation for SQL Server DBAs
Brand: Apress

Information Systems

Price History & Forecast

No Price Data Available

Price history will appear here once data is collected from Amazon.

Price Distribution

No price data available for histogram

Description

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.

Product Specifications

Brand: Apress
Format: paperback
ASIN: 1484219422
Category: Books > Subjects > Computing & Internet > Computer Science > Information Systems
Domain: Amazon UK
Release Date: 28 July 2016
Listed Since: 19 April 2016

Barcode

No barcode data available

Apress Expert Scripting and Automation for SQL Server DBAs

Price History & Forecast

No Price Data Available

Price Distribution

Description

Product Specifications

Barcode

Similar Products You Might Like

Professional Azure SQL Managed Database Administration: Efficiently manage and modernize data in the cloud using Azure SQL, 3rd Edition

SQL Server 2014 with PowerShell v5 Cookbook: Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity

Mastering PowerShell Scripting: Automate repetitive tasks and simplify complex administrative tasks using PowerShell

Mastering PowerShell Scripting: Automate and manage your environment using PowerShell 7.1

Pro SQL Server 2022 Administration: A Guide for the Modern DBA

Pro Database Migration to Azure: Data Modernization for the Enterprise

The Modern Data Warehouse in Azure: Building with Speed and Agility on Microsoft’s Cloud Platform

Beginning T-SQL: A Step-by-Step Approach

Expert PL/SQL Practices: for Oracle Developers and DBAs

Database Performance at Scale: A Practical Guide

Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero)

Troubleshooting Windows Server with PowerShell

Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud

Essential ASP.NET Web Forms Development: Full Stack Programming with C#, SQL, Ajax, and JavaScript

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

The Data Vault Guru: a pragmatic guide on building a data vault

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Windows Server Automation with PowerShell Cookbook: Powerful ways to automate and manage Windows administrative tasks, 4th Edition

Building a Data Warehouse: With Examples in SQL Server (Expert's Voice)

Unlocking dbt: Design and Deploy Transformations in Your Cloud Data Warehouse

Pro SQL Server Internals

SQL Server 2017 Integration Services Cookbook: Powerful ETL techniques to load and transform data from almost any source

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data