Productivity : Use Keypass to keep track of your environment’s credentials,

Some use Excel, Others simply use text files to keep track of their passwords, but I use keepass .

It is simply a vault for your logins and passwords which you can unlock with a single password. However I use it also for auto-piloting my login procedure.

keepass main window

The whole idea is not to have to use a pool of passwords for all systems and also to auto-start you log-in procedure and save waring off your precious fingers in typing useless usernames and passwords.

In this article I will show how to use keepass to auto-login to:

• Putty
• WinScp
• Toad
• SQLPLUS
• SiebelTools
• FieZilla

And from the examples above you would be able to use it with any command line tool as well.

You could also use it for keeping track of your web site usernames ,passwords and URL’s

It is available on Windows, Mac, Linux, Android and iPhone.

Read more »

Productivity : useful and dark corners of Excel

Everybody knows Excel. The world’s leading spreadsheet application. but do we really use it to do just spread-sheets editing or can we do more with it?

Excel could be used to Automate tasks, to analyze data and go beyond just creating reports.

In this article I try to expose some of the functionalities I mostly use in Excel as developer and production support staff at the same time.

Read more »