Chapter 14Automating SQL Server administration

This chapter reviews the common forms of automating Microsoft SQL Server instance administration, which includes an exploration of the automation tools of choice for SQL Server administration: SQL Server Agent; basic “care and feeding” maintenance, including Maintenance Plans built in to SQL Server Management Studio; strategies for administering multiple SQL Servers, including Master/Target Agent servers (MSX/TSX); event forwarding and Policy-Based Management (PBM); and, ...

Get SQL Server 2017 Administration Inside Out, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.