Archive for the 'Tips & Tricks' Category

Self Signed SSL - work around to get rid of certificate error message

Previously I wrote about self signed SSL. The issue with self sign certificate is browser will display a warning stating that it may be an attempt to trick the user and that continuing is “not recommended”.

For a testing purposes, I add my hosts file with additional information:127.0.0.1 www.arejae.com.my ( this site not exist )
Interestingly Firefox [...]

How to program Gambas with MySQL in Ubuntu

I’ve read a nice introduction to Gambas here.Gambas is a free development environment based on a Basic interpreter with object extensions.
Since installing Gambas in ubuntu is a piece of cake, I then decide to try to program using Gambas. I found quite a number of article to do a connection with MySQL but then it [...]

Simple DOS command..yet still saves my day.

My friend send me a bunch of files where it have a sql scripts for each table. I need to combine all those files into one and later will be use to reverse engineer and analyze the tables.
Below are simple steps that I use to combine all those files using command prompt.
Create an empty [...]

The day when VLOOKUP saves her day.

Due to difference nature of work between me and my wife, I never had a chance to help her in her daily stuff related to her work and of course with my IT skills but for today, I’m happy to be able to help her.
She has a situation where she need to update [...]


AWSOM Powered