How to generate and use RSA key pairs with Git on Windows

I had to generate RSA key pairs in order to use Git with "github" and "bitbucket" on my Windows machine.
I am showing how I did it.

SQL. Sort in a Group

I was looking for a SQL statement to sort the data in a group. For example I have a table "logs". In "logs" I keep the users visits. If you log in into the system I record the event with the date and time. Very often I have been asked to answer the question when the users visited the site for first time or when for last time. So I need to create a list of user names and next to it the date and time for the first or last visit. So far I was doing this using stored procedures or in a program. Recently my friend Victor showed to me the solution bellow. I don't know if that actually works for my case.
You can find the original post here: http://bin.cakephp.org/view/1153419505

SELECT *

                FROM(

                SELECT Message.*, Job.*, Sender.*

                FROM (

                (messages as Message

                LEFT JOIN users as Sender on Message.sender_id = Sender.id)

                LEFT JOIN  

                (jobs_messages as JobsMessage LEFT JOIN jobs as Job ON JobsMessage.job_id = Job.id)

               

                on Message.id = JobsMessage.message_id

               

                )                

                ORDER BY Message.id DESC

                ) as result

                GROUP BY Job.id, Sender.id

Stop a program, which during startup installs and runs a service in Winfows XP

Recently I wanted to start an old MySQL server on Win XP. After starting it a service was installed in the system. Each time I restart my computer the service was installed and started. I had another MySQL server running on the same machine. I didn't want to identical services to run. I had to stop the program that installs and runs the service. There was  a program installing and running the service (WinMySQLAdmin)
This is what I did. You can find other useful commands in the screenshots.