Presented at Quest Experience Week (QXW) – Database & Technology Day

At Oracle OpenWorld 2019, Oracle announced an Always Free Tier of cloud services. This session will review what’s available with these free cloud services such as Oracle autonomous databases including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP), compute with up to 2 virtual machines, storage including block, object, and archive storage. We’ll explore how these free services work and what can be done with them, such as creating proof of concept systems. Looking for data? No problem! We’ll explore the vast number of free data sources that are available and can be consumed using Application Programming Interfaces (APIs). Once we combine the two, we can easily pull data into these cloud services while creating fully functioning applications including the use of Oracle Application Express (APEX).

Quest Forum Digital Event 2020

Oracle Log Analytics Cloud Service offers an easy way to monitor, aggregate, analyze, and correlate log events from across your database and Exadata environment. In this session learn how DBAs can easily configure log collection and efficiently analyze logs from their database environment to rapidly troubleshoot problems. See how to use plain language analysis to easily find errors across different log sources. Experience the power of machine learning techniques to rapidly identify anomalies that can lead to a problem’s root cause and eliminate finger-pointing.

Quest Forum Digital Event 2020

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI.  We will explore how to leverage and integrate robotics & machine learning into your companies tech plan.  We'll show the state of robotics and how you can test and use this technology to create the future.

Quest Forum Digital Event 2020

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto Rest" enable a table and a PL/SQL package. Then, he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

The IOUG Cloud Computing (and Virtualization) Special Interest Group (SIG) is dedicated to communication and information interchange around the subject matter of Cloud Computing. The SIG provides a vendor-neutral perspective to the private and public database cloud and delivery mechanisms for Database-As-A-Service (DBaaS), Infrastructure-As-A-Serice (IaaS) and select Platform-As-A-Service (PaaS) technologies. Join us at this Cloud SIG session at Quest Forum Digital Event   Community Education Weeks for a panel discussion on the latest cloud technology topics such as Oracle Gen 2 Cloud, Database-as-a-Service, and Oracle Autonomous Databases Cloud service, etc. The panel will also discuss how the cloud may impact you and how your applications & databases along with your skills and career can adapt to the cloud age.

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