Development With A Dot

Blog on development in general, and specifically on .NET



My Friends

My Links

Permanent Posts

Portuguese Communities

Browse by Tags

All Tags » Database (RSS)
Table and Column Checksums
Following my last posts on Change Data Capture and Change Tracking , here is another tip regarding tracking changes: table and colum checksums. The concept is: each time a column value changes, the checksum also changes. You can use this simple method...
Change Tracking
You may recall my last post on Change Data Control . This time I am going to talk about other option for tracking changes to tables on SQL Server: Change Tracking . The main differences between the two are: Change Tracking works with SQL Server 2008 Express...
Change Data Capture
There's an hidden gem in SQL Server 2008: Change Data Capture (CDC). Using CDC we get full audit capabilities with absolutely no implementation code: we can see all changes made to a specific table, including the old and new values! You can only use CDC...
More Posts