Free

Securing DBA Scripts and Visualizing Storage and Performance

Event Information

Share this event

Date and Time

Location

Location

BC Liquor Distribution Branch

3200 East Broadway

Vancouver, BC V5M 3T5

Canada

View Map

Event description

Description

You are cordially invited to join the BCOUG at our next Vancouver event on January 24, 2018.


Session 1

Topic: Securing Your DBA Monitoring & Backup Scripts (SEPS & The Oracle Wallet)

Speaker: Simon Pane, Pythian

Abstract

All DBAs have OS and DB based scripts for performing tasks such as monitoring, backups, or application logic. However, are these scripts implemented as securely as possible without using some home-grown solution for DB credential management? Or are they a weak point or possible exposure in your organization's security implementation?

This presentation discusses how to use Oracle's "Secure External Password Store" (SEPS) and Oracle Wallet files to maximize the security of DBA scripts. Both SQL and RMAN based scripts are reviewed including those scheduled via OS tools such as cron and those scheduled from within the database using the new Oracle Database 12c Scheduler job types.

Issues and exposures with commonly used techniques and practices are identified. Then secure alternatives using SEPS and other security best practices are reviewed in detail with examples.


Session 2

Topic: Analyze Storage and Performance using Data Visualization Desktop 12c (DVD) - Like a BOSS !!

Speaker: Fahd Saeed, Red Pill Analytics

Abstract

Database administrators and storage architects have a lot on their plate. With a bevy of SQL queries in their back pocket, being responsible for a multitude of databases, why wouldn’t they want to create custom data visuals that tie all this information together, to either report on issues, performances, or perhaps brag about the uptime, space and capabilities?

Oracle’s newest data visualization tool, Data Visualization Desktop 12c (DVD), allows you to quickly connect to a number of datasets within minutes and produce sweet, succulent graphical charts (like a BOSS). In this presentation, we will take a look at quickly installing DVD, connecting DVD to SQL queries and CSV files to create visualization that you’ll be proud to show off within your organization.


About the Speakers

Simon Pane - Pythian

Simon Pane is an Oracle Certified Professional, Oracle Certified Expert, and Oracle ACE. Working with the Oracle database since version 6, his focus has been on High Availability, Monitoring, Backup & Recovery, Migration & Consolidation, and Security, and he has experience with literally thousands of database environments at hundreds of client sites.

Simon enjoys sharing technical knowledge and has presented at many user groups and at almost every major conference in Canada and the United States including Oracle OpenWorld and is a UKOUG speaker award winner.


Fahd Saeed - Red Pill Analytics

Fahd is a BI Consultant at Red Pill Analytics, based out of Salem Oregon. Plays with data integration tools and SQL for a living. Avoids getting seriously injured long boarding and skiing for fun.

Share with friends

Date and Time

Location

BC Liquor Distribution Branch

3200 East Broadway

Vancouver, BC V5M 3T5

Canada

View Map

Save This Event

Event Saved