Tag: blog

Hack-a-Mongo

I was reading an article today about how 10,000+ Mongo installations that are/were openly accessible on the internet have now been captured by ransomware, with nearly 100,000 other instances potentially vulnerable to the same issue. Now, since I’m an Oracle blogger, you may be…

What you "liked" last year…

Well…when I say “liked”, what I mean is “the stuff you all clicked on a lot” last year. Whether you liked it or not will remain one of those great mysteries The top 6 posts from 2016 were: https://connormcdonald.wordpress.com/2015/11/25/ora-14758-last-partition-cannot-be-dropped/ https://connormcdonald.wordpress.com/2013/01/20/exchange-partition-those-pesky-columns/ https://connormcdonald.wordpress.com/2013/08/26/compressed-partitions-are-not-compressed-tables/ https://connormcdonald.wordpress.com/2014/04/12/pluggable-database-and-restricted-sessions/ https://connormcdonald.wordpress.com/2016/06/09/parsing-no-big-deal-eh/ https://connormcdonald.wordpress.com/2016/03/26/are-your-sql-plus-scripts-going-to-ell/…

A old story from the past

My own personal hell story was back in the late 1990’s, when moving database from one server to another.  We were recycling some of the hardware (disks and memory), so it was a unload-to-tape, reload-from-tape job. The servers were in Port Hedland (a rat-infested…

Resolutions for 2016

I remember at one of the first Mathematics lectures I attended at University, the lecturer demonstrated some principle (which I don’t recall, and certainly wouldn’t even comprehend now ), and then turned and said to the class: “Now THAT is a pretty exciting result”….

New Years Resolution–test cases

If the following email came across your desk “I have two tables EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) and DEPT(DEPTNO,DNAME,LOCATION).  When I join them I’m getting multiple rows for the same employee” my question would be – how would you proceed ? What is the first thing you need…

Oracle Developer awards…chosen by Developers

I was reading the following post today http://stevenfeuersteinonplsql.blogspot.com.au/2015/06/the-oracle-database-developer-choice.html Oracle are planning on rewarding developers in the following areas: SQL PL/SQL Oracle REST Data Services Oracle Application Express Database Design At first glance I had a bit of a cynical view…it could easily be one…

A new challenge…

After the last 16 years in the contracting and consulting world, for dozens of clients in Australia and other countries around the world, its time for a change of direction.  Whilst doing work with Oracle systems has always been (and continues to be) rewarding,…

Testing…the surgeon’s approach

I played a lot of volleyball in a bygone life 🙂 and subsequently ruined my knees to the extent that I needed surgery. I got a shock when the surgeon (after a series of x-rays and checks) said to me: “Of course, we’ll only…

A good day…

I work for a company that provides betting to consumers in Australia… In Australia, the three biggest days for betting are typically: Melbourne Cup (horse race) Caulfield Cup (horse race) AFL grand final (sports) Yesterday was the Caulfield Cup and we breezed through it…always…

from a friend…

A friend was recently describing Agile to me…I stress, not Agile the principle, but Agile the way its been implemented at their site…I thought I’d share it with you 🙂 [warning: profanity] “A few years back I was struggling financially, but I needed a…