What's your SQL instance doing while you are away?
Say you're a DBA responsible for several instances of SQL Server running in your company and you have a long deserved vacation coming up. You want to know about data changes to certain mission critical tables while you're away but don't want your spouse noticing the company laptop tucked away in the carry on luggage. Well, thanks to the SQL Server Samples blog you can put your fears to rest with the open source SQLRSS project. The project writes changes to an RSS feed that can be subscribed to, alerting you of data changes as they take place. With an RSS reader you can stay on top of changes and not be the dork with a laptop open down on the beach (for full disclosure I've been that dork).
This project is SQL Server 2008 specific as it makes use of Change Data Capture (one of my favorite new features). I'm going to see how difficult it is to re-engineer this for SQL 2005 making use of similar auditing tables. Another post to follow...
So check out this open source project on that VPC/VM you've got running with SQL Server 2008 RC0. Your spouse/significant other will appreciate it. ;)