Virtualizing SQL Server? When to and when not to.
If you try to virtualize a high load SQL Server you could end up with all the resources of the virtual server being used by the single virtual server.
MS KB Article with all the hot fixes listed
I found this great little MS KB article today. It’s got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug. The MS KB article ID is 937137.
Log Shipping without SQL Server Enterprise Edition
…I’ve written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition…
SQL Server 2008 – Resource Governor Questions
The engineers from Microsoft PSS have posted some excellent information on thier blog about SQL Server 2008’s Resource Governor.