sp_MS_Marksystemobject

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)

Phrase of the Day : Self-Aggrandizement

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

http://www.answers.com/topic/self-aggrandizement

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!

SQL 2008 : Resource Governor Video

Video of Resource Governor in action...

http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx

Tools : IsoRecorder

Free, light, cd recorder software...

http://isorecorder.alexfeinman.com/v2.htm

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 >

http://www.codinghorror.com/blog/2008/04/setting-up-subversion-on-windows.html


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

Windows Firewall - Dell OpenManage

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