MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Auditing SQL Server With Policy-Based Management

Course Summary

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 d


  • +

    Course Syllabus

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


    Course Fee:
    USD 29

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

    Attended this course?

    Back to Top

    Awards & Accolades for MyTechLogy
    Winner of
    REDHERRING
    Top 100 Asia
    Finalist at SiTF Awards 2014 under the category Best Social & Community Product
    Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
    Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
    Hidden Image Url

    Back to Top