Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

J. BushPractical Database Auditing for Microsoft SQL Server and Azure SQLhttps://doi.org/10.1007/978-1-4842-8634-0_9

9. Tracking SQL Server Configuration Changes

Josephine Bush¹  

(1)

Boulder, CO, USA

 

This chapter will outline the ways you can view configuration changes in SQL Server. You will want and need to capture these changes since they can have a large impact on your database server.

Configuration changes can include enabling SQL Agent or Database Mail. They can also include things like changing max and min memory. There are a lot of different configuration settings. Most server configuration options are available via SSMS. Some of you can only access ...