Quest Forum Digital Event 2020

Setting up Cloud Environments using the Web UI is only the second-best option. The method of choice is Scripting. While HashiCorps Terraform has become the lingua franca for defining large setups, it appears to be a bit unwieldy for small changes. Oracle provides the OCI Command Line Interface (CLI) as OpenSource on GitHub, which is ideal for those small changes.

This talk introduces to Scripting with the OCI CLI. It walks through the process of setting it up. A quick orientation is followed by a deep dive in the command line and JSON Parameters. Tips and Tricks as well as common caveats an how to avoid them lead to the conclusion. The presentation contains a live demo. All Demos are available for download.

Quest Forum Digital Event 2020

Complex performance situations are not always quickly diagnosable using an AWR time-based analysis or an ASH sample-based analysis. And certainly, the diagnosis will not be completed the second new data becomes available or before a support ticket has been received!

A solution is to use a supervised learning classification machine learning model. We can train the model to recognize and "understand" a virtually unlimited number of Oracle performance and business-related data.

Once trained, we will present the model with just-available data asking, for example, if a support ticket will likely be submitted. Or perhaps, if the performance will likely be green, yellow, or red.

Join me as I build a "Poor Performance" indicator using 100% free industry-standard tools, such as Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!

Quest Forum Digital Event 2020

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information, and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self-service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
-Connecting Oracle databases in the Cloud or on-premises to chat services via REST
-Considerations for building database APIs to handle ChatOps interactions
-Methods for securing communications between the database and application
-Practical examples of ChatOps integrations

Quest Forum Digital Event 2020

Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of industry-leading database, Oracle Autonomous Database, eliminating human labor and error. For Database Cloud Services, Enterprise Manager helps DBA’s consolidate Databases or Infrastructure on OCI Cloud and also assess success of migration. Reap benefits from seamlessly transferred configurations, periodic synchronization of data with production, and “time travel” capabilities such as rewind/refresh. Join this session to learn more.

Quest Forum Digital Event 2020

Encrypting data at rest is a foundational strategy for any information security program. The security of your data depends not just on how complete the encryption is within database environment but also on how much security and control you have over the encryption keys. In this session, join Oracle Database security product managers to learn about innovations in Oracle Transparent Data Encryption including online migration from clear text to encrypted data. Hear about the latest innovations in key management including the new multimaster high-availability architecture for Oracle Key Vault. The session also features real-world customer deployment cases.

Quest Forum Digital Event 2020

Want to learn about Git? If you are thinking about using a Version Control System, this is a session you must attend, also this is a must-have skill for DBAs, Developers and Product Managers! Learn how we implemented this type of technology at CloudDB and how we are been beneficiate by it!

Learn all about Git and Oracle Developer Cloud Services and how to Streamline Team Development and Software Delivery using a SaaS solution.

You will be able to plan and manage: Issue tracking, Team management, Agile Dashboard.

With regards to code: Version management, code review, and track changes.

Plus build and deliver (continuous integration, orchestration, deployment automation) and finally team collaboration (activity stream, wiki, web dashboard).

Quest Forum Digital Event 2020

APEX Interactive Grids have a myriad of customization options, some declarative, and most via JavaScript APIs.  How to stay sane, organized, and consistent with so many options? Standardize!  Delivering clean, uniform, customized interactive grids within a single application, or across many developers, many applications across an organization is less difficult than you think.

We will demonstrate use of a common configuration file and classes to standardize grid features across your applications. Decide upon your grid options, code them once, then include and use everywhere. Better yet, not everyone needs to be a JavaScript expert to implement your standard grid configurations. Attend to learn how to standardize grid customization, and save on sanity.

Quest Forum Digital Event 2020

MySQL 8 introduced a new tool for DBAs. In this training session, we will explore the tool availability, installation, and usage. This tool is called MySQLShell and contains many features and  APIs that are very effective to manage the servers. MySQL/Oracle DBA can use this tool to explore the database using their Python/Javascript or Xconnector skills. This tool helps to download JSON documents to MySQL instance. We will go into details about many features that are very useful in daily DBA's tasks.

Quest Forum Digital Event 2020

The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality.  The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.

Quest Forum Digital Event 2020

Infrastructure as Code (IaC) is the only right approach in the cloud. We will discuss how to use the IaaC on your cloud environment and manage your Oracle cloud with Terraform, Packer, Kubernetes, and Resource Manager OCI services. In the presentation, we also going to touch some other cloud-related subjects like lifecycle, cost management and other sides of managing infrastructure and databases in the cloud.