ADSL QoS - Quality of Service setting for smoother web experience while P2P ongoing

using D-link DSL-2640B as reference:

-log in your ADSL modem

-click ADVANCED tab

-mouse over "Network Tools", click "Quality of Service". Just click OK for the prompt dialog

-click Add

Make this setting

-Traffic Class Name: my_web           (don use spacebar)

-Assign Classification Queue: wireless&Prece 1&Queue 1

-Protocol: TCP/UDP

-Destination Port Type: Single Port

-UDP/TCP Destination Port (port or port:port): 80

click Apply

-click Add   again

-Traffic Class Name: my_p2p           (don use spacebar)

-Assign Classification Queue: wireless&Prece 8&Queue 8

-Protocol: UDP

-Destination Port Type: Port Range

-UDP/TCP Destination Port (port or port:port): 1024:65530

click Apply

you might need to restart the router.

FYI, the web browsing is MORE responsive, but if P2P is heavy web still slow.

windows 7 search file name only

So you are one of the millions frustrated users out there who hate 7's search compared to XP's.
Try this in windows 7's Windows Explorer -Tools option - Folder Options - Search - (What to search) Click In indexed locations, search file names and ...

MSSQL 2005/2008 auto backup by task scheduler

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'myDatabaseName')
BEGIN
   BACKUP DATABASE myDatabaseName TO DISK = 'C:\test\myDatabaseName.bak'
   WITH FORMAT, NAME = 'Auto backup by scheduler';
END
-- make sure there is MODIFY access for EVERYONE on the target folder
--repeat this command in Windows Task scheduler everyday / week:
--sqlcmd -S localhost\sqlexpress -E -i"C:\test\autoBackupScript.sql"

setup iis 6 unatended -- windows XP

http://support.microsoft.com/kb/309506

sysocmgr /i:%windir%\inf\sysoc.inf /u:c:\setupiis.txt
setupiis.txt::

[Components]
iis_common = ON
iis_www = ON
iis_www_vdir_scripts = ON
iis_inetmgr = ON
fp_extensions = ON
iis_ftp = ON

repair windows files from CD "sfc /scannow" -- windows XP + 7

sfc /scannow 

repair windows 7 boot

from "http://heiser.net/posts/3256"

1. Reconfigure your BIOS to boot from the DVD first and then the Win7 drive
2. Boot the machine from the Win7 DVD
3. After the language select screen, choose "Repair your computer" from the lower left
4. The system will not find any installations. This is okay, click the top radio button and hit Next
5. You'll see a list of "System Recovery Options". Open up the Command Prompt
6. Try typing the following commands in order: "bootrec /fixmbr", "bootrec /fixboot", "bootrec /rebuildbcd". If these complete successfully, go ahead and skip the next step. However, if any of these steps reports "Element cannot be found" you need to reconfigure the disk configuration.
7. You're going to use DISKPART to make the Win7 partition active. You can type "HELP" for a list of commands or check out Microsoft's help page. Basically you select the drive first ("LIST DRIVES" and then "SELECT DRIVE [number]") and then the partition ("LIST PARTITION" and then "SELECT PARTITION [number]") where Win7 is installed. Then type "ACTIVE" to make the selected partition active. Once this is finished, repeat the previous step.
8. With the bootloader now created, we need to let Win7 configure it. Restart and boot from the DVD again, and choose the same repair option as before. Now you should see your Win7 installation listed. Allow the installer to repair the system. You may have to repeat this step once or twice, but eventually the bootloader will be fixed and your machine will work again!

Uninstall Office 2003,2007,2010 suites if I cannot uninstall it from Control Panel

http://support.microsoft.com/kb/290301/en-us

and remove rgstrtn.lck :
http://support.microsoft.com/kb/927153