Diving


Being blessed by being Maltese, it was inevitable that a love for the sea would grow. Every Summer I would head off for the sea snorkeling. Then at the age of twenty I started the diving course and four years ago I started taking some underwater photography. My all time favorite was at the very beginning of a dive! We start descending, then for some reason I turn back to check on my buddy, Roberto! Click! A great shot is taken! Judge for yourself and comment!

Roberto’s Underwater Profile
Advertisements

Abseiling in Imtahleb


It was a chilly Sunday morning, we met at the Roman Villa, Rabat then headed off to Imtahleb. Roberto and myself secured the ropes, descended slowly to check the terrain and arrange the ropes. All was set and we descended a few more times! Really enjoyed it! First using the double-stop-descender, then a couple of times using figure of eights. Lastly we raced down the slope before we called it a day!

The rope setup for a beginner’s abseiling trial!
The view whilst abseiling at Imtahleb!
The track taken from top to bottom!
Roberto (left) and myself (right) starting our descent!
Roberto and myself racing to the end!

A very enjoyable Sunday morning!

Upper Barrakka, Valletta, Malta


Some of my favourite shots of the Upper Barrakka at Valletta, Malta as seen from St. Angelo, Birgu.

This slideshow requires JavaScript.

SQL for not registering employees for conflicting appointments!


I was once asked by a fellow colleague if it was possible to have an SQL statement that would not allow employees from being registered to events that occur simultaneously.

Scenario

Consider a database that stores a list of persons and a list of events. Employees would eventually be registered as event attendees. It is possible that multiple events occur at the same time and therefore it is required that the SQL statement prevent any persons from being registered as attendees of conflicting events. It was required that the solution be all in one SQL statement for some reason whatsoever.

The SQL solution is found attached together with a supporting report! As always all feedback and queries are welcome!

Register employees for non conflicting events

Filfla


One of my favourite diving sites is the Um El Faroud at Wied iz-Zurrieq and one of my very first shots with the new camera and underwater housing was as I surfaced from a dive. It was more luck than skill back then but yet a great addition to my collection.

Valletta Waterfront, Malta


I had just got hold of my new Canon Powershot A710 IS and headed down to the newly refurbished Valletta Waterfront around July 2007 and this was one of my very first shots! The waterfront was not yet bloated with restaurants and the real beauty of this site can be appreciated!

Oracle DBMS 11g Release 2


Out of sheer curiosity I had decided at the beginning of the year not to satisfy myself with Oracle Express Edition and started experimenting with Oracle 11g Release 2. It wasn’t long before I got it up and running on Windows systems and was able to administer it with ease thanks to the ample documentation found. The same can be said for installation on Red Hat Linux which is officially supported by Oracle. Being a little bit curious I wanted to test it on my two favorite operating systems, CentOS and Ubuntu.

Well it wasn’t all that easy and there isn’t much documentation for those OSs. I spent a lot of time reading various postings then testing and experimenting myself, documenting all along the way. Finally I managed to get Oracle working for CentOS 5.5, Ubuntu 10.10 and Ubuntu 11.04 with good documentation. This will be a continuous work in progress and will plan to keep updating it.

Today I found some time to fix the presentation of the document and decided that it is fine time to share it with the public. So here is the link in the way that I would have loved to have found it on the net: Oracle 11g R2 Guide

As usual all feedback is more than welcome!