Stories from 2021
Oracle SQL – Querying columns containing CSV ID’s
Data modellers, developers, and purists all hate it when multiple ID values are stored in a single database column value. Data modellers hate ...Read more
Junk DNA – Junk Oracle, part 0000003 …. DROP TABLE IF EXISTS
Almost every week I write or enhance software components that are deployed into a PROD environment. Every week, the full-fat versions of the ...Read more
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
Oracle SQL – Querying columns containing CSV ID’s
Data modellers, developers, and purists all hate it when multiple ID values are stored in a single database column value. Data modellers hate ...Read more
Junk DNA – Junk Oracle, part 0000003 …. DROP TABLE IF EXISTS
Almost every week I write or enhance software components that are deployed into a PROD environment. Every week, the full-fat versions of the ...Read more
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
Archive
By Month: November 2022, October 2022, August 2022, February 2021, January 2021, December 2020, November 2020, March 2019, September 2018, June 2018, May 2018, April 2018
Categories
Apple, C#, Databases, Faircom, General IT Rant, German, Informatics, LINQ, MongoDB, Oracle, Perl, PostgreSQL, SQL, SQL Server, Unit Testing, XML/XSLT