dead battery in desktop pc (sync pc time)

I knew I should replace it with new one to get its date & time running.
Or run the script every time the pc boots up:


type c:\lastdate | date
echo 08:30:00 | time
w32tm /resync
echo %date% > c:\lastdate





update the windows registry:

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Config]
"MaxNegPhaseCorrection"=dword:ffffffff
"MaxPosPhaseCorrection"=dword:ffffffff

setup VPN server for windows XP pro

Setup VPN server
-Start
-Control Panel
-Network Connections
-Create New Connection
-Setup An Advanced Connection
-Acept Incoming Connection, Next
-Allow Virtual Private Connection
-choose some users
-Specify TCP/IP addresses: 192.168.0.2 to 192.168.0.200, Allow calling computer to specify its own IP address
-specify (some where, TCP/IP) own IP: 192.168.0.1
-configure your firewall (software & router)

Connect it with windows 7
-Open Network and Sharing Centre
-Setup a new connection or network
-Connect to a workplace (dial-up or VPN connection..)
-No,Create a new connection
-Use my Internet Connection (VPN)


To test:
file sharing \\192.168.0.1
Remote Desktop 192.168.0.1

delete fb account permanently

Mar 2012: If you click Deactivate your account under Account Settings - Security, you only temporary deactivate it. You may login with the same email & password anytime and its content remained.

The following links may permanently delete your account and all its content:

https://ssl.facebook.com/help/contact.php?show_form=delete_account

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