NTFS Read/Write support on Mac OSX Lion


One of the first problems I encountered on my Mac was how to manage some external drives using NTFS. After reading a number of blogs, postings and articles I found the one by Sergey Vasilyev to be the best. The following is a quick guide to getting NTFS read/write support on OSX Lion.

  1. Tuxera MacFuse 2.2: Download Tuxera MacFuse 2.2 from here and install.
  2. NTFS-3G: Download NTFS-3G from here and install.
  3. fuse_wait: Update the fuse_wait script by downloading and installing the setup from here.

Next time you connect a storage device with NTFS you should be able to read/write from/to it.
Do note that there are a number of paid alternatives and a more detailed explanation can be found in the original blog of Sergey Vasilyev at http://blog.nolar.info/ntfs-3g-in-mac-os-x-lion-10-7-with-read-write-support/

ERD Modelling using Barker’s Notation


A key process in database development is obviously database modelling and the main diagrams used are ERD. A number of notations exist, some particular to evangelised by particular DBMS. Here I am documenting a short course/notes about ERD modelling using the Barker’s notation, which is greatly adopted by Oracle.

As usual here is the link, do feel free to comment!

Short notes on Barker’s ERD Notation

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

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.