Little Handy Tips

In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows. This is done using LIMIT and OFFSET. The examples in this article demonstrate how they work.

Here are examples on how to set the date and time on Solaris

Having a dual monitor set up on your computer has its fair share of benefits. It allows you to maximise the use of your monitor screen. It also cuts down time spent on shifting from one application to the other. Here’s how to set it up.

There doesn’t seem to be a proper way to upgrade from XCode 3 to XCode 4, so the best way to do this is to completely uninstall XCode 3.

I found that the best way to do this is by running the following command from a Terminal Window

sudo /Developer/Library/uninstall-developer-folder

Gone are the days when you have to store all data on a USB device, disk, or CD. Although these are good data storage options before, they have limitations. You will not be able to maximise the benefits of having a place to save all your data.