Oracle, the gift that keeps on giving

When using Oracle I sigh often (from the perspective of a database developer). Oracle have, by design, implemented instability into their execution plan costings. ...Read more

I am a fungible (don’t know the meaning?) resource

Human Resources - what a stupid name. It is almost patronising to think of someone as a resource, although admittedly it does feel ...Read more

I am not ‘On the spectrum’, I just expect consistency!

My first calculator was a Casio FX81. At the time for someone in their teens in the late 80's in NZ, it was the ...Read more

SQL Server Installation (end-to-end on new Ubuntu 18.04 Bionic Beaver Virtual Machine/Parallels on MacBook Pro)

Sometimes you get surprises while working in IT,  you follow a simple set of instructions and things work for example. Rewording that sentence ...Read more

Is the default response to work out something we already understand, or Google it regardless?

I have many email accounts. Some with spam and virus filters, some without, some personal, some for business, some as redirects from a couple ...Read more

Chemical Structures in Databases (blog article 7 of 8) : Under The Bonnet

As the SQL feature set doesn't provide for chemical structures to be queried directly as shown below, the chemical moiety must first be ...Read more

Chemical Structures in Databases (blog article 6 of 8) : Chemical Awareness

One of the many roles of IUPAC has been to establish and maintain systematic rules for the nomenclature of chemical entities. Within the ...Read more

Chemical Structures in Databases (blog article 5 of 8) : Subgraph Isomorphism

A mathematician might define subgraph isomorphism as the determination of a subgraph of a graph which is isomorphic to another graph. From the chemo-informatic ...Read more

Informatics RDBMS storage and manipulation of chemical moieties (blog article 4 of 8)

Over the past three decades, COTS products from major chemoinformatics solution providers have offered a number of technologies for the storage and manipulation ...Read more

Legacy System – You’re damned if ….. full stop

Within the past year or so, I have worked with an utterly shameful technology. It was initially marketed in the early 90's as ...Read more