Why did Mozart kill all his chickens?
Because when he asked them who the best composer was, they all said, “Bach, Bach, Bach.”
Did you know today was #ShowUsYourCode day? It’s a fun way to share the range of developer content that is being presented at Code One and let the community know if you are attending the event. Come and join in the fun on Twitter!
After you’re done, pop back here and read these blogs!
Blogs of the week
Andrejus Baranovskis writes that he will “describe step by step in this post, how to build TensorFlow model for text classification and how classification is done. Please refer to my previous post related to similar topic – Contextual Chatbot with TensorFlow, Node.js and Oracle JET – Steps How to Install and Get It Working.”
Bert Scalzo blogs, “Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed such as GDPR. This means that DBAs must up their game when it comes to database security.”
He writes about the following issues:
Misuse or Overuse of SYS
Misunderstanding the SYSDBA Privilege
Over-reliance on Predefined DBA Role
Implement Oracle Profiles
Christian Antognini begins this piece by writing, “In the last days, I am running a number of tests based on the TPC-DS benchmark against Oracle’s Autonomous Data Warehouse Cloud service (ADWC). One of the first thing I did is of course to create the TPC-DS schema and populate it. The aim of this blog post is to share some observations related to the population step.”
Christoph starts by saying, “The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud Infrastructure. Installing the CLI on your laptop can be done with the installer script pulled from Github, or you can install it manually, following the steps in the documentation.”
He concludes by writing, “While the OCI CLI may seem a bit daunting at first, once you get a hang of it, it’s not so bad. It can be used to quickly provision or change resources, without having to navigate through the web console. An alternative to the CLI is the REST API, which allows you pretty much to do the same things using REST commands.”
Deepak Vohra links to a software download link . He concludes his instructional blog by saying, “In this first of two tutorials, we introduced using Oracle JDeveloper 12c with Oracle Database by creating a connection in JDeveloper, creating a database table, and adding table data. In the 2nd tutorial, we shall discuss running a SQL query, using query result set features, dropping a table, and deleting a connection.”
Laurent shares his knowledge by writing a new series of blogposts related to python programming language and its interactions with Oracle.
He writes about:
- Work Environment
- Connecting to an Oracle Database
He promises that in a next blog post, he will present how to execute a basic statement with Python and Cx_Oracle.
Roy Salazar blogs, “Oracle’s Database Security Assessment Tool (DBSAT) is a nice and powerful free tool that performs Database and OS Security Audits and provides recommendations based on the findings. The tool and documentation can be downloaded from the following Oracle link (although an account with CSI will be required for the download).”
This article describes the “hands-off” installation of Oracle Database 18c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.
Simon Pane says, “From Oracle OpenWorld 2017 and subsequent Oracle announcements, it’s clear that Oracle currently has two key focus areas or messages:
- The Autonomous Cloud Database starting with the Autonomous Cloud Data Warehouse
There is plenty of attention on the first item as it is new and revolutionary in many ways. But the second area also deserves emphasis, as it is ubiquitous to databases.”
He concludes by saying, “Security should be on everyone’s mind and in the forefront of their activities. If it’s not already, it should be. And assessing security is an iterative process meaning assess, review, adjust, and repeat.
Oracle’s renewed focus on security and the updated DBSAT is a valuable tool to help us all in this area. Regardless of whether we have an old Oracle 10g database running on-premises or a brand new Oracle 18c cloud instance, DBSAT is a valuable asset. It’s reached a level of maturity where it doesn’t do absolutely everything most anyone could possibly want, but it definitely does provide enough functionality and value to make it a must-have for supporting any Oracle database.”
Andrejus Baranovskis shares the following slides:
This week on Twitter
Oracle Analytics shared this webcast
Steven Feuerstein posted a link to the blog, “Comments in RDBMS”
Matheus Boesing tweeted Oracle Streams: Adding a Table to Streams Replication
Videos such as:
BI Connector | Enabling Self-Service BI for OBIEE Using Tableau
Integrate Oracle PBCS (or EPBCS) to OAC