December 29, 2010

.DMP file can be opened by Debugging Tools for Windows

http://msdl.microsoft.com/download/symbols/debuggers/dbg_x86_6.11.1.404.msi

December 27, 2010

Format Excel numbers as GB, MB, KB, B

Refer to Yonah Russ

Here is a great tip for formatting numbers in Excel as Gigabytes, Megabytes, Kilobytes, Bytes, etc.
Use the following formula:

=IF((A1>=POWER(2,30)),

TEXT((A1/POWER(2,30)),"##0.00\G"),

IF((A1>=POWER(2,20)),

TEXT((A1/POWER(2,20)),"##0.00\M"),

IF((A1>=1024),

TEXT((A1/1024),"##0.00\K"),

TEXT((A1),"##0.00\B")

)

)

)

Registry – change last logon name

Windows Registry Editor Version 5.00


 

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon]


 

"AltDefaultUserName"="xxxxxxxxxx"

"DefaultUserName"="xxxxxxxxxx"

December 22, 2010

PSTool command

Download it from http://technet.microsoft.com/en-us/sysinternals/default

Direct download - http://download.sysinternals.com/Files/PsTools.zip

Example to use psexec connect to computer and execute batch file on remote computer

psexec \\computername -u {Domain\administrator} -p {password} –d {\\server\share\{batch file's name}

Good tool tips.

December 11, 2010

Driver Doctor - http://www.devicedoctor.com



 

Freeware to update driver on your computer.

November 17, 2010

Printer: Unable to install the printer



---------------------------

Add Printer Wizard

---------------------------

Unable to Install Printer. The print processor does not exist.

---------------------------

OK

---------------------------

Solution: Change driver to another driver first and change it to proper driver. Ie it's failed when install PS driver then, install the PCL

Driver first and change the driver later.

Ref: http://support.microsoft.com/kb/906752