Information Technology Notes/Tutorial Database

This is a list of various useful notes and tutorials for web design and network administration, it is for our staff's reference but we made it public so others could benefit from it as well.


0001 - How to change the listening port for Remote Desktop

1. Start Registry Editor.

2. Locate and then click the following registry subkey:

   HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer\WinStations\RDP-Tcp\PortNumber

3. On the Edit menu, click Modify, and then click Decimal.

4. Type the new port number, and then click OK.

5. Quit Registry Editor.

Information source

0002 - How to configure the Remote Desktop client to connect to a specific port

1. Click Start, click All Programs, point to Accessories, point to Communications, and then click Remote Desktop Connection.

2. In the Computer box, type the computer name or the IP address of the computer that you want to connect to, followed by a colon (:) and the port number that you want to use.
   
   For example, to connect to port 3390 on a computer that is named "MyXPPro," type the following information:

   MyXPPro:3390

   To connect to port 3391 on a computer with IP address 10.10.10.1, type the following information:

   10.10.10.1:3391

3. Click Connect.

Information source

0003 - How to load/execute SQL statements from text/.sql file

Type the following commends.

1. 1. "use databasename;" (This selects a database that is to work with, replace databasename with actual name of a database)
   

2. 2. "\. c:\directoryname\sqlfilename.sql" (This runs the SQL file, command includes path and file name)
   

Information source