a_hardin's questions

One of the (optional) requirements for the Works With SQL Server 2008 test is that row level compression is enabled on all tables and indexes. We have an existing database with a lot of tables and indexes already created. Is there an easy way to enable compression on all these tables and indexes?

Here is the script I ended up making from splattne's recommendation.

select 'ALTER TABLE [' + name + '] REBUILD WITH (DATA_COMPRESSION = ROW);'   
from   sysobjects   where  type = 'U' -- all user tables
UNION
select 'ALTER INDEX [' + k.name + '] ON [' + t.name + '] REBUILD WITH (DATA_COMPRESSION = ROW);'
from   sysobjects k
join sysobjects t on k.parent_obj = t.id
   where  k.type = 'K' -- all keys
    AND t.type = 'U' -- all user tables

Our current backup scheme is to backup all of our servers to a NAS device, and swap it out with another one occasionally. Of course, this is no fun to manage, so we've been evaluating Microsoft's DPM.

So far, DPM looks like it will work great, but the only thing I haven't been able to figure out is how we can copy the backup data from DPM to a NAS or other external device other than tape to be moved offsite.

We are looking at Iron Mountain's CloudRecovery solution, but wanted to also look at a sneakernet solution, if possible.

Is there an easy way to change a laptop's external monitor (projector) from an extended desktop to a mirrored desktop in Windows Vista? On the current laptop we're trying it on, when we uncheck the "Extend my desktop to this monitor" box, the projector just stops displaying anything.

One workaround is to go into the NVidia control panel and switch it, or to click the Add Projector button in the Vista mobility center, but neither of these are quick or natural. It'd be nice if there was a way from the display settings.