You can combine the steps into one job. Go into each job's steps and copy the information into one job.

I'm not sure how you can combine these when they are all going to separate temp tables. The issue is that if these are used later, then combining them might...

You can also right click the database in SSMS, choose Reports, and look for one that matches your needs. There are a number of standard reports that might help.

Changing the password only affects things that connect with the app. So an application, potentially jobs or other scripts/programs that might use this.

However a blank password, especially SA, is a...

I think the power savings would come from less hardware time from tape drives or less drives needed if you used disk backup. For any particular database it would not...

Speaking of lunch....

I once got a resume with the "Interests" section saying "Eating exotic meats"

I wanted to bring the guy in just to see him, but he was too weak...

You should always use parenthesis to be sure that there isn't confusion. and to be sure if your server upgraded and the order changed, that you'd not have strange math...

Marios has a good point. If space is an issue, Idera has a nice product. I'd also look at Litespeed from Quest, Red Gate's SQL Backup (I work for Red...

And check the current error log. Be sure the services are running and then look for what port/name SQL is listening on.

This partially removes the need for a DBA, but not completely. There is no query tuning here, just storage services. I guess that helps, but if you depend on this,...

I think telecommuting is a great tool and should be used where appropriate. especially in reducing the cost of commuting.

My feeling is that Agile needs to adjust to handle this....

Thanks for the update and be careful of pausing replication for extended periods of time.

I agree with Jeff. It depends on how you are moving the data as to the best advice.

If not search for "forcibly shrink" here for a script that can help.

you should rarely shrink anything. Usually this is because something hasn't been done correctly in the past or...

Whoops and thanks for the link, William.

I think that this can be a good solution for smaller companies. If you can't afford high bandwidth or distributed servers, this is one...