Educational Workshops


 


RMOUG

Summer Educational Workshop

August 4, 2017 at Wings Over the Rockies Museum

Join us Friday, August 4, 2017 and soar through your morning with Oracle Ace Director, Rich Niemiec as we explore the changing horizon for Oracle Cloud and the New Features of Oracle 12c. Rich is a world renowned IT Expert and Chief Innovation Officer of Viscosity North America. After the technical sessions (presentation details below) continue networking with your peers over lunch.

Registration is required – Meeting, lunch and museum are free to RMOUG members attending the meeting. RMOUG welcomes anyone who would like to attend the meeting; for non-members attending the meeting the museum is free and lunch is available for $15.00. For family and guests having lunch the fee is $15.00 adult / $10.00 child.

After lunch walk alongside majestic former warbirds, a ¾ scale X-Wing Starfighter and a homemade helicopter, you can bring out your inner pilot with an unforgettable simulator experience too. Museum entry is free for all meeting attendees. For non-attendees, family, and friends; tickets are available for purchase at the museum box office. Ticket prices are Adults (17 – 64) – $12.50, Seniors (65+) – $9.00, Children (4 – 16) – $6.00, Children (3 and under) – free.


7711 East Academy Blvd, Denver, CO 80203

Museum Hours: 10:00am – 5:00pm

Front Desk & Store: 303.360.5360

 

Summer 2017 Meeting Sponsors

 

Agenda

7:30am – 8:20am – Registration Check-in

7:30am – 8:20am – Continental Breakfast

8:20am – 8:30am – Meeting Kickoff

8:30am – 10:30am Session 1: “Innovation, Oracle Cloud with Apps Case Study, Big Data and the Internet of Things, Preparing for the Future of IT” – Rich Niemiec in the Harrison Ford Theater

10:30am – 10:45am – Break

10:45am – 12:30pm Session 2: “The Best Oracle Database 12c R1 & R2 New Features” – Rich Niemiec in the

Harrison Ford Theater

12:45pm – 2:30pm –Lunch will be served in the Frontier Room

Note: Please sign up and register on the RMOUG Meetup page

Questions — contact Peggy King by email at peggy.king@rmoug.org

Copyright © 2017 Rocky Mountain Oracle Users Group, All rights reserved.

Members of the Rocky Mountain Oracle Users Group are automatically subscribed to our Membership Announcement List so they are kept up to date with the organization news and events. Please contact Peggy King at peggy.king@rmoug.org. with any questions.

Presentations:

Session 1:

8:30am – 10:30am Innovation, Oracle Cloud with Apps Case Study, Big Data and the Internet of Things Preparing for the Future of IT

This presentation will cover Oracle’s Acceleration, especially with the Oracle Cloud, and the Cycles of Innovation in the world.  We’ll look at a case study of an implementation of Oracle ERP Cloud Financials integrated with on premise Supply Chain Application.  We’ll then look at the current Acceleration of the Cloud, the Big Data Revolution and some of the Big Data Solutions out there including Oracle’s Big Data Solution.  We will review the role that both Google and Facebook have played in the Big Data Ecosystem and also how other NoSQL databases like Cassandra and MongoDB fit in.  We’ll then look at the Internet of Things (IOT) which will drive Big Data and the Cloud even Faster.  Lastly, we’ll briefly look at what the Future will bring with 64-bit and 128-bit (robotics/implants).

Session 2:

9:50am – 10:50am The Best Oracle Database 12c R1 & R2 New Features

This presentation will look at which 12c Release 1 and Release 2 new features should be investigated for use.  Some of the features that will be covered will be related to the DBA, but there will also those that focus on the developer.  There will be simple examples (such as a quick example using pluggable databases) to show the basic functionality of the new features:

 

– Invisible Columns

– Multiple indexes on the same Column

– Adaptive Execution Plans

– Runaway query Management

– Change Table Compression at import Time

– Create Views as Tables

– Online Move Partition

– Partial Indexes for Partitioned Table

Rich Niemiec – Chief Innovation Officer, Viscosity North America

ichard Niemiec Viscosity Rich Niemiec is the current Chief Innovation Officer of Viscosity North America. Rich is an Oracle Ace Director, a world renowned IT Expert, and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT as well. Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich has architected and tuned many Fortune 500 systems over the past 25 years.  His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is one of six originally honored worldwide Oracle Certified Masters and advised Oracle development from time to time. In 2017, he authored the Oracle “Oracle12c Performance Tuning Tips & Techniques,” an update of his previous 4 Oracle best sellers on Oracle8i, 9i, 10g, and 11i Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.


Date:   Wednesday, 31-May 2017 – 6:00pm to 8:00pm MDT

Location:    The Commons At Champa – 1245 Champa Street, 80204, Denver, CO (map)

Please RSVP at the RMOUG Meetup webpage HERE

Learn about…

Test Automation: Agile Enablement for Data Warehousing and Business Intelligence Teams

Presenters: Lynn Winterboer Co-Presenter: Cher Fox

Abstract:

Regardless of whether your data warehousing (DW)/business intelligence (BI) team is dedicated to Scrum, a fan of Kanban, or focused on XP, “Agile” in any form calls for small increments of potentially deployable results – which means that QA is essential on a regular, frequent basis. As we develop these small increments, we need to not only test the new development, but also regression test what we’ve already built. Our test suite grows larger with each iteration, and manual testing quickly becomes infeasible. Agile requires that we automate our tests so that regression testing doesn’t become a development bottleneck.

Test automation is one of several key technical enablement practices that allows teams to be more successful in their agile journeys. While there are lots of test practices and automation tools out there for software development teams to leverage, very few are targeted to data-related development and testing. Agile analytics practitioner Lynn Winterboer and DW/BI architect Cher Fox will share essential agile test foundations and data-focused test automation technologies to help data warehousing and business intelligence teams get a leg up on this important agile practice, including a demo of how this works!

Please RSVP at the RMOUG Meetup webpage HERE


Summer Quarterly

Educational Workshop

Friday, July 29th, 2016

 

Join us Friday morning as Janis Griffin from SolarWinds and Jim Czuprynski from OnX Enterprise Solutions guide us through the performance realm of Oracle. After morning sessions enjoy a lunch in the picnic area before exploring the many worlds that live “Under the Sea” at the Downtown Aquarium Underwater Adventure.

Registration is required – Meeting/lunch fee is waived for RMOUG members. For non-members, family and guests the meeting/lunch fee is $20.00 adult / $10.00 child. Contact Peggy at peggy.king@rmoug.org with questions.

After lunch if you would like to visit the Aquarium we have Discounted Group tickets available for purchase at the box office. Prices are Adults $13.95, Children (3–11) $9.95, Children 2 and under are free. When buying tickets please let the agent know you are with the RMOUG Group to get the discount.

700 Water Street, Denver, CO 80211
Aquarium Hours: 10:00am – 9:30pm
Summer 2016 QEW Meeting Sponsors

Agenda

8:00am – 8:30am – Registration Check-in
8:00am– 8:30am – Continental Breakfast – Sponsor OnX Enterprise Solutions
8:30am – 8:40am – Meeting Kickoff
8:45am – 9:45am“Analyze This! Practical Examples of Oracle Analytical Functions” – Jim Czuprynski, Onx Enterprise Solutions
9:50am – 10:50am“Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime”– Jim Czuprynski, OnX Enterprise Solutions
10:55am – 11:55am “Is Oracle 12c Making You Wait? Discover How to Identify, Prioritize and Solve the Most Important Wait Events” – Janis Griffin, SolarWinds
12:00am – 1:00pmOracle’s Adaptive Optimizer, Finally Learning from Its Mistakes!” – Janis Griffin, SolarWinds
1:00pm – 2:30pm – Picnic Lunch –  Sponsor SolarWinds

 

