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.