What you'll learn

Auditing SQL Server is one of the most critical tasks a database administrator is assigned to. The understanding and knowledge of who does what and when is just as important as making sure that your database servers are up and running. What's more, DBAs do not manage just one instance of SQL Server nowadays, but hundreds or even thousands. In addition to that, sometimes there is a need to check for or even enforce a specific business rule or configuration and thus prevent someone violating some specific requirements, for example. All of those tasks can be quite time-consuming or even impossible to accomplish except if Policy-Based Management is used. With this course, the learner will be prepared to face the challenge of auditing and enforcing rules across many database servers, without spending a lot of hours working on these tasks.