A mid February blog…

A few ‘Valentine’ inspired jokes this week!

Why do melons have to get married in churches? Because they cantaloupe!

Why do skunks love Valentine’s Day? Because they’re scent-imental!

What’s the best part about Valentines Day? The day after when all the chocolate goes on sale.

And now for some of the best blogs, videos and articles of the past couple of weeks…

Blogs of the week

Why Data-Driven Applications (Rather than Open Source) are the Future of Agile Software

Matthew O’Keefe begins his article, writing, “The agile software manifesto was written almost 20 years ago. It’s signatories had scars from decades of dysfunctional software development projects and runaway software disasters that cost businesses and governments billions. Their manifesto created a sea change in how software was developed, and how the development process was viewed.”

Read the whole article here

2. Oracle Analytics Server is a reality! But watch out for the right FMW

Gianni Ceresa says, “Oracle Analytics Server was long-awaited, first expected to be released in December 2019, nothing happened and the silence and lack of info from Oracle made us imagine the worse.
The wait is now over and version 5.5.0 of Oracle Analytics Server is available for download on https://edelivery.oracle.com, searching for “Oracle Analytics Server”.

3. OAC 5.5 – Assigning a Map Layer to a Data Column

4. Where to build my OAC custom calculations, in Projects or under Data-prep ?

“Oracle Analytics allows any user to easily create custom calculations in data-visualization projects. It’s a simple process to extend your analysis or data-sets with any calculations and aggregations you may need right while you are building your Vizs, irrespective of the type of underlying data. One can build a custom calculation on a DV Project directly, or also, build it directly in the data-set using the Data-prepare tab.”

5. maxquerylen

Jonathan Lewis begins with, “The view v$undostat is a view holding summary information about undo activity that can be used by the automatic undo mechanism to deal with optimising the undo retention time (hence undo space allocation). The view holds one row for every ten minute interval in the last 4 days (96 hours) and includes two columns called maxquerylen and maxqueryid – which tell you something about the query that was considered to be the longest running query active in the interval.”

6. Ansible tips’n’tricks: defining –extra-vars as JSON

Martin writes, “While I’m continuing to learn more about Ansible I noticed a nifty little thing I wanted to share: it is possible to specify –extra-vars for an Ansible playbook in a JSON document in addition to the space-separated list of key=value pairs I have used so often. This can come in handy if you have many parameters in your play and want to test changing them without having to modify your defaults stored in group_vars/*.yml or wherever else you stored them. If you do change your global variables, you can almost be certain that your version control system notifies you about a change in the file and it wants to commit it next time. This might not be exactly what you had in mind.”

He also links to this documentation.

7. Classic Pagination

Quanwen Zhao says, “Today in this post I’ll use my annual report demo to do some SQL query of classic pagination on Oracle.”

He references ‘Are We All on the Same Page?‘

and Limit the Number of Rows in Oracle

8. 5 Minutes Demo: Using Liquibase in SQLcl to version Oracle Database

Jeff Smith shares this video: