July 05, 2010

Sqlserver Non-clustered indexes and deadlocks

ORM tools and other abstraction on RDBMS have become ubiquitous. But there is no substitute for understanding the basics of a database. This opinion of...

January 05, 2010

Mnesia Quickstart

Basic introduction on Mnesia Mnesia is a RDBMS. But it belongs to the nosql category of RDBMS. Reason being the query language is not sql but Erlang....

December 29, 2009

Jumping through hoops to represent trees in Database

Recently I have been working on a project where we have to represent hierarchical data in Database. Unfortunately we do not have much choice with the...

May 10, 2009

Document Oriented Databases

History Relational Databases have been the almost the only way applications persist data. In the days when code was written mostly with COBOL even...