Adding Mgt Network to IE Local Intranet Zone

1. Open GPEDIT.MSC as administrator
2. Go to Computer Configuration/Administrative Templates/Windows components/Internet Explorer/Internet Control Panel/Security Page.
3. Enable Site to Zone Assignment List
4. Add IP segment, ie. 192.168.0.* with value = 1 (for local intranet, 2=trusted sites).
5. Close all browser session, then test.

Troubleshooting SQL server RESOURCE_SEMAPHORE Wait Type

Application users were complaining that web applications were slow.  Turned out there were some bad queries that were requesting up to 1GB of SQL RAM to execute.  It's no wonder SQL was suspending queries waiting for memory...

Reference:
http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/
http://blogs.msdn.com/b/sqlqueryprocessing/archive/2010/02/16/understanding-sql-server-memory-grant.aspx

WSUS client options

Reference below includes definitions of the regkeys that can be set for different options on the a WSUS client server.

Reference:
http://technet.microsoft.com/en-us/library/cc708449(v=ws.10).aspx