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).

It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER … Read morePaging records in MS SQL Server 2005

Setting up a web application on CentOS 5.3

Ingredients for our web application are Apache HTTP Server 2.2, PHP 5.2, Firebird 2.1and Oracle 10g Express Edition. Like in any IT project, not everything goes according to plan and there are so many pitfalls; some of which are: Repositories Linux Firewall SE Linux Permissions Using the package manager (Yum) to add, remove and upgrade … Read moreSetting up a web application on CentOS 5.3

Firebird SQL: The Power of Simplicity

Firebird SQL Server has always been a “proper” database system since it forked from Borland’s famous Interbase. I just love it! In some big database applications, I found that the developers preferred to duplicate a set of tables for probably performance reasons. For example, in most accounting databases, there is a notion of company so … Read moreFirebird SQL: The Power of Simplicity