Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: misc
Use the features available!
Advance warning: This post is a just another normal Friday morning rant. If you’re not interested in my pontificating, move along…nothing else to see here Sometimes you can’t make use of a facility that you normally would, and you have to substitute in something…
You need 10 minutes! Not 5, not 15, not 7
What follow is just my opinion….Well duh, it’s a blog, of course it’s just my opinion, but I’ll try back up my rantings and pontificating with some reasoned arguments. Whether at the end of it, you still call my claims total BS is of…
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/…
