Chapter 15. Tracking Access and Changes to Data

Greg Low

Microsoft SQL Server 2008 introduced a number of new technologies related to tracking changes to data. Although alternatives have been available for this in earlier versions of the product, tracking access to data has been more difficult in the past. SQL Server 2008 helps address this need.

Which Technology Do I Use?

We need to track access and changes to data for several reasons:

  • Auditing and compliance have become very important issues in recent years. We need to be able to answer questions on who accessed which data and when they did it.

  • We need to be able to support occasionally connected systems and mobile workforces.

  • We need to be able to incrementally load data warehouse systems.

We can ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.