how-to setup public private key authentication between an Win and Nix box

1. Install Cygwin
2. Install separately the ssh-keygen ( or sshd )
3. Download the puttycfg , unzip to a dir in your Windows path
4. Find out where cygwin1.dll is installed cygcheck -sd >list.txt
5. Open the list.txt ( it is quite big ) : notepad list.txt 
6. Copy all the files from   C:\temp\something  to the dir where the cygwin1.dll is located 
7. Start the putty.exe : Start - Run : cmd /c START  /max putty
8. In the GUI , check that Session on the Left is selected , click on Cygterm option , for hostName type - , leave port number 22
9. Open the puttycfg : 
10. Generate the public and private key's : 
11. # ssh-keygen -t rsa
12. Type Enter,Enter
14. Now here is the tricky part you have to tell also putty that the public and private key files are the one you want to use with you : Copy the /home/<<username>>/id_rsa and ..id_rsa.pub to the dir where your save your putty conf in my case: C:\Temp\ysg\conf\<<computername>>\putty\ssh
15. Start - Run - type puttygen 
16. Load the copied private key file and save it as <<file.pkk>> , save also the public key file 
17. Copy the id_rsa.pub file to the server's ~ dir
18. On the server cat id_rsa.pub >> ~/.ssh/authorized_keys
19. Now when started from the windows client  :
20. cmd /c START  /max putty  username@servername.domain.com no password should be asked 

how-to start outlook with unread e-mails folder selected

ECHO START OUTLOOK with selected Unread Mail folder
cmd /c start /max outlook /select "<outlook:Search Folders\Unread Mail>"

how-to get the column metadata in mysql

/* when asked type the password for the username */

mysql -u username -p  -B -e "use information_schema; SELECT     TABLE_CATALOG  , TABLE_SCHEMA  , TABLE_NAME  , COLUMN_NAME  , ORDINAL_POSITION  , COLUMN_DEFAULT  , IS_NULLABLE  , DATA_TYPE  , CHARACTER_MAXIMUM_LENGTH  , CHARACTER_OCTET_LENGTH  , NUMERIC_PRECISION  , NUMERIC_SCALE  , CHARACTER_SET_NAME  , COLLATION_NAME  , COLUMN_TYPE  , COLUMN_KEY  , EXTRA  , PRIVILEGES  , COLUMN_COMMENT

INTO OUTFILE '/var/lib/mysql/information_schema.csv'

FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY ' '

LINES TERMINATED BY '\n'

from COLUMNS; "

I hate watching at the end of the terminal in Unix ...

history | sort -r | less

my favorite textpad shortcuts

Shift F11 - Activate Search Window
F4 , Shift F4 - Next iteam in Find in Files
Alt + 1 , type Letter ( n times )  - activate the Document Selector , go to a file name starting with the letter
Ctrl + Tab , Ctrl + Shift + Tab -  switch between tabs
Alt + C , P - get to Preferences
Alt + F3 - open Explorer in the path of the currently opened file
F3 - copy the path of the current opened file