Check out this link: http://www.wardyit.com/blog/blog/archive/2006/04/26/101.aspx

The sp_helprevlogin broke with an update to ss2k5, so if you are using ss2k, be sure you keep this around.

Good advice above for moving.

You don't want growth or shrinking unless really necessary. Both slow the system, though arguably growth is worse.

You want to size appropriately and grow when needed to a size that...

The recommendation is remove these accounts unless they need access. I have done it both ways. There are times I want the administrator having sysadmin privileges, like when I'm on...

Schedule it twice, once for Fris, once for EOM. Be sure the time on the day for EOM is later than the one for Fris. Then add logic to the...

The MS licensing states you must license every processor on the box where SQL runs, whether you have set affinity or now. This means 2 CPUs = 2 per processor...

I have defragmented both ways, on and offline and they both work. The load on SQL Server might be an issue if you try to defragment when it is heavily...

all points awarded back. This was a bit of a bad question.

On moving goods, sorry about that. Rereading makes me realize that it sound a little funny.

Years ago, the cost of shipping goods helped to even out the savings in...

In Denver, I've typically seen 80-100K for a senior SQL DBA, but I have seen a few in the 70s for government or smaller companies.

I'd remove the ASPNET user and add the anonymous user in IIS. See if that account works.

Easiest way is to buy Data Compare from Red Gate. Easily with the $300 in time it would take to develop scripts.

sysinternals has a free utility: http://www.sysinternals.com/SysinternalsSiteMap.html

Don't know of any case studies, but it becomes much harder to scale out, be fault tolerant for some clients, etc. if they are combined. Definitely lowers admin if you...

Here's one:

http://support.microsoft.com/kb/q189271/

I setup my old HOA with Websecure stores (http://www.websecurestores.com/) to get the dot net nuke thing. It was a pretty good deal. Not sure if you can get $10 for...