This guide focuses on VS2005 Express Edition with advanced services, though this applies to any version of SQL2005. The first thing you’ll need to do is copy the install files to your distribution share via the Deployment Workbench. Be sure to choose a directory structure without spaces as this seems to cause problems during setup. [...]

Due to seemingly non-existant documentation on moving a WSUS 3.0 database to a new server, I figured i’d write up my experience. Database configuration is all stored in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\UpdateServices\Server\Setup The keys you’re interested in are SqlServerName and SqlInstanceIsRemote. Microsoft only officially support Windows authentication, so that’s what i’ll cover here. You’ll be able to connect [...]

Now that my hangover has just about worn off from a rough night out, I thought i’d post something useful. Below is a quick and (very) dirty way of clearing down the log and shrinking MSSQL datbases. Something useful for people who want to keep their Windows systems/networks tidy. — DECLARE STUFF. DECLARE @rowCount int [...]