Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: misc
When you screw up … make it positive for your users
Yesterday I was caught up in an interesting SNAFU at my local Supermarket. All of the checkout registers shut down, thus making it impossible to pay for groceries. Later on Twitter, the company apologized as we discovered it was actually a nationwide outage! …
TO_DOG_YEAR
Some members of the Oracle community got well and truly into the April Fools Day spirit this year. There were plenty of very earnest looking blog posts about a new 18c function – “TO_DOG_YEAR”. You can read their posts here http://www.oralytics.com/2018/04/predicting-ibs-in-dogs-using-oracle-18c.html https://blog.dbi-services.com/after-iot-iop-makes-its-way-to-the-database/ http://berxblog.blogspot.ie/2018/04/more-fun-with-ages.html http://vanpupi.stepi.net/2018/04/01/exploring-18c-exadata-functions/…
Trip down memory lane
I did a little video for St Patricks day, but it also brought back memories of my first computer experiences. A Sinclair ZX80, a Commodore 64, and many other machines that I thought were so cool for their time. Feel free to share your…
2017–what grabbed your attention
Here are the blog posts that you hit on most this year. Thanks for supporting the blog, and always, there will be more content next year ! ORA-14758: Last partition … cannot be dropped EXCHANGE PARTITION those pesky columns Pluggable database and restricted sessions…
Buffer cache hit ratio–blast from the past
I was perusing some old content during a hard drive “spring clean” the other day, and I found an old gem from way back in 2001. A time when the database community were trying to dispel the myth that all database performance issues could…
The devastating death PC emoji of doom
So there I am. Sitting at Perth airport. My flight from Perth to Sydney, the first leg on my trip to OpenWorld 2017 is delayed. Of course, delays are not unusual and do not normally bother me. Because I can just flip open my…
Top Ten Travel hints and Tips
Well, let me be honest right at the top here. These are not travel hints These will not help you in any way. This is me having a whine and a rant about a minority of people that I occasionally encounter when travelling….
The village idiot
If you are not familiar with the term Village Idiot, then Wikipedia provides a sufficient definition from which I can base this blog post. https://en.wikipedia.org/wiki/Village_idiot “The village idiot … is a person known for ignorance or stupidity” Over the past couple of weeks I’ve…
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/…
UKOUG 2016
Just a little video montage of the fun and learning from UKOUG. A great conference every year. I was fortunate enough to receive a Best Speaker award (from a 12c features talk given at the 2015 conference). I gave three talks, one of which…
Just one more week
I’m off to UKOUG again this year. It’s an awesome conference, and I’ll be doing three talks there. On Monday at 3:30 it’s my first keynote talk “12 Things You’ll Love About the Oracle Database 12.2”, followed up at 6pm by “AskTom –…
