Auditing SQL Server With Policy-Based Management
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction to Policy-Based Management- 6m 8s
—Introduction 0m 45s
—Why Policy-Based Management? 1m 55s
—Course Structure 3m 27sFundamentals of Policy-Based Management- 42m 23s
—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 59sWorking With Policies- 1h 16mTroubleshooting and Monitoring Policies- 29m 39sAdvanced Policy-Based Management- 47m 9sPolicy-Based Management Internals- 50m 4sReporting on Policies With EPM Framework- 47m 49sSummary- 4m 53s