Some of the best bits of 2019

Happy New Year!

Hope everyone has had a good break and is ready for all that 2020 will bring. Workwise and otherwise!

A few bad jokes to start off the year!

If at first you don’t succeed, call it version 1.0.


A wife send her husband an SMS on a cold winter evening: “Windows frozen”.

The husband sends the answer back: “Pour some warm water over them”.

Some time later husband receives answer from his wife: “The computer is completely broken now”.

And onto some of the best bits…

Some of the Best blogs, articles and videos from this Year 

1. Preparing a New Talk

Robin Moffat talks us through his process of preparing a talk/presentation right from start to finish

2. Automatic Indexing in 19c

A blog from Julian Dontcheff back in February. He says that Automatic Indexing is arguably the most interesting innovation in the database world for a rather long time!

3. Simple integration of Data Visualization in OBI Dashboard

Boris Dahav goes through 2 examples: Subject Area based and Data Source Based.

4. Parallel Madness 

Neil Chandler wrote this blog in March. He also links to How Parallel Execution Works.

5. Upgrade Oracle Restart to 18c

Liron Amitzi back in June wrote:

“It seems like there are not many Oracle Restart environments (or there are but Oracle doesn’t pay too much attention to them). Otherwise, I can’t explain why I couldn’t find too much information about it in the documentation when it comes to upgrades.

So, to help all of you out there that do use it, here are some notes about the upgrade process.”

He also links to documentation about Upgrading Oracle Grid Infrastructure

6. Oracle 19c: Auto-List Partitioning HIGH_VALUE Bugs fixed

Another one from June by Dani Schnider

He also links to ‘Raw Partitions’ by Connor McDonald.

7. A couple of Kscope19 blogs

Cameron Lackpour kept us posted on the action.

8. Some reviews of both UKOUG Techfest and UKOUG Analytics Modernisation Summit

A few blogs summarising UKOUG Techfest which took place in December and UKOUG Modernisation Summit back in October

9. Looking Back at ODTUG Kscope19 in Seattle

A video looking back at ODTUG Kscope19 in Seattle a full week of learning the latest Oracle content and products from the Oracle Analytics, APEX, Database, and EPM communities.

10. SQL mastery with the PARTITIONED outer join

Connor McDonald shares some Quick Tips: this is just one of them!


This week on Twitter

UKOUG tweeted Work Made Human: Oracle HCM Cloud

Mohamed Elemam shared Python cx_Oracle 7.3 for Oracle Database is on PyPI

Stories from , and

Videos such as:

Connect as a database user WITHOUT knowing their password!

Tools for Designing/Building Integrations | Tony Scalese