Today I was going through the SQL Server 2008 so called “What’s New”.

I came to know about “Change Tracking” and “File Stream Storage”.

Change Tracking as per BOL
SQL Server change tracking allows applications to obtain incremental changes to user tables. Where two-way synchronization is required, change tracking also allows applications to check for data conflicts. With change tracking integrated into SQL Server 2008, developers no longer have to create complicated custom change-tracking solutions.
Prior to the integration of change tracking capabilities into SQL Server, developers often created custom change tracking solutions that used a combination of triggers, timestamp columns, other additional columns, and additional tables. Now, developing synchronization applications is easier and faster.

FILESTREAM Storage as per BOL
FILESTREAM storage enables SQL Server applications to store unstructured data, such as documents and images, on the file system. This enables client applications to leverage the rich streaming APIs and performance of the file system while maintaining transactional consistency between the unstructured data and corresponding structured data.

Both of these two above things are really interesting enhancements to the SQL 2008 from my viewport.

I can recall my time, while coding, spent long hours/days when implanting the “what is changed” process to my solutions. Sometimes struggling with triggers, stored procedures, timestamps, audit logs, blah… blah etc.

Also identifying the tradeoff, when to store images/ documents on file system, when in database (you can recall your time via keyword Blob), how to take backups of split data. (File system and database)

In my opinion, SQL server is at least two version late regarding release of file stream storage.
Anyway, Better late than never
[Is often used as a polite way to respond when a person says "sorry" for being late]