Skip to main content

Module 6: Data Protection

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

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 23 Minutes 57 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.


Module 6: Demo 1

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

Video Download
WMV

Length: 22 Minutes 55 seconds


Module 6: Demo 2

In this demonstration you will see how to:

  • Create a Windows user account
  • Associate a SQL Server login with the Windows user account

Video Download
WMV

Length: 7 Minutes 20 seconds

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?