Auditing SQL Server With Policy-Based Management

Auditing SQL Server is one of the main tasks every DBA should take care of, and Policy-Based Management is here to help make that process easy.
Course info
Level
Intermediate
Updated
Jul 14, 2014
Duration
5h 5m
Table of contents
Introduction to Policy-Based Management
Fundamentals of Policy-Based Management
Working With Policies
Troubleshooting and Monitoring Policies
Advanced Policy-Based Management
Policy-Based Management Internals
Reporting on Policies With EPM Framework
Summary
Description
Course info
Level
Intermediate
Updated
Jul 14, 2014
Duration
5h 5m
Description

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.

About the author
About the author

Boris is the Founder and CEO of Presentation Design and Training Agency 356labs. He is also a top rated international speaker, trainer, and blogger. You can find him on Twitter under @BorisHristov and follow his work on his blog – borishristov.com

More from the author
Introduction to Presentation Design
Beginner
1h 6m
Dec 29, 2014