Posted in Technology

Poor man’s full text search for SuiteCRM

The poor man’s CRM, a.k.a SuiteCRM …

Posted in Technology

MySQL Error: Thread stack overrun

Recently, I’ve come across this error …

Posted in Technology

Recursive Relationships in Databases

One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself.

Posted in Technology

To upgrade or not to upgrade XAMPP 1.7.3

XAMPP is just another package of…

Posted in Technology

Paging records in MS SQL Server 2005

After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).