Thursday, April 24, 2014
 
  Securing and Auditing Data

Securing and Auditing Data

In this module, you will learn the following:

  • Protecting data from unauthorized users and authorized users who are trying to update the same data simultaneously
  • Using locking modes to achieve concurrency and consistency
  • Implementing database security features to protect the database, database objects and data
  • Using auditing features to monitor database activity
  Understanding Blocking

Understanding Concurrency and Blocking

In this demonstration you will see how to:

  • Create a dirty read
  • Create a committed read with blocking
  • Create a snapshot isolation to remove blocking
  Working with Security Accounts

Working with Security Accounts

In this demonstration you will see how to:

  • Create a Windows user account
  • Associate a SQL Server login with the Windows user account
Securing and Auditing SQL Server 2008

In this module you will learn to protect data from unauthorized users and authorized users who are trying to update the same data simultaneously, use locking modes to achieve concurrency and consistency, implement database security features to protect the database, database objects and data, and use auditing features to monitor database activity.

HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM