We have been using I3, a product from a company called Precise and it's really good.

It's able to store historical information, shows offenders, sends out alerts... It's very robust and...

I would not do that directly in production, make sure you can test this out first.

Our main application still sits in SQL 2000 because it does not work in...

I use 7zip on my servers, it's free, it works on both, 32 and 64 bit platforms, has cmd line available to batch and it works like a charm.

May not...

Some people use SSIS to perform some of these repetitive tasks and honestly, for some tasks, it works quite well.

I've been working as a DBA for 3 years almost, but...

If available, do it in SSIS.

The zip files seems to be unavailable.

I just try to stay away from RS filters, and pass the query directly to SQL engine and let SQL take care of the query.