Tag: Database & Technology

Quest Forum Digital Event 2020

The adoption of Kafka in enterprise is becoming more prevalent with the Oracle Database as being a common source/target. With the Kafka community talking about being an Event Streaming Database, Oracle DBAs are confused about exactly what Kafka is and what it can do that an Oracle Database can't do. In this session, Kafka will be compared to the Oracle Database through the lens of an Oracle DBA.

Quest Forum Digital Event 2020

SQLcl offers many ways to simplify your DevOps life. Imagine writing automation scripts for your database in languages like JavaScript, Python, or Perl - to name just a few - without the hassle of driver libraries. Although SQLcl is almost 100% compatible with SQL*Plus, it adds a lot of new commands and features to the old lady: Native support for Liquibase and Hashicorps Vault, for example. The most potent new keyword is "script." Script embeds the execution of SQL-statements or SQL*Plus-commands  from your favorite scripting language. Extend SQLcl by writing functions, use your favorite language’s objects and control structures and parallelize multiple tasks. Within this entertaining session, the presenting expert waters your mouth and generates countless wants.

Quest Forum Digital Event 2020

Application Express (APEX) continues to grow in popularity for application development, both for new business use cases as well as migration from older development technologies (e.g. PowerBuilder). But many developers and DBAs alike aren’t necessarily aware that APEX is now available within Oracle Autonomous Transaction Processing, a powerful self-contained set of Cloud-based database services.

This session demonstrates a real-life business scenario – the creation of a financial services/retirement planning application – that combines best practices for APEX development efforts with ATP’s simplicity to provide a stable deployment for hybrid OLTP and reporting workloads.

Quest Forum Digital Event 2020

Have you moved beyond just sending alerts and monitoring performance in OEM?  If not, learn the top 5 things that you should be doing to take your game to the next level.  Topics will include high availability, standby management, configuration management, and more!

Quest Forum Digital Event 2020

In this session join Oracle Database Product Management to learn more about using JSON in the Oracle Database. Learn about some of the new innovative ways that the Oracle Database can be used to load, store, and manage JSON and take advantage of the enterprise class features that Oracle provides so well.

We will also take a look into the unique Oracle Database features to leverage memory-persistent technologies for fast ingestion and retrieval of attribute-value pair data.  Other topics that are covered include the SQL language enhancements for complete flexibility and ease of use when working with JSON.

The session will also be discussing some of the enhancements being released in Oracle Database 20c for addressing the use of JSON.

Quest Forum Digital Event 2020

With Oracle's release of Autonomous DataWarehouse, Autonomous Database, and Autonomous Transaction Processing, we are entering a new era in database administration.  How is an old-school DBA supposed to survive in this brave new world of automation?  Are my existing skills obsolete? Am I out of a job? Never fear.  In this session, we'll discuss what exactly all this autonomous fuss is all about and what it will mean to the daily life of a DBA.  We'll draw comparisons to (soon to be legacy) tasks that all DBA's are comfortable with and how these tasks will be handled in an autonomous world.  We'll show you how to leverage your old school skills to be your biggest advantage in an autonomous world and position you to take your career to the next level in an Autonomous World.

Quest Forum Digital Event 2020

New DBA's hear stories from their experienced peers about databases being recovered from certain failure and the heroics involved, but what's the reason for those successes? One of the main tools, used by the savior DBA, is the Recovery Manager: RMAN. We're entrusted with our customer's data and the novice DBA has to know how to respond to database failures and recover from them. During this talk, the essentials of RMAN will be covered: concepts, setup, and usage scenarios. Afterward, with these resources in hand, attendees will have the preparation needed to start using RMAN.

Quest Forum Digital Event 2020

The most on-premises installations of Oracle databases are not using all available Oracle database packs and features. The reasons behind that could be different but one factor is always there and it is the cost. In Oracle cloud depending on service and edition, you may have a different set of features already included in the subscription. In such a case it is worth verifying and consider the new options since you are already paying for them.  And, who knows, maybe the availability of all those features will make migration to the cloud way more attractive and be one of the main drivers for your decision to move to the Oracle cloud.

Quest Forum Digital Event 2020

MySQL has made many security improvements and brought many security features that have taken MySQL Database Security to a new level. In this presentation, we will explore MySQL database security and the features that can be used to make your MySQL databases secure and house your most sensitive data with confidence.

Quest Forum Digital Event 2020

Red Hat Enterprise Linux and Oracle Linux continues to gain market share as a reliable 7/24 mission-critical enterprise server platform.  As a DBA in today's economy, you must possess both the system and database expertise.

Learn all the best practices for Red Hat/Oracle Linux 6 and 7 required to implement Oracle Databases in bare metal servers and in virtualized infrastructures.  Leveraging real-life experiences and techniques, learn from the author of the Linux Recipes for DBAs book by APress on how-to:
-Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments
-Setup and leverage a local Yum Repository
-Setup kernel and network parameters, shell limits, and file limits
-Setup Huge Pages / Disable Transparent Huge Pages
-Setup Jumbo Frames
-Configuring device mapper
-Oracle ASM Filter Driver, ASMLIB, ACFS configuration
-Setup correct partition alignment
-Create databases and ASM diskgroups in silent mode
-Automate installation of patchsets and patches
-Automate ORACLE_HOME cloning
-Create ASM instances in silent mode
-Setup rsync to synchronize file system from source and target servers
-Direct NFS
-Much more