Fixing orphaned database users

How to fix orphaned database users:

ALTER USER Username WITH LOGIN = LoginName

Commonly happens when you backup then restore a database to a different SQL server.  Any users in the database are orphaned even thought a matching login exists on the new server.  The problem is that the SID of the login and the database user does not match.  Alter User ... can fix this.

Reference:
http://sqlsolace.blogspot.com/2011/05/alter-user-with-login-to-fix-orphaned.html

WSUS Console crashes when browsing for updates

To resolve this issue, delete the WSUS application cache from the location below:
For Win 2008 R2 server:
C:\Users\<user profile>\appdata\roaming\microsoft\mmc

where user profile is the currently logged in user profile.

Reference:
http://support.microsoft.com/kb/2761925

Removing server from SSRS 2008 Scale-Out Deployment

While looking the configuration of our SSRS 2008 server, I found that the old SSRS WFE (web-front end) server had been joined to our current SSRS.  I don't know how this happened or why, but wanted to remove it. 

1. Open command line and go the the path C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\ (on a 64-bit SQL 2008 Reporting Services )
2. List the report servers currently in the database type the command:
   
   RSKeyMgmt -l
3. You will see the server listed with their GUID.  Note the GUID of the server that you want to remove.
4. To remove the instance of the Report server type the command below:
   
   RSKeyMgmt -r
   
5. Press Y to remove the server.
6. Type the command:
   
   RSKeyMgmt -l
   
   and verify that the server has been removed.

Reference:
http://milehighdba.blogspot.com/2011/06/remove-server-from-ssrs-scale-out.html
https://stevenrobert.wordpress.com/2011/06/27/remove-server-from-ssrs-2008-scale-out-deployment/

vihostupdate does not work for vSphere 5

Tried to install patches to our ESXi hosts with vihostupdate and got this error...

 "This operation is NOT supported on 5.0.0 platform"

Found answer in the reference article below... need to use esxcli and have the ZIP file uploaded to a location that the hosts can access directly, ie. a vmfs volume.

Reference:
https://communities.vmware.com/people/vmroyale/blog/2011/09/15/updating-esxi-5--single-use-esxcli-how-to