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 2m
- What is Policy-Based Management? 2m
- Main Components of a Policy 4m
- Demo: Policy-Based Management and SQL Server Management Studio 3m
- Facets 2m
- Conditions 2m
- Evaluation Modes 7m
- Demo: Facets and Conditions 2m
- Demo: Building a Simple Policy 5m
- Categories 2m
- Demo: Categories 5m
- Demo: Which Facet Supports Which Evaluation Mode? 2m
- Demo: Allow Triggers to Fire Others 2m
- Summary 2m
- Introduction 3m
- Demo: Policy Using On Demand Evaluation Mode 7m
- Demo: Policy Using On Schedule Evaluation Mode 11m
- Demo: Policy Using On Change: Log Only Evaluation Mode 7m
- Demo: Policy Using On Change: Prevent Evaluation Mode 7m
- Demo: Using Categories 5m
- Demo: Exporting Policies 2m
- Demo: Importing Policies 3m
- Centralized Management Server 4m
- Demo: How to Build Centralized Management Server 8m
- Demo: Using Centralized Management Server 4m
- Demo: Importing Policies With CMS 3m
- Demo: Targets and Conditions 4m
- Demo: Server Restriction Conditions 4m
- Demo: Microsoft Built-In Policies 3m
- Summary 3m
- Introduction 2m
- Error Messages and Policies 2m
- Demo: Error Messages With on Demand Evaluation Mode 3m
- Demo: Error Messages With on Schedule Evaluation Mode 2m
- Demo: Error Messages With Change: Log Only Evaluation Mode 3m
- Demo: Error Messages With on Change: Prevent Evaluation Mode 3m
- Creating a Monitoring Solution for PBM 3m
- Demo: Database Mail 5m
- Demo: SQL Server Agent Operators 2m
- Demo: SQL Server Agent Alerts 4m
- Summary 2m
- Introduction 3m
- Advanced Conditions 6m
- Demo: Policies Using ExecuteSql() 6m
- Demo: Policies Using ExecuteWql() 3m
- Demo: Query WMI Classes and information 7m
- AlwaysOn Availability Groups Dashboard 1m
- Demo: Creating Policies for AlwaysON AG Dashboard 7m
- Executing Policies With PowerShell 4m
- Demo: Executing Policies With PowerShell 9m
- Summary 2m
- Introduction 1m
- PBM and msdb 3m
- Demo: Policy-Based Management History Logging 5m
- Demo: Policy-Based Management Logging Properties 4m
- System Tables and Objects in Policy-Based Management 2m
- Demo: Extracting Data From msdb System Tables 7m
- Demo: Custom Scripts to Retrieve Data From System Objects 7m
- Demo: Renaming a Policy 4m
- Policy-Based Management Security 5m
- Demo: Assigning the PolicyAdministratorRole 4m
- Demo: Using ##MS_PolicyTsqlExecutionLogin## 6m
- Summary 2m
- Introduction 1m
- Why Do We Need a Reporting Solution for Our Policies 3m
- Introducing Enterprise Policy Management Framework 2m
- Demo: Enterprise Policy Management Framework 4m
- EPM Framework prerequisites 4m
- Demo: Deploying EPM Framework Part 1 8m
- Demo: Deploying EPM Framework Part 2 6m
- Demo: Deploying EPM Framework Part 3 5m
- Demo: Deploying EPM Framework Part 4 6m
- Demo: Deploying EPM Framework Part 5 6m
- Summary 2m