Questions — contact Peggy King by email at peggy.king@rmoug.org

Summer 2016 QEW Presentations:

8:45am – 9:45am “Analyze This! Practical Examples of Oracle Analytical Functions”

– Jim Czuprynski, Onx Enterprise Solutions

Session Abstract: If you’ve ever struggled with a particularly complex reporting request from an applications developer – for instance, returning just a specific set of rows from a subset of rows already extracted, or creating the equivalent of a Microsoft Excel pivot table, or producing a report with subtotals and subsections just like a spreadsheet – then this session is just right for you. We’ll demonstrate the basics of how to produce these complex output matrices with just a few calls to Oracle 12cR1 analytic functions and discuss how you applications developers (as well as Oracle DBAs) can leverage them for deeper insights into your database, and the performance of its application workloads. The presentation will offer real-world examples of how best to deploy these features, including detailed sample code that you can put to immediate use.

Objective #1: The attendee will understand how to leverage 12c Database’s analytic functions to create complex reports with less tortuous SQL, thereby potentially improving statement performance.

Objective #2: The attendee will discover how to apply analytic functions to obtain new viewpoints from the data hidden within the data, using everything from Big Data to database performance metrics as a target.

Click here to access the presentation.

 

9:50am – 10:50am“Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime”

– Jim Czuprynski, Onx Enterprise Solutions

Session Abstract: While many IT organizations appear to still be waiting for Oracle Database 12c Release 2 (12cR2) to migrate their pre-12c databases to the next version, it’s never too early to begin planning the best way to make that transition a reality. This session will therefore demonstrate real-world examples of how to use the latest database migration and upgrade techniques to quickly and safely move your pre-12c Oracle databases to Oracle 12cR1 … with some hints on even easier methods that are likely to be available in Oracle 12cR2.

Objective #1: The attendee will understand how to plan for an effective migration for pre-12c databases to a 12c database environment with minimum appropriate application down time – the “window of inopportunity” -while guaranteeing against the loss of any data during the migration process.

Objective #2: The attendee will be able to choose which migration mechanism – RMAN+TTS, XTTS, or CPT – is the best choice for migration her pre-12c database to Oracle Database 12c, and how to leverage each migration technique for an effective, safe migration regardless of differences between source and destination platform, database version, or OS.

Click here to access the presentation.

 

Jim Czuprynski – Strategic Solutions Architect, OnX Enterprise Solutions

Jim Czuprynski
Jim Czuprynski has over 30 years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies in those three before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features, presenting topics at Oracle OpenWorld, IOUG’s COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world. As of August 2015 Jim has joined OnX Enterprise Solutions as their Strategic Solutions Architect focusing on Oracle Database technology, especially Oracle Database 12c as well as Oracle’s Enterprise Systems, especially Exadata, SPARC Supercluster, and Oracle Database Appliance, and ZS3/4. Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at databasejournal.com and ioug.org. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle. His first book, Oracle Database Upgrade, Migration and Transformation Tips & Techniques, was published in June 2015 through Oracle Press.

 

10:55am – 11:55am “Is Oracle 12c Making You Wait? Discover How to Identify, Prioritize and Solve the Most Important Wait Events– Janis Griffin, SolarWinds

Session Abstract: There are over 1200 wait events in Oracle 12c, but there are only 10 (in my experience) that are seen often. If you can learn these 10 wait events, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait events to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

Objective 1: Learn the top 10 wait events
Objective 2: What are the causes of these events
Objective 3: How do you fix these waits

Click here to access the presentation.

12:00am – 1:00pm – “Oracle’s Adaptive Optimizer, Finally Learning from Its Mistakes!”

– Janis Griffin, SolarWinds

 

Session Abstract: With each new release of Oracle, the optimizer undergoes changes usually for the better, but sometimes there are unexpected side effects as well. This presentation will explore all of the new optimizer features, adaptive plans/statistics, and the changes to SQL plan management. Several case studies will show how it works, so you can quickly take advantage of the changes while making sure you remain stable in the transition.

Does your performance tuning need a 12-step program?

Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

  • Quickly fine tune a SQL statement
  • Identify performance inhibitors to help avoid future performance issues
  • Recognize and understand how new Oracle features can change and/or support different execution plans

Click here to access the presentation.

Janis Griffin – Database Performance Evangelist / Sr. DBA, SolarWinds

Janis GriffinJanis Griffin has over 25 years of Oracle DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds, Janis held DBA positions primarily in the Telecom / Network Industries, working with both real-time network routing databases and OLTP business to business applications. As an Oracle ACE, Janis has mentored other DBAs on best practices in database performance tuning. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

 

 

 

 


Spring Quarterly Educational Workshop
 Annual Membership Meeting
May 6, 2016

ID REQUIRED                                                                             $15 VISITOR FEE   FOR NON MEMBERS
Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Register Now Button
Questions please e-mail Peggy at peggy.king@rmoug.org

Meeting Sponsored by Oracle Technology Network (OTN)

Agenda:
8:00 am – 8:30 am            Continental Breakfast

8:30 am – 9:00 am            Annual Membership Meeting 

9:00 am – 9:15 am             Oracle Technology Network (OTN)
9:15 am -12:00 pm            Oracle Application Express Tutorial
  
12:00 pm – 1:00 pm          Lunch – (Room A & Room B)

Presentations:

9:00 am – 9:15 am           
Introduction to Oracle Technology Network (OTN)
Laura Ramsey – Oracle OTN

9:15 am – 12:00 pm          
“Building a Demo Project Application’ Hands-On Lab Workshop”
David Peake – Oracle Application Express (APEX) Product Manager

Abstract:
This tutorial for Oracle® Application Express release 5.0 (Application Express) demonstrates how to build a working application for managing projects and tasks using some of the latest features of Application Express 5.0. This exercise assumes no prior knowledge of Application Express.

This lab can also be utilized for migrating your application development from one environment to another, such as from on-premise to the cloud.

Scenario:
Your team tracks projects you are currently working on. Rather than using a spreadsheet or some commercial project tracking tool you have been tasked with building a Web application so that the team has a custom application that meets everyone’s requirements. The DBA has created a script which creates various tables and populates them with the current data.

In this first workshop you quickly build a simple application that allows everyone to maintian the data. There is also a second “advanced” workshop where you greatly improve the application and utilize a number of advanced techniques to make a very polished application.

