Simple GB Convertion in Excel

Format bytes a cell in Excel as KB, MB, GB etc?

Right click a particular cell, Format the cell and apply a Custom category and add to the 'Type' field [<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

works in office 2010 and above without any issues.

Martin Luther King's - I Have a Dream speech by Tejas Rinith - Grade 5

Network Load Balancing and Virtual Machines: Tuneup

SharePoint 2010 Web-Front-End NLB Tuning (points to be noted before configuring Network Load Balancing and Virtual Machines on Windows Server 2008 R2):

When running NLB as a Virtual Machine (VM) guest using Windows Server 2008 R2 Hyper-V you need to be aware of some specific configurations settings in Hyper-V host prior to configuring NLB. If you do not enable spoofing of MAC address prior to configuring NLB on the VM you could potentially have problems with the NLB cluster. 

When configuring NLB in unicast mode on Hyper-V with enable spoofing of MAC Address disabled you may see some of the following symptoms:

• When initially configuring NLB you will lose network connectivity on the network adaptor NLB was configured on.
• Either of the nodes NLB status might show converging instead of converged and healthy status.
• There will be an NLB error event in the Windows Event Log stating that the network adaptor does not support dynamic MAC address updates.
• After rebooting the server, NLB will appear to be bound to the network adapter, but the cluster VIP will not have been added to the network adaptor.
• The cluster MAC address will still be the original MAC address associated with the network adaptor prior to configuring NLB.   Use CMD> ipconfig /all to view the MAC address.  It should start with "02-BF-***"
• If you ignore all previous symptoms and manually add the VIP you could get an IP conflict if there are other nodes in the cluster that have the same VIP.

With that said, to allow VM guests to run NLB you need to set the VM property for "Enable spoofing of MAC Address". 

To enable spoofing of MAC Addresses open the Hyper-V management console.  Make sure the VM is stopped open the properties of the VM.  Select the Network Adaptor for the NLB VM and check the "Enable spoofing of MAC Address" and click OK.  Then start the VM.

also refer articles from technet here http://technet.microsoft.com/en-us/library/cc917873.aspx

Remote Desktop Licensing

Remote Desktop supports two concurrent connections to remotely administer a computer. You do not need a license server for these connections. However to permit more concurrent connections you need to acquire MS RD license.

Checklist: Configure Remote Desktop Licensing

http://technet.microsoft.com/en-us/library/cc731251.aspx

For moving RD Licensing from an existing Remote Desktop license server to another server, use the steps in the below article.

http://technet.microsoft.com/en-us/library/cc730776.aspx

For Migrating the RDS CALs from the existing license server to the new license server by using the Manage RDS CALs Wizard in Remote Desktop Licensing Manager, use the below link.

http://technet.microsoft.com/en-us/library/hh553155(v=WS.10).aspx

(Here you need to concentrate on the subheading Migrating CALs from Windows 2003 source to Windows 2008 R2 target)

Note: This can cause a downtime during the migration process.

Remove Windows.old From a Server

Delete the windows.old from an upgraded Windows Client:Win7 & above or Server: 2008 & above

For a client OS that's upgraded, the Disk Cleanup utility can be used to delete the very large windows.old folder containing the old OS. This isn't available on a server OS without installing the Desktop Experience feature.

To delete, it is necessary to take ownership of the folder, give administrators full control, then delete. This can be done with the commands below:

• takeown /F c:\Windows.old\* /R /A /D Y
• cacls c:\Windows.old\*.* /T /grant administrators:F
• rmdir /S /Q c:\Windows.old 

Using GUI: I improvised and claimed ownership of the parent folder as well as ensured I had Full Control and that all child folders and files were altered to inherit these attributes - at that point I deleted the folder successfully.

Change default desktop background

Citrix Terminal Server
How to change the default desktop for Citrix XenApps server:

http://www.youtube.com/watch?v=dxEVz7jg8mM

Default attachment path in windows 7 and above email clients

Tips of the Day..!

you might sometimes wonder where does the attachments vanish in case you open an attachment and modify them directly from your email client like; Windows live mail or Microsoft outlook.

below is the path where you can search for.. simple way is to open any one of the attachment from your email client and click file save as, this will give you a clear idea of default source location.

Windows Live Mail default attachment cache location:

C:\Users\kt.rinith\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\

Microsoft Outlook default attachment cache location:

C:\Users\kt.rinith\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook