Wednesday, February 25, 2009


exec sp_MS_Marksystemobject sp_name

Allows you to mark your own stored procedure 'sp_name' as a system object.

(It cannot then be accidently deleted)

Tuesday, February 24, 2009

Phrase of the Day : Self-Aggrandizement

self-aggrandizement n. The act or practice of enhancing or exaggerating one's own importance, power, or reputation.

Saturday, February 21, 2009

Enabling 'Remote Desktops' tool in Windows 2008

Enabling "Remote Desktops" Snap-In (switch easily between RDP sessions) om Windows 2008

Start -> Run -> MMC [enter]

Add the “remote desktops” snap-in >

Once added, add the servers you want to manage >

Remember to save settings or you'll have to add them all again!

Monday, February 16, 2009

Tools : IsoRecorder

Free, light, cd recorder software...

Bookmark : Setting up SVN Server on Windows

SVN or Subversion is a free source control system the PHP devs use here.

Instructions on setting up the Windows version are here >

TortoiseSVN is the windows client for this and quickly allows you to compare differences in files.

Friday, February 13, 2009

Windows Firewall - Dell OpenManage

To allow Dell OpenManage through Windows FIrewall, open TCP 1311 (for http traffic).

Tuesday, February 3, 2009


Determines sids for machine ids >

Delete SQL backup files over X days old.

Put this in a batch file and schedule it!

FORFILES /p C:\!DB_BACKUP_TEMP /s /m *.BAK /d -7 /c “CMD /C del /Q @FILE”

Careful copying the above command, the double quotes mess it up! copy into notepad, retype the double quotes, then it will be fine!

Note the -7 for 7 days.

Script : Mount a TrueCrypt Volume

Assuming a standard install of Truecrypt, create a Batch (.bat) file that does this >

cd \program files (x86)
cd TrueCrypt
E:\path\ truecrypt /v E:\path\ /l x /p "secure-password" /q
IF EXIST F:\path\ truecrypt /v F:\path\ /l x /p "secure-password" /q

This file mounts the volume as drive letter X: (the x follows the /l parameter)
I use 2 removable drives for alternate days. They are mounted by Windows as E: and F: respectfully. This is why the script checks for both each time and uses the /q for quiet switch to surpress any error messages.

Dismounting the same volume >

cd \program files (x86)
cd TrueCrypt
truecrypt /dx /q

Monday, February 2, 2009