Instructions:
1. Please sign-up for a work space on http://apex.oracle.com prior to the session.
2. Download the lab zip file: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-basic-demo-projects-2848024.zip (File available from http://apex.oracle.com/hols)

 

David PeakePresenter: David Peake, after 13 years within Oracle Consulting in Australia, New Zealand, and the United States, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager.

Within consulting his primary focus was on large Custom Development projects. Four years ago he started working on a very large project, using APEX (or Project Marvel as it was called then). Before that he primarily developed applications using Oracle Forms and Designer.

 

 

 

 

 


Rocky Mountain Oracle Users Group

November 12, 2015
Quarterly Educational Workshop
Oracle DTC Campus
7700 Technology Way,
Denver, CO 80237
Building 3 (North Building)
$15 visitor fee For non members
Question please e-mail Peggy at
mailto:peggy.king@rmoug.org

Registration and ID Required.
To Register Click Here.

 

8:00am – Continental Breakfast
9:00am – Start Meeting – Tim Vlamis
11:30am Lunch: Pizza

Test Drive Oracle Software

Powered by Amazon Web ServicesVlamis Software Solutions and RMOUG have partnered with Amazon Web Services to provide to you, free of charge, the opportunity to work, hands-on, with the latest of Oracle’s Business Intelligence offerings. By signing up to one of the labs below, Amazon’s Elastic Cloud Computer (EC2) environment will generate a complete server for you to work with.

The data warehouse experts of Vlamis Software Solutions have been invited to speak to us and bring their hands-on working labs for us to learn. Bring your internet-ready laptops. Can’t bring a portable computer? Not a problem. There will be laptops available for you to use.

These hands on labs are working with the actual Oracle software running on the Amazon Web Services EC2 environment. They each take approximately 2 hours to work through and will give you hands-on experience with the software and a tour of the features.

There will be an initial presentation on these topics then you can get started on the walk through of your choice. There MIGHT be time for you to do both! You can definitely take the materials with you and do the other from your office.

Business Intelligence Choices

OBIEE

This test drive will present a quick overview of Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and allow users to create reports and dashboards for themselves. The lab uses version 11.1.1.7.1 of Oracle BI and showcases the following features: adhoc reports, graphs, maps, and color-coding. In addition, this test drive will show you how to use OBIEE’s new map views to reveal location based patterns in business intelligence data sets. You will see how to create new map views, add chloropleth layers, add variable shapes, and display different measures at different zoom layers. You’ll learn how OBIEE can incorporate spatial analytics and integrate large geo-spatial data sets for location based analysis.

Big Data

Work with Oracle R and Big Data in this useful hands on lab. This test drive walks through some basic exercises on the Big Data Lite Virtual Machine. The Oracle Big Data Lite Virtual Machine provides an integrated environment to help you get started with the Oracle Big Data platform.

 

Tim Vlamis will start the meeting with a discussion on Oracle’s BI offerings and how these different components all fit together.

These labs will give you a background in Oracle Advanced Analytics (Oracle R Enterprise and Oracle Data Mining) and show how you can easily integrate results obtained using Oracle Advanced Analytics into OBIEE. Bring your computer along so you can work through the exercises with us in this Hands-On Lab.

If your BI application only reports the past, you’re missing out on a major goal of BI systems. BI systems should be forward-looking, so they can inform decisions. In order to do this, you need some sort of analytics, whether they be simple questions like where are we against plan or how does this compare to last year. Or they can be more complex, as in which customer segments provide the greatest possibility for our promotions or what would happen if we realign our territories in a different way?”

In this hands-on lab you will take a predictive model with an advanced R visualization from Oracle R Enterprise, register it for automated execution in the Oracle database, modify OBI repository to include both structured and unstructured data from R (the visualization), and publish the results on an OBIEE dashboard. In all, you will use RStudio, SQL Developer, BI Admin tool, and OBIEE Answers in this comprehensive session.

Tim Vlamis
VP & Analytics Strategist
Vlamis Software Solutions
tvlamis@vlamis.com

 

Tim Vlamis Bio:

An Oracle Ace and expert in the visualization of data and the design of business intelligence dashboards, Tim combines a strong background in the application of Oracle-based business intelligence (BI), analytics, and data mining with extensive experience in business modeling and valuation analysis. Tim co-authored Oracle Press book titled, Data Visualization for Oracle Business Intelligence 11g.

Tim leads the Oracle Advanced Analytics practice at Vlamis in the development of statistical and predictive analytics workflows and processes. He is an acknowledged contributor to Oracle University’s Oracle Data Mining Techniques and Oracle R Enterprise Essentials courses and often serves as an expert instructor for both. Tim’s international business experiences include leading partnership formations and dissolutions in Europe, Australia, Hong Kong, and Canada, negotiating acquisitions in Mexico and Canada, and leading the establishment of a new business entity in India. He earned his Professional Certified Marketer (PCM) designation from the American     Marketing Association and serves as an Adjunct Professor of Business in Benedictine College’s Traditional and Executive MBA programs. Tim earned an MBA from Northwestern University’s Kellogg School of Management and a BA in Economics from Yale University.

 

11:30am
Lunch: Pizza

 


Rocky Mountain Oracle Users Group
Elitch Gardens Theme and Water Park

Quarterly Educational Workshop
Summer Edition

Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204
August 7th, 2015
8:30am-1pm
Lunch Served After the Event!

Registration Required!
Please go HERE to register.
Question please e-mail Peggy at peggy.king@rmoug.org

 

Come join us at Elitch Gardens on Friday, August 07, 2015, for a morning of technical seminars, and an afternoon of fun, courtesy of RMOUG and additional sponsors. Bring your colleagues, bring your family, bring your desire to learn, and reboot.


Agenda:
8:30 am – 10:00 Family Coding-  Fun with Raspberry Pi!

Have the family join you and learn why technology is so cool! Bring a Raspberry pi to Elitches on Aug. 7th for great family coding event. Children 6-14, along with parents can enjoy learning how to build an FM radio station and other fun projects. A list of supplies and project catalog, along with times and details will be posted to RMOUG’s website a month before the summer Quarterly education workshop.
Tentative schedule will include demonstrations from Devoxx4kids, Lady Coders and Kids DevelopIt, too!

Here is the list of the items needed for the Raspberry Pi session:

Shopping list for the Raspberry Pi Coding Day:

  1. Raspberry Pi, Any Model:
    • A+ Version, $30
    • B+ Version, $47
  2. And a Pibrella Board, $20
  3. Standard accessories:
    • Mouse
    • keyboard
    • HDMI monitor

Provided at the Coding camp:  wires, motors, connectors and “accessories” to create our moving art display!

 

After the park opens, RMOUG’s QEW Oracle track will offer the following Enterprise Manager sessions from Kellyn Pot’Vin-Gorman, the Conusulting Member of the Technical Staff, SCP Team:


Presenter: Kellyn Pot’Vin-Gorman

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and was an Oracle ACE Director until joining Oracle as the Consulting Member for the Strategic Customer Program, a specialized group of Enterprise Manager Specialists. Kellyn is known for her extensive work with Enterprise Manager 12c, its command line interface, environment optimization tuning, automation and architecture design. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content. She is the lead author on a number of technical books, hosts webinars for numerous technical groups, including All Things Oracle and has presented at Oracle Open World, HotSos, Collaborate, KSCOPE, along with other US and European conferences. Kellyn is a strong advocate for Women in Technology, (WIT) citing education on topics regarding stereotypes and presenting opportunities early as the path to overcoming challenges.

10:00-10:30
Hybrid Cloning- The Journey to the Cloud and Back

Going to the cloud can be a scary journey for any DBA, but find out how to do it securely, safely and simply with Enterprise Manager 12c, release 5, (12.1.0.5.) Kellyn Pot’Vin-Gorman will take you through the newest and coolest feature in EM12c that enables a single pane of glass connection between your company’s choice in cloud provider and on-premise environments, allowing for a secure ability to clone to and from the clone. Learn how to secure sensitive data from prying eyes and how to architect a private and public cloud that meets your company’s requirements.

10:45-12:00 AWR Warehouse Mining Hands on Lab
This session is a hands on session for those that would like to learn more about AWR Warehouse mining!  Learn how to answer those all important business questions for the business without having to guess or assume.  Learn the value of having historical Automatic Workload History in a single repository.  Kellyn Pot’Vin-Gorman will guide the attendee through each step of the process of learning how to build our consolidation roadmaps, look at host level resource usage and other uses. The attendee must provide their own laptop that meets the following requirements:

8Gb of memory
Oracle Virtualbox installed
50Gb of space to house the stand alone image
Fully charged battery

The attendee will learn about the following in this session:

The AWR Warehouse schema.
Necessary joins and how to properly query AWR data.
Base queries to begin investigation
User stories to build queries that the attendee will need to answer.

Join us at Elitches-  learn about database technology, family coding technology and then hit the rides and enjoy the day with your family and RMOUG!

12:00 Lunch


Rocky Mountain Oracle Users Group


ID Required May 15th, 2015
Quarterly Educational Workshop
And Annual Membership Meeting

Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Please go HERE to register.
Question please e-mail Peggy at peggy.king@rmoug.org
Or call 303.929.6266

Sponsors: Dell Software, Solarwinds, Delphix
$15 visitor fee
For non members

8:00 am – 8:30 am Continental Breakfast
8:30 am 9:00 am Annual Membership Meeting and Board Elections
9:00 am – 10:00 am Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports
, Joe Monteith
9:00 am – 10:00 am Introduction to Wait Types and Response Time Analysis, Rob Mandeville
10:00 am – 11:00 pm TOAD Tricks and Tips, Brad Wulf
10:00 am – 11:00 am SQL Developer Tips and Tricks, Jeff Smith
11:00 am – 12:00 pm Implementing Data as a Service with Virtual Data, Derek Zunker
11:00 pm – 12:00 pm
Oracle12 New Features with Release 2 Updates, Dan Hotka
12:00pm – 12: 30 pm Lunch

Annual Membership Meeting and Board Elections

8:30 am – 9:00

Notice of our Annual Membership Meeting with 2015-2016 Board of Directors election proxies have been mailed to all current members. If you are unable to attend the Annual Membership Meeting to cast your vote in person, please complete the mailed ballot and proxy. Proxies must be received by 5/13/2015 to be included in 2015 Board of Directors election results. Please return your completed proxy by fax to 480-718-7557 or use the return envelope is provided.

Presentations

9:00 am – 10:00 am
Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports

This session contains tips & tricks on building financial reports that use best practices to reduce closing cycles, improve transparency, expedite reporting, streamline compliance, and increase efficiency using Hyperion Financial Reporting (HFR). The session is designed around individuals who support the reporting and financial close process including CFOs, controllers, senior managers, financial analysts and systems administrators.

9:00 am – 10:00 am
Introduction to Wait Types and Response Time Analysis

Using Response Time Analysis and Wait Types is a newer method for tuning Oracle instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using Oracle Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.

Rob Mandeville – Solarwinds

10:00 am – 11:00 am
TOAD Tricks and Tips

Abstract: Whether you’re new to Toad or a veteran user, Brad will show you tricks and tips to get even more from Toad’s time-saving functionality. You’ll also see firsthand how Toad 12.6 will make your job easier than ever.  In this session

  • Access the collective knowledge of the Toad community without leaving your work.
  • Get the most from Toad 12.6, no matter which platform you use.
  • Simplify business intelligence with Toad Data Point.
  • And much more.

Brad Wulf has held in numerous roles over the past 15 years within the Database world including Technical Support, Build Management, Development and Presales.  He is presently the Product Manager for Toad Extension for Eclipse, Toad for Mac, Toad for Hadoop, Toad for MySQL and SQL Navigator.

10:00 am – 11:00 am
SQL Developer Tips and Tricks

This session aims to arm every attendee with one or two new “tricks” that will dramatically save the amount of time it takes to accomplish daily tasks while working in Oracle Database with Oracle SQL Developer. Not only that, but they might learn how to have fun while doing it.

Whether you’re new to Oracle, new to the tool, or a veteran of both, the session can go as shallow or deep as the audience requires. Content includes topics that appeal to the technical analyst, business user, database administrator, and application architect/data modeler.

Jeff Smith is a senior principal product manager for Oracle, working on the SQL Developer team. His true passion lies in helping people maximize their productivity and retain sanity while working with database development and administration tools. You can get a pretty good idea of Jeff’s take on the current state of affairs in the world of Oracle and SQL Developer by reading his blog over at http://www.thatjeffsmith.com.

11:00 am – 12:00 pm
Implementing Data as a Service with Virtual Data. How can Virtual Data help your organization respond more quickly to business demands?, Derek Zunker

The agenda will cover Delphix data virtualization solutions to deliver DBaaS and entire environments more quickly and securely then making copies or clones. We will present how the data virtualization engine works as well as how customers have applied it for a number of different use cases. If time permits Derek will also demo Delphix tool.

Derek Zunker is the Delphix territory manager for the Rocky Mountain Region. Delphix helps industry leaders like Walmart, Wells Fargo, Cisco, Facebook, and Pfizer deliver higher quality application projects in half the time. Our solutions virtualize, govern, and deliver data on demand. Delphix transforms the process and economics of application projects to drive innovation.

11:00 am – 12:00 pm
Oracle12 New Features with Release 2 Updates

This presentation is a must-see for anyone supporting applications! The presentation will be broken into 4 parts:

  • Pluggable Database
    • How it works
    • Support
    • Problems
  • New SQL Syntax
    • New Analytical SQL Features
    • New SQL Features
    • New Options for Sequences
    • Enhanced Join Syntax
    • Increased column size limits
  • New PL/SQL Syntax
    • PL/SQL and SQL
    • Enhanced DBMS_UTILITY
    • New UTL_CALL_STACK
    • Enhanced DBMS_SQL
    • Enhanced Native SQL

Summary: Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s

Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.

Click here to access and download the presentation.

500 Eldorado Blvd


Rocky Mountain Oracle Users Group

November 21, 2014
Quarterly Educational Workshop
Oracle DTC Campus
7700 Technology Way,
Denver, CO 80237

Registration and ID Required.
Please Register here.

7:30am –   8:00am            Continental Breakfast
8:00am –   8:15am            Meeting Kickoff
8:30am –   9:30am            EPM Maestro: Making HFM Administration So Easy a Monkey
Could Do it
9:45am – 10:30am            Freeing DevOps with Data Virtualization
10:45am – 12:00pm           Oracle and the Future of Enterprise Management
12:00pm –  1:00pm            Lunch

Presentations

8:30am – 9:30am
EPM Meastro: Making HFM Administration So Easy a Monkey Could Do IT
Teresa Kress, Hyperion System Manager, Summit Materials

EPM Maestro: Making HFM Administration So Easy a Monkey Could Do It
Bogged down by the routine tasks that come along with administering your HFM environment? Don’t have enough time on your hands to get everything done? How about an extra pair of hands? Look no further than EPM Maestro! Attend this session to learn how the Hyperion Team at Summit Materials are utilizing EPM Maestro to automate all things HFM. From automatic consolidations to scheduled data syncs, come see how EPM Maestro can be your extra pair of hands for day-to-day HFM administration.

Speaker Bio: Teresa Kress – Hyperion System Manager, Summit Materials

After graduating UNC Chapel Hill with a degree in Finance and Accounting, I started my career working in financial consolidations and reporting in the mid-90s.  I worked for a Fortune 500 global manufacturer who utilized Micro Control (the DOS-based version of what is now HFM!).  In my 10 years with them I implemented 4 Hyperion Enterprise applications, HAL and numerous Essbase cubes while working my way through various financial analyst roles including an expat stint in France.  For the next 7 years I independently consulted at various U.S. based companies helping with HFM, FDM and Financial Reporting implementations.  After 7 years of traveling and consulting, I took an HFM Administrator job with Summit Materials, a heavy-materials and construction company headquartered in Denver.  I am currently the Hyperion Systems Manager at Summit Materials and oversee the team that supports HFM, FDM, Hyperion Planning and various 3rd party tools including EPM Maestro and Accelatis.

9:45am-10:45am
Freeing DevOps with Data Virtualization, Tim Gorman, Delphix

Abstract: Software development is caught in a squeeze. Application development, software maintenance, and good testing relies on copies or “clones” of production software and data. However, production environments keep getting larger and larger, meaning that the downstream “clones” either need to be larger and larger as well, or something has to be done to whittle it down to a “subset”. DevOps teams either have to buy more storage to accommodate larger copies, or they have to somehow acquire the software and techniques to “subset” to make the copies smaller, which is itself very tricky.

At the same time, businesses are demanding that the turnaround time for maintenance fixes and newly-developed code become smaller, and the concepts of agile development and continuous integration demand that fully developed and test code be pushed “live” not in years or months, but in weeks, days, and even hours.

So DevOps teams are forced to deal with bigger objects, and also deal with them faster, using fewer people and the same old infrastructure. It is almost as if magic is needed to extricate us from between this rock and a hard place.

Data virtualization using thin-provisioning technology is a solution. Products such as Oracle’s DBaaS SnapClone and Delphix will be discussed, both of which provide a solution to this dilemma, realizing the full promise of virtualization. Learn how these technologies work, and learn the use cases where they can be employed effectively.

What attendees can expect to learn:

1.What are the constraints DevOps face obstructing agile development and continuous integration?
2.How does thin-provisioning of storage (a.k.a. data virtualization) resolve the problem?
3.What are the most common use-cases for data virtualization in everyday DevOps?

Bio: Tim Gorman has worked in IT with relational databases since 1984, as an Oracle application developer since 1990, as an Oracle DBA since 1993, and managing/designing very large data warehouses on Oracle since 1994.  Mr Gorman is a technical consultant for Delphix (http://Delphix.com/) who enable data virtualization to increase the agility of IT development and testing. He is currently secretary of the board of directors of the Oracle Developer Tools Users Group (http://odtug.com/) and an advisor to the board of the Northern California Oracle Users Group (http://NoCOUG.org/) and the Northeast Ohio Oracle Users Group (http://NEOOUG.org).  Mr Gorman is past president of the Rocky Mtn Oracle Users Group (http://RMOUG.org/) and an advisor to Project SafeGuard (http://PSGHelps.org/) which provides legal advice to victims of domestic violence.

10:45am-12:00pm
Oracle and the Future of Enterprise Management
Rich Niemiec, Rolta
Rich Niemiec
This presentation will focus on Oracle direction including 12c New Features (including In-Memory Database), Engineered Systems, Big Data and IOT (Internet of Things), and the Future. We will look at 12c new features like the In-memory Database, Pluggable Databases, Multiple indexes on the same Column, and Other 12c New Features. Topics will also include a Big Data Overview, GFS and MapReduce early days, Hadoop, HDFS, and MapReduce in Open Source, NoSQL Databases, The Oracle Big Data Solution, Oracle Hadoop Data Loader and IOT.  We’ll also look at the Exadata hardware paradigm shift and some of the Oracle hardware advantages.

Speaker Bio: Rich Niemiec is a world renowned Oracle Expert and President of Rolta’s Consulting Practice. Rich is an Oracle Ace Director and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich currently serves as an Executive Advisor to Rolta International Board of Directors and has served as President of Rolta TUSC and Rolta EICT. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011 (Rolta). Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection. Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich is one of six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller “Oracle11g Release 2 Performance Tuning Tips & Techniques,” an update of his previous 3 Oracle best sellers on Oracle8i, Oracle9i, and Oracle10g Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.

Click here to access and download the presentation.

12:00pm-1:00pm
Lunch







Elitch Gardens Theme and Water Park

Quarterly Educational Workshop

Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204

Come join us at Elitch Gardens on Friday, August 08, 2014, for a morning of technical seminars, and an afternoon of fun, courtesy of RMOUG and additional sponsors. Bring your colleagues, bring your family, bring your desire to learn, and reboot.


Agenda:
8:30 am – 9:00 Registration and Continental Breakfast

9:00 am – 9:15 am RMOUG Business and Welcome

9:15-10:15 Performance Innovation with Database In-Memory
Enterprises are always looking for ways to make business decisions more quickly. Oracle Database In-Memory is a solution for accelerating database queries and enabling businesses to make better and faster decisions. Oracle’s unique approach leverages a new in-memory column store format to speed up analytic, data warehousing, and reporting workloads. Existing applications automatically and transparently take advantage of in-memory processing without requiring any changes or without losing any existing Oracle database capabilities. With Oracle Database In-Memory, everything just works faster. Learn more about the Oracle Database In-Memory option and how you can make better and faster database-driven business decisions.

Click here to access and download the presentation.


10:30-11:30 What’s New in Database Consolidation
Oracle Database 12c introduces a new multitenant architecture that offers greater utilization and scalability of server resources through simplified database consolidation onto private clouds. It fully complements proven database technologies such as Real Application Clusters, and effectively enables customers to manage many databases as one, without the need to change existing applications. In addition, Oracle Multitenant offers very fast provisioning and cloning of databases, rapid database patching and upgrades, and secure isolation of data. During this session, we’ll examine Oracle Multitenant in some detail and explain how this new architecture works.

Click here to access and download the presentation.

 

11:45 Lunch (Remember to invite your friends and family!)

Registration Required for all Attendees!


Rocky Mountain Oracle Users Group

ID Required May 16th, 2014
Quarterly Educational Workshop
And Annual Membership Meeting

**Hyperion EPM –  Special Interest Group**
Details Below

Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org Or call 303.948.1786

$15 visitor fee
For non members

8:45 am – 9:15 am          Continental Breakfast
9:15 am 9:30 am          Annual Membership Meeting and Board Elections
9:30 am – 10:30 am        Demystifying Hadoop for Oracle DBAs and Developers, George Trujillo

9:30 am – 10:30 am        Essbase Studio: Rapidly Unleash Physician and Revenue
Analytics in a Dynamic Healthcare Environment, Bill Mowle
10:30 am – 12:30 pm      An Overview of Hadoop Technologies and Finding that First Use Case, Jeffrey Needham
10:30 am – 11:30 am      Hyperion Financial Reporting: Tips, Tricks, and Best Practices, Tiffany Briseno
11:30 am – 12:30 pm      Making Workflow Work – Tips & Tricks on Leveraging Workflow to Manage Approvals, Joe Montieth
12:30 pm – 1:00 pm
        Lunch
1:00pm 2: 00 pm         Hadoop Expert Panel – What You Need to Know that the Books Don’t Tell you, Expert Panel

 

Presentations

9:30 am – 10:30 am
Essbase Studio: Rapidly Unleash Physician and Revenue Analytics in a Dynamic Healthcare Environment

Abstract: Given the rapidly changing Healthcare industry, now more than ever, the demand for information and analytics has never been larger. Come to this presentation to learn how Catholic Health Initiatives has been leveraging Essbase Studio to rapidly meet those demands. Learn how to create your first Essbase Studio model with step by step instructions on how to get started. Lessons learned will be shared to drive effective models for stakeholders both inside and outside of finance.

Bill Mowle
Director of Financial Management Systems
Catholic Health Initiatives (CHI)

10:30 am – 11:30 am
An overview of Hadoop Technologies andfinding that first use case

The Hadoop computational ecosystem is complex that is constantly evolving but isn’t
simply about databases, archiving or even map/reduce jobs. Hadoop is unique in that it is the first economically sustainable, computational filesystem. Hadoop is also a massively distributed OS kernel (with many of the service layers yet to appear). It is simultaneously powerful, proven, and yet immature enough as a data processing infrastructure that choosing the first few use cases is critical.

Many assume Hadoop is simply a different form of infrastructure, some think it is only for unstructured data and some think it doesn’t even work. However, deriving business impact from the structurally diverse forms of data requires taking a platform centric view, which insists the infrastructure, data science and, most importantly, the visualization must work in concert to deliver impact on the business. In some specific cases, Hadoop can be used to modernize aspects of infrastructure, but its greatest strength lies with unanticipated discoveries.

From this perspective, the session will cover the core componentry of (HDFS/job
scheduling) and how the variety of layered technologies can be weaved; using real-life use cases and anecdotes.

Jeffrey Needham is the author of Disruptive Possibilities, which provides a brief, yet historically informed overview of Big Data. He has been a member of the Red Hat
and Oracle kernel groups, as well as the platform continuity group at Yahoo! Jeffrey
provides use case and infrastructure workshops as well as CTO advisory services
startups, agencies and enterprises with remote, over-ocean, or global data processing challenges.

10:30 am – 11:30 am
Hyperion Financial Reporting: Tips, Tricks, and Best Practices

Abstract: There are those who say that the reports in Hyperion Financial Reporting cannot be sped up. They are the speed they are, and it’s all based on how much data you’re seeing in the reports. While the number one thing you can do to speed up your reports is to speed up your data source, there are at least 10 major things you can do to speed up your report itself. Come learn these tips along with the hot features in 11.1.2 that will improve and speed up your FR reports.

Tiffany Briseno
Financial Systems Principal Analyst, when at TeleTech
Currently works for Summit Materials

11:30 am – 12:30 pm
Making Workflow Work – Tips & Tricks on Leveraging Workflow to Manage Approvals

Abstract: Would you like to improve your forecasting process and protect workflow integrity? In this session, we will cover the new workflow and approvals available in Planning. We will discuss various approaches to the approval process and using planning unit hierarchies to manage multiple end users entering forecast and budget data. We will cover different types of planning unit hierarchies including limitations with certain versions, best practices, annotation reporting, group ownership, and out of office assistant.

Joe Montieth
Senior Consultant
The Bean Consulting Group

500 Eldorado Blvd

 


 

Pizza being sponsored by DBAK

 

 

 

 

Don’t miss out on the last Quarterly Educational Workshop before Training Days

 

November 15, 2013

Regis – DTC Campus

6380 South Fiddlers Green Circle, Suite 200

Englewood, CO 80111

Registration Required!

Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

$15 visitor fee for non members

 

 

 

 

 

8:00 am – 8:15 am             Continental Breakfast
8:15 am – 9:15 am              Deploying and Developing Application Express with Oracle Database 12c
9:25 am – 10:25 am            DBaaS- Database as a Service in a DBA’s World
10:35 am -11:35 am            Considerations for Enterprise Mobile Application Development

Hyperion SIG

11:45 am -12:45 pm            Relaxed Reporting with Hyperion Financial Report

 

Presentations
 

8:15 am – 9:15 am
Deploying and Developing Application Express with Oracle Database 12c
David Peake, Product Manager @ Oracle
 
Learn how you can take full advantage of the new Oracle Database 12c Multitenant Architecture with various deployment options for Application Express. This new architecture provides great flexibility and will change the way you manage your Application Express environments for development, test and production. This session will also cover new capabilities defined within Application Express to take advantage of other Oracle Database 12c features.

 

9:25 am -10:25 am
DBaaS- Database as a Service in a DBA’s World
Kellyn Pot’Vin, Sr. Technical Consultant and Oracle ACE Director @ Enkitec
 
DBaaS, (Database as a Service) is a newer EM12c cloud feature that has many DBAs scratching their heads and wondering what it’s all about and how it fits in their changing world as we head to the cloud. DBaaS, especially with Database 12c will have DBAs focus less on building databases,  but more on managing cloud environments. The DBA will only set up resource allocation, privileges and limits for users to request databases via the EM12c Self Service Portal. This session will offer the DBA the opportunity to get a clear view of this important aspect of our future in the cloud.

 

10:35 am -11:35 am
Considerations for Enterprise Mobile Application Development
Greg Opie, Director Solution Architecture, ECS Team
 
Mobile applications are widely accepted and used by consumers on smart mobile devices and the trend is rapidly moving into enterprise applications as well. However, the mobile application itself is only part of the solution. This presentation will cover important considerations for mobile development, from the mobile application through middleware and to the source application, followed by examples of projects developed with Oracle SOA Suite and Oracle ADF Mobile.

 

11:45 am – 12:45 pm
Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports
Joe Monteith, Consultant, The Bean Consulting Group

Would you like to meet complex HFR reporting needs in a sustainable and maintainable manner? If so, this session is for you. You will learn best practices in financial and regulatory reporting, the value of using math and text functions to build complex conditions and the power of conditional formatting and suppression. We will discuss 13-month rolling balance sheets, butterfly income statements, and how to leverage report objects to reduce maintenance.

 


August 9th, 2013 Presentations

Oracle Technology Day: Plug into the Cloud with Oracle Database 12c

Plug into the Cloud with Oracle Database 12c

Click here to access the presentations from the Oracle Technology Day: Plug into the Cloud with Oracle Database 12c!


AUGUST 09, 2013

Come Learn and Play at the Next

Quarterly Educational Workshop

Elitch Gardens Theme and Water Park

2000 Elitch Circle Denver, CO 80204

This year RMOUG has partnered with Oracle and Intel to bring you the latest on 12c

Please join us on August 9th.  Don’t forget to bring the family along for $15.00 (each)

$15 for Parking ($20 VIP)

Play hooky from work!

(shhh, don’t let the boss know)

Instead, tell the boss about the great speakers presenting in the morning.

Heck, invite the boss!

It’s the end of summer, and what better way to celebrate than to spend the afternoon networking with other RMOUG members and their families?

Registration Required! (Please register by August 2nd so we can order food)

Register Here

Questions please e-mail Heidi at admin@rmoug.org or Carolyn at programsdir@rmoug.org

Discover the Latest Breakthroughs!

Oracle Database 12c is here, complete with over 500 new features. Join Oracle and Intel at Oracle Technology Day to see firsthand how this new multitenant architecture makes it easy to deploy and manage database clouds.

Oracle experts will be on hand to provide a comprehensive overview of this new release. And your peers will be there to share perspectives on the impact of the latest breakthrough in Oracle. You do not want to miss this exclusive event, where you will learn how to:

Simplify database consolidation

Automatically compress and tier data

Improve application continuity

Redact sensitive data

Agenda

TROCADERO ROOM
8:00 am Registration and Continental Breakfast
8:30 am Keynote: Plug into the Cloud with Oracle Database 12c
9:15 am Security Inside Out‚ Latest Innovations in Oracle Database 12c
9:55 am Break
10:05 am Maximize Availability with Oracle Database 12c
10:45 am Automate Information Lifecycle Management with Oracle Database 12c
11:25 am Break
11:30 am Simplify Consolidation with Oracle Database 12c
12:10 pm Networking Lunch
1:00 pm Drive Database as a Service with Oracle Exadata
1:40 pm Managing Oracle Database 12c with Oracle Enterprise Manager 12c
2:15 pm Theme Park Fun


Rocky Mountain Oracle Users Group

 

 ID Required  

 

 

**Hyperion EPM –  Special Interest Group**

Details Below

 

May 17th, 2013
Quarterly Educational Workshop
And Annual Membership Meeting

 

Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org Or call 303.948.1786

 

$15 visitor fee
For non members

 

 

7:30 am –   8:15 am          Continental Breakfast
8:15 am    9:15 am          XML Processing with Oracle 11g
8:15 am –  9:00 am           A Leap of Faith: Upgrading a Hyperion Environment at Catholic Health Initiatives
9:25 am  –  10:25 am        Three Types of Table Compression
9:10 am –  9:55 am            Using EIS and EAS to dynamically refresh Essbase cubes

10:05 am – 10:50 am        Hyperion Tips & Tricks for Maintaining a Steady and Proficient Environment

10:35 am – 11:35 am       
The new 12c kid on the block
11:00 am – 11:45 am        OBIEE and Essbase Jointed at the Hip
11:45 am – 12:45 pm
        WIT Session:  “The Imposter Syndrome- When Successful Women Feel Like Frauds”
11:55 am – 12:40 pm        Implementing EPM and Tri-State Generation and Transmission
Lunch to introduce the WIT members 11:45 am during Kellyn’s session
12:45pm   1: 55pm            Board Meeting (open to all members), Board Elections and Annual Membership

 

Presentations

8:15 am – 9:15 am
XML Processing with Oracle 11g
Don Schaefer, Ingenix,  Senior Software Engineer

With the introduction of Oracle 11g, Oracle has released new versions of three applications utilized for XML Processing:  Oracle XML Developer Kit 11g, Oracle XML DB 11g and JDeveloper 11g.

Specifics for the presentation.

  • Oracle XML Developer Kit 11g Release 2.  XML Parsers using industry standard DOM and SAX interfaces.  Java, C++ and the Java API for XML processing.  XSL Processor.  XML SQL Utitlity
  • Oracle XML DB 11g Release 2.  Oracle XMLtype Datatype, XMLQuery, XMLTable, Full Text Search over XML Data.
  • Processing XML Documents with Oracle JDeveloper 11g Release 2

 

8:15 am – 9:00 am
A Leap of Faith: Upgrading a Hyperion Environment at Catholic Health Initiatives
Ross B Kimball, Manager, Financial Systems Integration, Catholic Health Initiatives

The challenges of upgrading from 9.3.1 to 11.1.2.1 are many, but there are none that can’t be overcome.  Some of the challenges are substantial, such as the migration from EAS to Calc Manager, or the migration of the user community to the new SmartView.  And some challenges are more subtle such as the migration of Planning forms and Financial Reports.  My presentation will guide users through some of our key lessons learned during the upgrade, and detail out what I consider to be best practices for any Hyperion upgrade.

 

9:25 am – 10:25 am
Three Types of Table Compression
Tim Gorman,  Independent Consultant, Evergreen Database Technologies, Inc.

There are several types of table compression in Oracle database, and so the question must arise: which are most appropriate, based on what requirements? Why are there different methods, which ones work for what situation, and why?

We will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well as some older often-forgotten techniques for fitting more data into less space. The presentation will begin with a brief review of data compression in general, followed by a review of the formats used for storage in database blocks and rows, the latter supported by block dumps. All leads to a knowledgeable discussion of the advantages and disadvantages of each type of table compression in Oracle.  At the end, we get to the subject of the talk, which is a form of compression which has always existed within Oracle database, but which can only be exploited when you know how data is stored internally.

 

9:10 am – 9:55 am
Using EIS and EAS to dynamically refresh Essbase cubes
Qingchen Chen, Hyperion Applications Analyst, Berry Petroleum Company

Berry Petroleum Company uses Essbase cubes for reporting on Financial, Capital Spending and Production data. We need to refresh all 3 BSO cubes automatically each night. EIS (Essbase Integration Services) is used to refresh Essbase outlines from Oracle source. Load rule is used to load data to Essbase via SQL interface. Automation is scheduled via MAXL scripting.

 

10:05 am – 10:50 am
Hyperion Tips & Tricks for Maintaining a Steady and Proficient Environment
Lester Trough, Senior Consultant Manager of IT and Support, Abeam Consulting

With the complex nature of Hyperion come a variety of issues which often lead to poor performance which will plaguing your Hyperion environment, along with your end users and IT department. In this presentation we will show you a few key tips & tricks which you will be able to implement within your Hyperion environment to enhance performance. 

10:35 am – 11:35 am
The new 12c kid on the block
Peter Sharman, Oracle, Principal Product Manager

This presentation introduces the new Oracle Database 12c functionality

 

11:00 am – 11:45 am
OBIEE and Essbase Jointed at the Hip
Sohel Jeelani, Sr. Sales Consultant, Oracle

 OBIEE has been supporting Oracle Essbase as a physical data source since the early 10g versions but now the integration between the two has become seamless. Going forward Oracle intends to tie them together even tighter so that BI content that can be deployed to a broad user audience through Oracle BI Dashboards, Analyses.

 

11:45 am – 12:45 pm
WIT Session:  “The Imposter Syndrome- When Successful Women Feel Like Frauds”
Kellyn Pot’Vin, Enkitec, Senior Technical Consultant

What is Imposter or Fraud Syndrome?  Why people feel this way, (source of the feelings).  How to deal with situations to ensure fraud syndrome doesn’t impede a women from her goals.

The popular and successful actress Tina Fey, Facebook COO and author Sheryl Sandberg, among others, have all admitted to experiencing this. Research has shown, men often judge themselves consistently as performing better than their actual performance and women do the opposite.  Georgia University psychologists, Pauline Rose Clance and Sue Imes started to use the term “Imposter Syndrome” back in 1978 when referring to those that were susceptible to this, but recognized women suffered from it more often.  Why do highly successful women feel like imposters or frauds?  This session will discuss how women can overcome and deal with the feelings involved with this phenomenon to keep it from holding them back in their goals.

 

11:55 am – 12:40 pm
Implementing EPM and Tri-State Generation and Transmission
Marisa Gregorio, IT Applications Development Manager, Tri-State Generation and Transmission

Tri-State, a long-time customer of Hyperion Pillar, discusses the evolution from an annual budgeting process, to a monthly forecasting model.  Hear about the why the company moved to a 20-month forecast, the challenges in implementing such a change, and the future direction this utility company is heading with its EPM solutions.

 

500 Eldorado Blvd
Show on Google Maps

 

 

 


 

 

 

ID Required

 

 

 

 

Don’t miss out on the last Quarterly Educational Workshop before Training Days

PIZZA is being sponsored by ECS Team for lunch

November 16, 2012

Oracle – Campus

7700 Technology Way

Denver, CO 80237

Building 3 (North Building)

Registration Required!

Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

 

$15 visitor fee
For non members

 

 

                                                                             

7:45 am – 8:15 am              Continental Breakfast
8:15 am – 9:15 am              Essbase Calculations – Observations from the Road
9:25 am – 10:25 am            Sherlock Holmes for the DBA
10:35 am -11:35 am            Introduction to SOA and Oracle SOA Suite
11:45 am -12:45 pm            CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
12:45 pm – 1:45 pm            Board Meeting

 

Presentations

 

8:15 am – 9:15 am
Essbase Calculations – Observations from the Road   
Chris Chase, Managing Partner @ The Bean Consulting Group

With nearly 25 years experience in software and database technology I thought I had seen all that programming had to offer; then I discovered Essbase.  Learn some interesting observations regarding Essbase calculations accumulated over nearly 10 years of Hyperion implementations.  We will discuss aggregations, allocations, eliminations, and driver-based calculations, commands and functions specific to Hyperion Planning, and some of the more confounding aspects such as block creation and cross dimensional operators  

 

9:25 am -10:25 am
Sherlock Holmes for the DBA
Kellyn Pot’Vin, Senior Technical Consultant @ Enkitec

 The DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often the administrator is expected to, not only identify, but also correct the problem without impact and in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.

Attendees will leave the session with a better understanding of trouble-shooting techniques and when to use what features, tools and reports to address issues.

 

10:35 am -11:35 am
Introduction to SOA and Oracle SOA Suite
Brian Statkevicus, Senior Consultant @ ECS Team and Greg Opie, Director of Architecture @ ECS Team

Almost everyone has heard of Service Oriented Architecture (SOA).  Some people can accurately describe what it is and isn’t.  This introductory session will cover:

•              What is SOA?
•              What are the business problems solved by implementing SOA?
•              Oracle’s SOA Suite
•              Demo of a sample business process using SOA Suite
•              SOA Case Study

 

11:45 am – 12:45 pm
CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
Bradley Brown, CEO/CTO @  InteliVideo

There is a considerable amount of free geo-spatial data available from the government and open source groups.  This information can be quite helpful at providing more information about location-based data.  For example, if you’re a property management company and you wanted to know close each of your properties are for anything from grocery stores to railroad tracks to flood plains, all of this information is available.  If you wanted to know which homes are on a specific golf course, this data is available for free too.

In this presentation, Brad will share what geo-spatial data is available, where you can download the data, and what you might use the information for.  You can also create your own layers of information and merge this into your queries.  All of this can be done using an Oracle database (even the free version of Oracle) – i.e. without a mapping tool like ESRI.  You can easily overlay this information onto Google maps or Google Earth.  Brad will share PL/SQL code that will extract shapes into KML

 

 


View Larger Map

7700 Technology Way
Denver, CO 80237

 



 

 

August 17th, 2012

Come Learn and Play at the next

Quarterly Educational Workshop

Elitch Garden Theme and Water Park

2000 Elitch Circle Denver, CO 80204

Registration Required by August 7th, 2012

Free PARKING for first 100 members to sign up

Members Click Here To Register!!

Non-Members Click Here To Register!!

          

                                                                                       

 TROCADERO ROOM

8:00 am –   8:30 am           Continental Breakfast

8:30 am –   9:30 am           APEX Admin and Install Tips and Techniques
9:50 am –  11:50 am          How ASH works and how to use it

 LONG PEAK PAVILION
11:00 am – 3:00 pm           Pavilion Available

11:30 am – 2:30 pm            Snack Baskets/Drinks served

12:00 pm – 2:00 pm           Lunch Served

1:00 pm                                 Raffle Drawing

 1:15 pm – 2:00 pm              Board Meeting

 

RMOUG Members: no cost

All additional family members / guests: $15.00* 

*Guests may enter park at 9:30 am

Non-Members: $50.00 or become a member for $75.00

Students: Become a member for $35.00

Attendance includes: Morning sessions, lunch, and a day pass to both the theme and water park for you and your family/guests*

Presentations –

8:30 am – 9:30 am

APEX Admin and Install Tips and Techniques

Dan Hotka, Author/Instructor/Oracle ACE Director

This presentation discusses various installation and administrative tasks associated with the Application Express 4.1 (APEX) Oracle web-based development environment.  Dan discusses new APEX 4.1 features as well as using SQL Developer to aid in the administration and deployment of APEX applications.

9:50 am – 11:50 am

How ASH works and how to use it.

John Bereniewicz and Graham Wood, ORACLE Corporation    

 “Active Session History” (ASH) is a rich historical record sampled from activity within the database at the level of individual sessions, capturing such important information as timestamp, user identity, the name of server from which the session was connected, the SQL statement executing, the PL/SQL module from which the SQL was executing, and the event and event parameters upon which the session was waiting.  ASH is a snapshot of what is happening in the database, captured automatically for later diagnosis.

Studies included will range from simple to complex.

 

Sponsored by and /or raffle items provided by : ORACLE, ARISANT, DBAK, APRESS, Evergreen Technologies, RMOUG and more.


 

 

 

ID Required

 

 

  May 18th, 2012

Quarterly
Educational Workshop

And Annual
Membership Meeting

**MySQL – Special Interest
Group**

 

Oracle Broomfield Campus

500 Eldorado Blvd

Building 1

Broomfield, CO 80021

Registration
Required!

Please go
to:

Click Here to Register!

 Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

 

$15
visitor fee

For non
members

 

7:30 am –  8:15 am         Continental Breakfast

8:15 am –   9:15 am         TOAD as a SQL Tuning Tool 

8:15 am –  9:15 am          MySQL Backup & Recovery Essentials

9:25 am    10:25 am     Oracle PL/SQL Timestamp/Interval Data Types

9:25 am   10:25 am      SQL and NoSQL

10:35 am  – 11:35 am     Improving  your Oracle Application Express Applications using Dynamic Actions and Plug-Ins

10:35 am – 11:35 am       Explaining the MySQL EXPLAIN

11:45 am – 12:45pm        Demystifying MySQL for Oracle DBAs and Developers

Networking Lunch

12:45pm – 1:45 pm   Board Meeting (open to all members), Board Elections and Annual Membership  

Presentations

8:15 am – 9:15 am

TOAD as a SQL Tuning Tool 

Dan Hotka, Owner, www.DanHotka.com

 

This is a live-demo presentation.  Dan shows how to use TOAD to perform many SQL tuning tasks and the value of the information being presented.  TOAD has some interfaces that simply do not exist in other tools.  TOAD also has some little known features that comes with both the base TOAD and TOAD for Developers.  The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.

 

8:15 am – 9:15 am – MySQL

MySQL Backup & Recovery Essentials

Ronald Bradford, Founder Effective MySQL, Oracle ACE Director

 A hardware, software or human failure can occur at any time. Are you prepared?  Many organizations take a risk of serious data loss and system downtime with inadequate procedures in place to support a disaster recovery.  This
presentation covers the essentials of MySQL backup and recovery options, identifying the necessary tools for an effective strategy to support data resilience and business continuity for your organization. MySQL has no one
single unbreakable backup solution, so it is important to understand the impact of MySQL replication, storage engines, configuration options for durability, hardware configuration and the impact on locking and uptime for the various
hot/warm/cold options available
.

9:25 am – 10:25 am

Oracle PL/SQL Timestamp/Interval Data Types

Donald Schaefer, Ingenix Senior Software Engineer

Presentation/Programming Examples for 5 PL/SQL Data Types: Timestamp, Timestamp with Time Zone, Timestamp with Local Time Zone, 2 Interval Data Types; fractional second precision, automatic adjustment fordaylight savings time, Time Zone/date/time calculations/conversions, programming with various Timestamp/Interval PL/SQL functions.

9:25 am – 10:25 am

SQL and NoSQL

Dave Stokes, Oracle MySQL Community Manager

Data has lately been divided between SQL and NoSQL. But what if you could access the same data, from the same disks
using both methods? MySQL features two storage engines that provide direct SQL access and NoSQL access without duplication of systems, disks or other infrastructure. The InnoDB storage engine is MySQL’s default and is fully
ACID while the NDB is used in a cluster environment.  This session will cover how to get the best of both worlds.

10:35 am – 11:35 am

Improving  your Oracle Application Express Applications using Dynamic Actions and Plug-Ins

David Peake, Oracle Product Manager, Application Express

Learn how to easily incorporate dynamic actions and plug-ins to take your APEX applications to the next level. With the advent of dynamic actions developers no longer need to know JavaScript and AJAX in order to incorporate client-side interactivity. Plug-Ins allow developers to easily extend APEX with custom item types, regions,processes, dynamic actions and even authentication and authorizations.

 10:35 am – 11:35 am

Explaining the MySQL EXPLAIN

Ronald Bradford, Founder Effective MySQL, Oracle ACE Director

Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.

The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective performance tune a running MySQL
environment.

 11:45 am – 12:45 pm

Demystifying MySQL for Oracle DBAs and Developers

George Trujillo, Oracle Solutions Architect at VMware, Oracle MySQL ACE

MySQL is the world’s most popular open-source database for the Web.  The presentation will provide an introduction to the MySQL architecture, features and ecosystem.   Attendees will also see how new features, virtualization and the cloud are continuing to increase the adoption of MySQL.

Topics include:

1. MySQL Architecture

2. What makes MySQL so popular

3. Key Features

4. Advantages of MySQL

Networking Lunch

12:45pm   –1::45 pm  Board Meeting (open to all members), Board Elections and Annual Membership

500 Eldorado Blvd

Show on
Google Maps

Training Days 2019

Click Here To Register For
Training Days 2019