Month: August 2011

Export putty settings

Reading Time: < 1 minute It looks like your putty sessions are stored in the registry.

 
Start up the registry editor: regedit.exe (on Windows 7, hit the windows key and type regedit.exe)
 
Browse to HKEY_CURRENT_USER\Software\SimonTatham
 
Right click on "Sessions", choose export. Give a name. Email the file.
 
On the other computer, get the file, save it, right click on it, click on merge. Done

bypass authentication for a specific URL with squid and webmin

Reading Time: 2 minutes If you need to setup some webmin rule for bypassing authentication for a specific URL, it’s VERY easy to setup.

This is something that can be needed if you have a windows server behind a proxy and that server needs direct access to the internet in order to be activated:

Activation fails when you try to activate Windows 2008 over the Internet… 

Trainer Assessor

Reading Time: 3 minutes

Today I got an interesting call from my boss. I am going to become an assessor for other trainers at Nokia Siemens Networks. This means that I will have to assess the training capabilities of my peers.
Since I have been a respectable trainer for the past 5 years I have indeed accumulated a good experience.
I feel very proud that my efforts are rewarded with this opportunity.

How to find which SQL is executed by a process

Reading Time: < 1 minute

If you are looking for the last SQL query ran by a specific process, try this: 

 
select substr(sa.sql_text,1,1000) txt
from v$process p, v$session s, v$sqlarea sa
where p.addr=s.paddr
and s.username is not null
and s.sql_address=sa.address(+)
and s.sql_hash_value=sa.hash_value(+)
and spid=&SPID;