Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: blog
You need scaling huh? Maybe it’s just ego
I’ve just come back from OracleCode Singapore. It was a great event – the venue was awesome and the attendees were engaged and interested in the content. But there was one thing that I found amusing (disturbing perhaps?) is the number of times I…
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/…
AskTOM Office Hours for DBA’s
We had the first AskTOM Office Hours Q&A for Database Administrators yesterday. Thanks to everyone that showed up, and thanks for the questions. If you missed it, you can catch a replay here
It’s not about ego … it’s about knowledge
Take a quick look at this blog post by Jonathan Lewis https://jonathanlewis.wordpress.com/2017/12/30/nvarchar2/ Anyone that has been working with Oracle for any length of time probably knows that Jonathan has a great depth of knowledge in the Oracle database, and is a regular blogger. But…
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…
Why being wrong can be awesome
OK, Now that I’ve started the post with a nice click-bait heading, let’s get down to the business of being wrong. I did a lot of conference presentations last year, and the great thing about that for me was that I got to meet…
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…
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…
The real question is … why are you NOT blogging
Colleague Jeff Smith published an interesting post the other day about his “rules and regulations” for blogging, but the overriding theme (Ed: – this is my opinion, I’m not speaking for Jeff) was that the “what” he blogs about was – anything he’s passionate…
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…
