Educational Workshop - August 11, 2016!

Here is where we post UNYOUG events. The latest three entries show up on the right side of the main page for registration.
Post Reply
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Educational Workshop - August 11, 2016!

Post by sam »

UNYOUG Educational Workshop Day
Thursday, August 11, 2016 9:00AM - 4:00PM (breakfast & registration start at 8:00AM)

Rochester Institute of Technology
134 Lomb Memorial Drive
Golisano College of Computing and Information Sciences
Golisano Hall (GOL) Auditorium & Atrium

Click here for area map. (Parking Lot J, Building marked "GOL")

Presentations:
Oracle INSERT Statements for DBAs and Developers
Dan Morgan, Forsythe Meta7

oRCAle World: Root Cause Analysis
Dan Morgan, Forsythe Meta7

Oracle Cloud & Ravello
Steve Van Hall, Oracle

Java in the Oracle Database
Chris Swanson, Paychex

The Evolution of Business Intelligence Data Architecture
John Korcak, Rolta AdvizeX

EMC Rack Scale Flash Storage
Matthew Morris, EMC / DSSD

Agenda:
8:00 - 9:00 Registration and Networking, Continental Breakfast

9:00 - 9:15 Welcome, Sam Brunacini and RIT Software Engineering

9:15 - 11:30 Dan Morgan topics

11:30 - 12:30 Lunch, Ravello

12:30 - 1:25 Java

1:30 - 2:25 BI Data Architecture

2:30 - 3:30 Flash Storage

3:30 - Raffles, wrap-up

Registration:
A continental breakfast and lunch will be provided. We need a count of persons attending to properly plan for this event. If you are planning to attend, please pre-register for the meeting here: http://www.unyoug.com/register.php.

Membership & Fees:
UNYOUG membership is $20 per year. The event is FREE to all, courtesy of Forsythe, Rolta AdvizeX, and RIT!
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Java in the Oracle Database

Post by sam »

Java in the Oracle Database
Chris Swanson, Paychex

Since 8i, Oracle RDBMS has included a Java Virtual Machine (JVM) that enables developers and DBAs to use Java inside the database. As Oracle’s commitment to Java has increased, so have the feature sets. We will begin with an overview of the Java architecture, the available features, and Oracle’s main selling points for the embedded JVM. We will demonstrate code examples of some of the features such as how to create and call Java stored procedures and how to make service calls from PL/SQL via UTL_DBWS. Finally, we will discuss some real world use cases from Paychex, some pitfalls, and the pros and cons of certain architecture decisions.

Chris Swanson is a Senior Software Developer at Paychex with 10 years of experience writing code for the full application stack, from database to UI. She is an Oracle PL/SQL Developer Certified Associate and an Oracle Database SQL Certified Expert.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Oracle INSERT Statements for DBAs and Developers

Post by sam »

Oracle INSERT Statements for DBAs and Developers
Dan Morgan, Forsythe Meta7

Everyone that has written SQL for more than a few weeks thinks they have mastered basic DML statements such as Insert, Update, and Delete: Unfortunately, this is not true. Most of the syntax elements available for these basic statements are not only unknown to developers, but are also unknown to DBAs with a decade or more of experience. This presentation will focus on optimizing DML by learning more about these capabilities. Using a laptop computer with a few GBs of RAM and a slow hard drive, it is easily possible to perform 500,000 inserts per second by taking advantage of documented DML techniques rarely used because they are little known and this will be live demo'd in SQL*Plus. This presentation will expose the full range of available Insert statements and how they can be used to optimize Oracle SQL performance.

Oracle ACE Director Daniel Morgan is the Morgan behind Morgan's Library on the web. He developed the Oracle curriculum, taught at the University of Washington for 10 years, also taught Oracle at Harvard University, guest lectured at the University of Oslo (Norway) and the University of Canterbury (New Zealand). Morgan is a frequent speaker at Oracle events around the world in EMEA, APAC, and the Americas including OpenWorld, Collaborate, and ODTUG Kaleidoscope.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

oRCAle World: Root Cause Analysis

Post by sam »

oRCAle World: Root Cause Analysis
Dan Morgan, Forsythe Meta7

Root cause analysis (RCA) is about finding the underlying issue that caused an Oracle database to crash or be unresponsive or a security flaw. Quite often events that look like a database issue are, in fact, the result of underlying issues with storage, network, and other parts of the stack.

This presentation by ACE Director Daniel Morgan will use real-world examples from recent years to demonstrate how to get past misdirection in alert log messages to ferret out the real cause.

Oracle ACE Director Daniel Morgan is the Morgan behind Morgan's Library on the web. He developed the Oracle curriculum, taught at the University of Washington for 10 years, also taught Oracle at Harvard University, guest lectured at the University of Oslo (Norway) and the University of Canterbury (New Zealand). Morgan is a frequent speaker at Oracle events around the world in EMEA, APAC, and the Americas including OpenWorld, Collaborate, and ODTUG Kaleidoscope.
Post Reply