Archive

January 31, 2014

Maximum Number of Columns Per Table – Mysql

Posted on January 31, 2014 by Suresh Kamrushi in Mysql

The maximum row size constrains the number of columns because the total width of all columns cannot exceed this size. For example, utf8 characters require up to three bytes per character, so for a CHAR(255) CHARACTER SET utf8 column,

Mysql Event Scheduler an alternative to cronjob.

Posted on January 31, 2014 by Suresh Kamrushi in Mysql

Mysql introduce Event scheduler which we can use alternative to Cronjob. There are many advantages over cronjob like:
1) It is directly written on Mysql Server.
2) This is platform independent. Your application might be written in any language it does not matters. You just need to know mysql.

Kirandul Passenger – Vishakhapatanam to Kirandul

Posted on January 31, 2014 by Suresh Kamrushi in Memories

It passes through Borra Caves and Arakku which are some tourist destination and almost train get vacant after this stations.

This train line passes through 84 bridges and 58 tunnels in first 3 to 4 hours journey.

PHP: Calculating Business days from given dates or for particular period.

Posted on January 29, 2014 by Suresh Kamrushi in PHP

PHP has numbers of datetime related functions which we can use to get Business day between two dates. Even if we have list of holidays we can also consider that for calculating.
Here is a simple example how you will get Business day in a particular period:

Dongargarh Trip with Friends

Posted on January 4, 2014 by Suresh Kamrushi in Memories

Dongargarh is one of the prominent pilgrim places in Rajnandgaon District of Chhattisgarh. It is about 35 km from Rajnandgaon and 67 km from Durg. Blessed with majestic mountains and ponds, Dongargarh has been derived from two words: ‘Dongarh’ meaning ‘mountains’ and ‘garh’ meaning ‘fort’.

Ambhora Nagpur Trip with SAICONS colleague on 2004

Posted on January 4, 2014 by Suresh Kamrushi in Memories

Had a good time with all my colleague at SAICONS at Ambhora, located 74 KM away from Nagpur.

NCC tracking camp @ Kolhapur, Maharashtra.

Posted on January 4, 2014 by Suresh Kamrushi in Memories

In year 2000, second year of NCC i got a chance to have Tracking camp at Kolhapur, Maharastra.