Committed vs. Uncommitted

This is probably a no-brainer for server experts. But I found out the hard way that if your company faces power-cuts on a regular basis, better not go with the default way of ‘uncommitted access’. The database rollback might just knock your records outta sync.

And for goodness' sake, watch what you do after a server downs. It's like a virus attacking your Norton. It attaches itself to the .exe program, you Quarantine or Delete it....bam! You've had it. Likewise with dealing with a dbase containing both 'committed' and 'uncommitted' data - it's a friggin' minefield. Delete, modify (or even copy) the wrong thing and you self-destruct.

There’s no straight-forward solution to top-quality database administration. It’s a balancing game all the way.