Print spooler failing to start up

The issue was related to a HP monitoring driver. Somehow this software got installed.  Maybe it got installed trying to extract a driver...
Reference:
http://support.microsoft.com/kb/947477

How SQL 2005 Report Server works

Nice blog (see Reference below) about how report server works and what the logs files are for.

Here are some queries that I use to check to see if jobs are stuck on our Report server:

use ReportServer

-- Jobs waiting to execute

select *
from event e
order by TimeEntered

-- Jobs that ARE executing

select n.processstart, n.notificationentered, n.deliveryextension, sch.scheduleid, sub.subscriptionid, sub.description, sub.laststatus, sub.lastruntime
from notifications n, schedule sch, subscriptions sub
where (n.subscriptionid = sub.subscriptionid) and (sch.eventdata = sub.subscriptionid)
order by n.notificationentered desc


Reference:
http://blogs.msdn.com/b/psssql/archive/2009/02/02/why-aren-t-my-subscriptions-working.aspx

Scheduled server reboots

To schedule a reboot, ie. like patching and having a server reboot during the downtime...

"at 23:00 shutdown /l /r /y /c"

See reference for details...

Reference:
http://support.microsoft.com/kb/317371

BusLogic SCSI controller not supported on Vmware VM

When a Windows virtual machine is powered on, the Tasks and Events tab of the virtual machine on the vSphere Client displays this warning under Events:

The guest operating system is and one or more virtual SCSI devices are installed in the virtual machine. does not support the BusLogic SCSI adapter that VMware ESX currently uses for virtual SCSI devices. Install the VMware driver in the virtual machine. Download the driver from "http://vmware.com/info?id=43". Click OK to continue or Cancel to cancel.
Fix is in reference below...

Reference:
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2007603

Fixing orphan database users

This is a good article on how to fix orphan users.  Works well when you restore a database and need to create/link the SQL logins that correspond to database users in the restored database.

Reference:
http://blog.sqlauthority.com/2007/02/15/sql-server-fix-error-15023-user-already-exists-in-current-database/

Netapp Command Cheat Sheet

Just found this...  pretty useful...

Reference:
http://www.datadisk.co.uk/html_docs/netapp/netapp_cs.htm

Nice SQL setup checklist

Reference at the bottom is a good check list for installing SQL server.

Good resource for SPs and updates to SQL server:
http://sqlserverbuilds.blogspot.com/

Reference:
http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/