Implement Auditing Logging and Event Handling

Practice Labs Module
Time
1 hour
Difficulty
Intermediate

The "Implement Auditing Logging and Event Handling" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Implement Row Level Auditing in an SSIS Package, 2) Configuring SSIS Container for Event Logging, 3) Create Custom Logging to...

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Implement Auditing Logging and Event Handling module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Implement Row Level Auditing in an SSIS Package
  2. Configuring SSIS Container for Event Logging
  3. Create Custom Logging to Track Errors using Event Handlers
  4. Implement Alerts and Notification Mechanism

Exercise 1 - Implement Row Level Auditing in an SSIS Package

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • How to implement row level auditing using the audit transformation in an SSIS package

Exercise 2 - Configuring SSIS Container for Event Logging

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Configure an SSIS Container for event logging using the appropriate log provider
  • Log information about the status of each phase of the package execution

Exercise 3 - Create Custom Logging to Track Errors using Event Handlers

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Create custom logging to track errors using event handlers in an SSIS package

Exercise 4- Implement Alerts and Notification Mechanism

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Configure an SSIS package to use alerts to report errors in the package
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.