Chapter 9Automating SQL Server administration
Components of SQL Server automated administration
Using SQL Server Maintenance Plans
As you’ve made your way through the book, covering the many things you need to keep your SQL Server healthy might feel overwhelming, given the prospect of doing everything manually. However, what separates a novice DBA from a seasoned one is the ability to automate many common administration tasks.
This chapter reviews the common ways of automating Microsoft SQL Server instance administration, starting with an exploration of the tools that enable them:
Tools including Database Mail and ...
Get SQL Server 2019 Administration Inside Out 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.
