De ce sa monitorizam

• Baze de date mari la care backup and restore nu e o solutie rapida

• Aplicatia nu are un istoric al modificarilor

• Cerinte ale managerilor

Metoda old style

• Triggeri de update , insert, delete

• Demo

• Link : http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html

Metoda citirii din log

• Apex Sql Log

• http://www.apexsql.com

• Instaleaza pe server componente

• Demo

New Kid : Change Data Capture

• Metoda valabila cu SqlServer 2008 ( NU EXPRESS )

• Demo cu http://cdchelper.codeplex.com/

• Link http://msdn.microsoft.com/en-us/library/bb522489.aspx