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

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

An exciting new feature of Oracle Database 18c and 19c is "Centrally Managed Users" (CMU). This, for the first time, allows for simple and complete database singe sign-on (SSO) and user management integration with Microsoft Active Directory (AD). No additional licenses required!

Previously, Oracle Enterprise User Security (EUS) and Oracle Unified Directory (OUD) were needed as an intermediate component bridging the Oracle Database to Active Directory. And while EUS/OUD is still present and does offer some additional features and benefits, it's no longer required for database-AD user integration and management.

This presentation details the advantages of using CMU over the previous technologies, covers the installation/set-up process, and gives practical examples and use cases for organizations to leverage and benefit from the simplified integration of database user management (authentication and authorization) with AD.

Quest Forum Digital Event 2020

How does database security change when you move to the Cloud?  Security does change and how to handle database security needs to change when running databases in the Cloud.  However, you still own your data and are still responsible for making sure that data is secure.  This session will first discuss the security differences for Oracle Databases between IaaS, PaaS, DBaaS, and on-premise. Advantages like enhanced database security features and disadvantages such limited infrastructure visibility are reviewed as they are present in all Cloud deployments.  Seven key components of an effective Cloud database security program are presented including how to effectively manage privileged, protect sensitive data, and monitor database activity.

Quest Forum Digital Event 2020

This presentation will focus on preparing for the Oracle 20c database and new features such as AutoML.  This presentation will also look at a few 19c/18c new features that should be in use now.  We'll look at how Machine Learning and Autonomous Database will change the role of the future DBA.

Quest Forum Digital Event 2020

Join a team of database and systems management experts from Oracle as they discuss the last new features and roadmap for Oracle Enterprise Manager, including options to deploy EM on Oracle Cloud and to manage the new Autonomous Database.  You’ll learn about the latest technology, best practices, and the future of Oracle’s flagship management offering.

Quest Forum Digital Event 2020

In this era where data privacy and security are a major concern, we managed to be compliant and safeguard ourselves by implementing various Oracle Security products and features. To address the needs, we have implemented Database Encryption, Backup Encryption, Database Vault, Audit Vault, GoldenGate Encryption, Data Masking, and several other security best practices. In this session, the attendees will have a clear idea about important database security products, their use cases, and applications and what we do to protect our database where compliance and data security is at the center.

Quest Forum Digital Event 2020

Powerful Machine Learning (ML) is now available to Oracle DBAs. Over the past few years, a number of changes have occurred making this possible. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible.

But there is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, are there real machine learning use cases for the Oracle DBA?

In this presentation, I'm going to introduce you to the world of ML from a DBA perspective! This includes understanding what ML is, why use it, and why now. The ah-ha moment will occur when you realize many of our monitoring, alerting, diagnosis, and analysis skills are significantly enhanced with ML.

I will demonstrate a simple yet complete ML project using 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

Oracle Database and Oracle Enterprise Manager continuously introduce new and interesting features that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new capabilities in Oracle Database and Oracle Enterprise Manager, such as Performance Hub, Automatic Workload Repository, multitenant enhancements, and many others. This session provides practical recommendations and real-world best practices on when and how to best use which feature, helping DBAs with day-to-day tasks.

Quest Forum Digital Event 2020

Your databases may contain sensitive personal data like Social Security numbers, credit card numbers, addresses, date of births, and salary information. Understanding in what tables and columns sensitive data resides is critical in protecting the data and ensure compliance with regulations like GDPR, PCI, and the new California Consumer Privacy Act (CCPA). However, sensitive data is like a weed and can spread quickly if not properly managed. The challenge is how to effectively and continuously find sensitive data, especially in extremely large databases and data warehouses.  This session will discuss methodologies and tools to find sensitive data such as by searching column names, crawling the database table by table, and performing data qualification to eliminate false positives.  Other locations where sensitive data might reside such as trace files, dynamic views (e.g., V$SQL_BIND_DATA), and materialized views will be reviewed.