For multiple operators, I usually send to a general box somewhere and then let the email system either forward to multiple people or one.

If you don't have SMS or MOM, then this is a pain. I might psexec it, logging the results to each server.

That or get a bunch of terminal server sessions...

Definitely use SHRINKFILE, but be sure that you don't need that space. HAving the log shrink and grow is a waste of resources.

I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might...

You should use ALTER INDEX with 2005 and above as DBCC REINDEX is deprecated.

I'm not sure what you can grab here, though checking @@ERROR and related variables after the command...

I'd also recommend 37 Signals to check out. They have an interesting blog.

I heard Jason Fried speak recently and he talked a bit about how they build software and their...

We definitely don't condone posting of braindumps or links to dumps. They are a form of cheating and not accepted for passing. Microsoft has sued companies providing them.

Similar questions from...

The training kit should give you an idea of the types of questions and perhaps someone will chime in.

Exact questions and potential answers, should not be posted as that violates...

Sure is: http://support.microsoft.com/kb/193888

Ewan,

The way ESX works is that it's like a cluster of VMWare hosts. The "floating" means that your VM could migrate to another physical machine, WHILE it's running, and without...

We plan to keep them here and Jumpstart as well. Jumpstart runs on advertising as does this site, so that's the cost.

Nothing is for free, or almost nothing. It just...

I'm honestly not sure what I want. There has to be a balance between too many meetings and too little information.

For the deployment guys (production, operations), going to a...

If this is SQL 2000, go download Log Rescue from Red Gate (I work for them, it's free) and it might be able to read the T-log or log backup...

Congratulations!

It is important to use RAID with SQL Server.