May 2023
Intermediate to advanced
992 pages
31h 14m
English
book
SQL Server 2022 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson
Content preview from SQL Server 2022 Administration Inside Out
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 9
Automate SQL Server administration
In the previous chapter, you learned about various tasks needed to maintain and monitor SQL Server. Managing these tasks can be time consuming and overwhelming, especially if you try to do them manually.
This chapter reviews common ways of automating Microsoft SQL Server instance administration, starting with an exploration of the tools that enable them.
Note
If you are unfamiliar with automating common administration tasks, this is an opportunity to grow and become a more seasoned DBA.
This ...