- Course
- Data
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.
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.
Table of contents
- Introduction | 1m 48s
- What is Policy-Based Management? | 2m 9s
- Main Components of a Policy | 4m 13s
- Demo: Policy-Based Management and SQL Server Management Studio | 3m 11s
- Facets | 2m 26s
- Conditions | 1m 56s
- Evaluation Modes | 6m 52s
- Demo: Facets and Conditions | 1m 57s
- Demo: Building a Simple Policy | 4m 47s
- Categories | 1m 49s
- Demo: Categories | 5m 27s
- Demo: Which Facet Supports Which Evaluation Mode? | 2m 12s
- Demo: Allow Triggers to Fire Others | 1m 32s
- Summary | 1m 59s
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