Wednesday, March 12, 2014

MySQL Substring with Last index

Sometimes you may need to use substring in your queries to extract some parts of the values, specially from last index of the value. To achieve that you can use substring_index and reverse functions together.

Monday, February 10, 2014

Java keystore - Copy key from one keystore to another

One day you may need to isolate some of your key(s) to different keystore. Here is the command for it,

keytool -importkeystore -srckeystore mystore.jck -destkeystore myotherstore.jks -srcstoretype jceks -deststoretype jks -srcstorepass mystorepass -deststorepass myotherstorepass -srcalias myserverkey -destalias myotherserverkey -srckeypass mykeypass -destkeypass myotherkeypass

Here is my Scenario - Why I needed to do it? to be added..... :-)

Thursday, January 02, 2014

How to Create MicroSIM from standard SIM

As name says MicroSIM is smaller than standard sim, but chip is exactly same size in both cases. MicroSIM is 15 mm in height and 12 mm in width. So we can cut plastic area in order make it. Please be careful not to damage chip while you cut it.

Please use below pdf document for the MicroSIM template.

MicroSIM Template

Good luck...