I understand that some of the conference proceeding CDs from RMOUG Training Days don't launch automatically. A possible fix is to navigate to Windows Explorer and open your CD drive – scroll to the file that says "index.html" or just "index" – double-click that file and see if opens the CD.

If this doesn't work for you please contact veronica@teamycc.com with your mailing address so that a replacement CD can be sent out.

Thursday , February 12, 2009

Tell us about your conference experiences......
and don't forget to fill out your evaluation for the conference. We truly value your comments as they help us plan for future conferences. Click here ....

Wednesday, February 11, 2009

So how did your day go......

Dear RMOUG Training Days Participants and Speakers:

We are looking forward to seeing you at our conference this week. Below are a few helpful reminders:

• This year in keeping with the green initiative you will receive a CD containing both the papers and slides. We will not have paper handouts. However, all the papers and slide presentations that we have received are already available through the schedule builder. You can use our online schedule builder to create your schedule before arriving at the conference. You are not obligated to attend the sessions you select and you may change your selections at any time. The schedule builder helps you plan your day and gives us an idea of how many will be attending each session. Click here to access the schedule builder. To receive your password, please enter your first and last name and select the E-mail Password button. Your password will be sent to the e-mail address you used when you registered. If your name is not recognized, or you do not receive the e-mail with your password within a few minutes, please contact rmougreg@teamycc.com for help.


• Important Schedule Update: "Further RMAN Optimizations in 11g" presented by Stephan Haisley, Oracle Corporation, has been moved to Session 6, Room 201/203; and PL/SQL Development with SQL Developer presented by Kris Rice, Oracle Corporation, as been moved to Session 1, Room 201/203.


• Come join OTN @ RMOUG to learn more about the Oracle Expert Sessions in the OTN booth on the Exhibition floor.


• If you signed up for a University Session on Tuesday, February 10, registration opens at 11:00 a.m. in room 101. The sessions begin at 1:00 p.m. You may also register for a University Session on-site.


• Don't forget to invite your manager as our guest to attend the Exhibitor Showcase on Wednesday from 1:30 p.m. through the reception ending at 7:00 p.m. Send your manager's name, company, and e-mail address to rmougreg@teamycc.com and we'll send them an invitation.


• The Training Days 2009 registration and information desk will be open in the Four Seasons Ballroom Prefunction area from 7:00 a.m. until 7:00 p.m. on Wednesday and 7:00 a.m. until 4:30 p.m. on Thursday.


• The Training Days 2009 vendor exhibition will be open from 10:00 a.m. until 7:00 p.m. on Wednesday and 7:30 a.m. until 1:30 p.m. on Thursday. It is located in the Exhibit Hall (Four Seasons Ballroom) across from the registration and information desk.


• Internet stations are available in the Exhibit Hall to help you stay connected to the office.
  
  

Enjoy the conference!
The RMOUG Training Days Committee

Don't miss --- the Wednesday morning keynote speaker at Training Days!!


We are honored to have Roger Sullivan, Vice President of Business Development for Oracle Identity Management as our keynote speaker on Wednesday ---February 11, 2009 at 8:00am.

“A New Era of Security Risks for the Modern Enterprise”

New business demands are driving companies to externalize services, integrate with partners, and control the risk of online transactions. But a new wave of security challenges is confronting modern businesses amid a weak economic environment and a tough regulatory landscape. This session will highlight what’s ailing security in the modern enterprise and pinpoint some shortcomings with traditional industry solutions.

As the Vice President of Business Development for Oracle Identity Management, Mr. Sullivan spends his time with Oracle's premier customers, assisting them in understanding the business value of identity management and helping them evaluate and implement Oracle technology.

Mr. Sullivan also serves as Oracle Corporation Management Board representative to the Liberty Alliance and is President of the Alliance, an industry association of vendors and enterprise customers developing standards for federated identity management.

Mr. Sullivan is widely recognized as a leading authority on security, identity management, document, and work process technologies. He holds a Bachelor of Science from Northern Illinois University and has conducted graduate studies in information management at Boston University.

Added Presentation - Intro to MySQL for Oracle DBAs

If you are interested in MySQL, don't miss Darl Kuhn's presentation -- Session 11 Room 102

Here's his abstract:

Many companies use multiple database vendors to address varying requirements in an increasingly tough business environment. This presentation shows how to implement and use MySQL from an Oracle DBA’s perspective. Details will be given on DBA tasks such as installation, secure setup, user management, monitoring, performance, and troubleshooting a MySQL database

About the Presenter:
Darl Kuhn is currently a DBA with Sun Microsystems. He has coauthored three books: Linux Recipes for Oracle DBAs, RMAN Recipes for Oracle Database 11g and Oracle RMAN Pocket Reference. He teaches database courses at Regis University and also does volunteer DBA work for the Rocky Mountain Oracle Users Group.

Training Days is just a few weeks away -- we are looking forward to seeing everyone.


We thought some directions to the Colorado Convention Center would be helpful. So here is the link http://www.denverconvention.com/about-directions.htm .


The Convention Center has a separate link for information about the parking garage. Here is that link http://www.denverconvention.com/center-services-parking.htm .

Training Days 2009 will be held in the 100 and 200 halls of the convention center. That will be a bit of a walk from the parking garage, so don't forget to check out the map for directions.

Do You Have Questions About Training Days?

Hi Readers,

This blogsite is intended for interactive discussion about Training Days.

If you have questions about Training Days that you would like answered, please comment on this Post and we will try to get you an answer. By the way, our blog is set to moderate comments. So if your comment doesn't immediately appear - don't worry, it will.

Also you will need a gmail account to post a comment. If you don't have a gmail account, you can just go to google, and sign up for a gmail account.

Oracle Presenters - BI/DW Product Managers

If you are interested in Data Warehousing and Business Intelligence, then be sure to catch these presentations. These Oracle Product Managers will also be available to talk one-on-one in the Oracle Campground in the Exhibit Hall (check the Oracle Campground schedule).

Hermann Baer, Oracle Corporation
Hermann Baer heads product management for Oracle Data Warehousing's core functionality. Hermann has presented numerous technical sessions at Oracle OpenWorld and other conferences. He has worked with Oracle Database since Version 5 and joined Oracle in 1992.

His two presentations are:

• Best Practices for Deploying a Data Warehouse on Oracle Database 11
• Things You Always Wanted to Know - Get the Best Out of Oracle Partitioning

Jean-Pierre Dijcks, Oracle Corporation

Jean-Pierre Dijcks manages the product management team for Oracle Warehouse Builder, Oracle's data integration, data quality, and metadata management tool. After earning a degree in industrial engineering from the University of Twente in the Netherlands, Jean-Pierre joined Oracle Netherlands as a data warehouse consultant working on data warehouse implementations throughout Europe. In late 2000, he moved to Oracle product development as a product manager for Oracle Warehouse Builder. Building on his field experience Jean-Pierre is a key contributer within Oracle's data warehouse development group.

His two presentations are:

• Unleash the HP Oracle Database Machine for your Data Warehouse
• Creating High Performance ELT with Oracle Warehouse Builder

Kevin Closson, Oracle Corporation

Kevin is a performance architect in Oracle Corporation's Server Technology Group working on the Oracle Exadata Storage Server. His nineteen-year career has included engineering, competitive benchmarking support, and application development on Oracle SMP and clustered platforms. His work prior to Oracle at HP/PolyServe, Veritas, IBM/Sequent, Altos was focused on scalability and availability of the Oracle server. His Oracle port-level work at Sequent led to his US patents in SMP/NUMA locking and database caching methods. Kevin speaks frequently at Oracle conferences and is a member of the OakTable Network. Kevin was an Oracle ACE prior to joining Oracle Corp. In addition to book collaborations, his written works have appeared in Oracle Magazine, Oracle Internals Magazine, IBM Redbooks and SELECT.

Kevin maintains an interesting blog at kevinclosson.wordpress.com

Presentation:

• Oracle Exadata Storage Server. Introducing Extreme Performance for Data Warehousing.

Experience the Oak Table

What is the Oak Table? The Oak Table is a band of some of the finest minds in the Oracle world primarily focused on Oracle performance, improved administration, and having a great time. The book titled "Oracle Insights (Tales of the Oak Table)" is a must read and their website has lots of useful information: http://www.oaktable.net/.

RMOUG is fortunate to have several Oak Table members speaking at our conference again this year. Please join our local Oak Table members Daniel Fink, Tim Gorman, and Stephan Haisley in welcoming Kevin Closson, Carol Dacko, Thomas Kyte, Cary Millsap, Karen Morton, Jeff Needham, Mogens Nørgaard, Tanel Põder, Robyn Sands, Joze Senegacnik, Riyaj Shamsudeen, Gaja Vaidyanatha, Jeremiah Wilton, Graham Wood to RMOUG 2009.

Each year the Oak Table challenges RMOUG attendees to "Ask the Oak Table" -- find an Oracle-related question that their collective minds cannot answer. Try your luck and learn something in bargain!

Why Attend RMOUG Training Days?

In today's IT environment, budgets are extremely tight, and everyone is extremely busy. So why should you spend the money to attend Training Days? Is it really worth attending?

Absolutely! Here are some reasons for your manager:

1. Training Days is a unique opportunity to get 2 1/2 days of intensive exposure to current Oracle technology, and the application of that technology by industry leading consultants and Oracle personnel.
2. The list of presentors at RMOUG Training Days reads like a "who's who's" in Oracle technology.
3. In today's competitive environment, it is more critical than ever to keep up with technology trends and ways to be more productive and to make your organization more competitive.
4. Networking with Oracle technology experts and others in the Denver Oracle community can be invaluable when you need additional information about applying Oracle technology.
5. Bring your current technical challenges and ask the expert speakers, or the Oak Table members on how to solve them.

Registration Fees and Hotels

Note: If you would like to join RMOUG while registering for Training Days to take advantage of the member rate, select New Member rate.

Register Now

Advance Registration (on or before January 6, 2009)

• RMOUG Member/Other User Group Member: $240
• Nonmember: $300 New/Renewing Member: $315 (includes RMOUG membership fee)

Standard Registration (January 12 through February 3, 2009)

• RMOUG Member/Other User Group Member: $285
• Nonmember: $345 New/Renewing Member: $360 (includes RMOUG membership fee)

Late Registration (After February 3, 2009)

• RMOUG Member/Other User Group Member: $385
• Nonmember: $445 New/Renewing Member: $460 (includes RMOUG membership fee)

University Sessions on Tuesday are Extra
Come a day early to receive in depth training on specific topics at Training Days 2009 University Sessions. These are four-hour sessions offered on Tuesday, February 10 from 1:00 p.m. - 5:00 p.m. The fee is $125.00 and if you are registered for the conference you will receive a 10% discount. Details

Invite Your Manager/Supervisor - Free
Details

Hotels
PLEASE NOTE: If you need overnight accommodations, we have reserved a small block of rooms at the Hyatt Regency Denver, which is directly next to the convention center. Call 303.436.1234 or 1.800.233.1234 to make reservations. Be sure and say you are with RMOUG to receive the conference rate of $189 single/double occupancy. The cut-off date to receive the conference rate is January 9.

Invite Your Manager/Supervisor to RMOUG for Free!

Don't forget to invite your manager and/or supervisor as RMOUG's guest to come a see what RMOUG Training Days is all about on Wednesday, February 11, 2009 from 1:30pm to 7:00pm. As RMOUG's guest they are invited to attend:

• Technical sessions,
• Vendor Showcase sessions
• Exhibitors Reception.

Please email rmougreg@teamycc.com with name and e-mail address of anyone you would like to invite, we will send them an invitation and details of the day's events.

Special Event - Sponsors Showcase - Wednesday

This year our Sponsors Showcase will be on Wednesday, February 11th from 3:45pm - 4:45pm. These presentations will be full of details about the particular products or services provided by our 2009 Training Days Conference sponsors.

Exadata
Tom Kyte, Oracle Corporation
Join Tom Kyte and learn how Oracle Exadata and Oracle Database 11g provide a comprehensive platform for addressing today's data warehousing and business intelligence requirements.

IT Budget Bailouts
Jim Thomas, Vice President Sales and Marketing
Arisant

Jenny McGurk, Application Development Manager
Douglas County School District
IT budgets are being reduced, but expectations are not. Create your own bailout by choosing solutions that meet the demands of your business while also creating significant IT savings. This presentation will highlight real solutions that save real money.

Tackle Maintenance Performance and Change with Confidence
Jeff Smith, Solutions Architect, Quest Software
As a database administrator, you have to be more versatile than ever. You are likely under a great deal of pressure to implement application and database changes, and quickly resolve problems, all while preventing data loss or corruption. Furthermore, meeting service levels for performance and availability may add to the complexity of your job.

Don't forget to invite your manager and/or supervisor as RMOUG's guest to come a see what RMOUG Training Days is all about on Wednesday, February 11, 2009 from 1:30pm to 7:00pm. AS RMOUG's guest they are invited to attend technical sessions, Sponsors Showcase sessions, and Exhibitors Reception. Please email rmougreg@teamycc.com with name and e-mail address of anyone you would like to invite, we will send them an invitation and details of the day's events.

University Session: Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program

Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program
William Wimsatt, Wells Landers Group
Business Intelligence/Data Warehousing
Room 104/106

PLEASE NOTE: This is a hands-on session. Users are required to bring their own laptops. We will be sending an email to participants with directions for loading the required software prior to the session.

Understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization.
Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads.

Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query.

The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool. This presentation will present data quality, and formation of a data quality program through hands-on demonstrations and exercises with Oracle Warehouse Builder Data Profiler and an open source data profiler.

Register Now!http://www.technicalconferencesolutions.com/RMOUG_registration.html

University Session: Understanding Explain Plans

Understanding Explain Plans
Dan Hotka, Training Specialist
Application Development
Room 107/109

Understanding how Oracle arrives at the Explain Plan is a definite prerequisite to doing any further SQL statement tuning. Attend this presentation to understand exactly how Oracle arrives at execution plans and gain a better understanding of how Oracle works.

University Session: A Guide to Fusion Web Development with JDeveloper 11g

A Guide to Fusion Web Development with JDeveloper 11g
Peter Koletezke and Duncan Mills, Quovera and Oracle Corporation
Application Development
Room 111/113

These days, development shops have been mandated to develop new applications using Java Platform, Enterprise Edition (Java EE) Web technologies. This proves to be a challenge for traditional Oracle developers because the main Java EE languages and the style of development are very different. Oracle Corporation is developing the next wave of Oracle Applications (E-Business Suite, now Oracle Fusion Applications) using JDeveloper 11g and Application Development Framework (ADF) technologies such as ADF Business Components and ADF Faces Rich Client. JDeveloper 11g helps Web developers from every discipline transition more easily than ever to Java EE Web development. Its declarative and visual development environment rivals that of traditional tools, yet it creates standard Java EE code that can be deployed on any Java EE server such as Oracle Application Server and WebLogic Server.

This training session, presented by the co-authors of the Oracle Press book Oracle JDeveloper 10g for Forms & PL/SQL Developers, explains how to use JDeveloper and ADF with the technologies Oracle is using for fusion applications. It provides an introduction to and best practices for the use of JDeveloper’s visual and declarative tools. It demonstrates how you can use JDeveloper’s visual and declarative environment to create the Model layer, using ADF Business Components, which allow you to easily query, insert, update, and delete data; as well as the View and Controller layers, using ADF Faces Rich Client and JSF, which supplies the AJAX-enabled, Web 2.0 user interface, and the ability to interact with user events such as button clicks.

Register Now!

University Session: Oracle SQL Developer: Hands-On Experience

Oracle SQL Developer: Hands-On Experience
Sue Harper and Kris Rice, Oracle Corporation
Application Development
Room 108/110/112

PLEASE NOTE: This is a hands on session. Users are required to bring their own laptops with a database 9.2.01 or above installed. XE database is fine too. This can be downloaded and installed from OTN. We will not do database setup on the day.

SQL Developer provides database developers with a powerful tool for database development tasks. Users can browse, create, edit, and delete Oracle database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; run reports and place files under version control. Using a combination of presentation and hands on, this session walks users through various aspects of the tool. We'll start with an overview and look at the general features of the product, with a focus on new features. This is followed by a drill down into features such as PL/SQL editing and debugging, building User Extensions, using Version Control, and interacting with Application Express. We’ll close with an overview of SQL Developer Data Modeling and an opportunity to try out the product. In each of the sections, attendees will have a choice of hands on sessions to work with. Throughout, we will be using the latest release of SQL Developer, pointing out the latest new features introduced.

Register Now!

University Session: Maximum Availability Architecture 101

Maximum Availability Architecture 101
Stephan Haisley, Oracle Corporation
Database Administration
Room 103/105

Oracle Maximum Availability Architecture (MAA) is Oracle Corporation’s HA best practices blueprint based on Oracle high availability technologies such as Real Application Cluster, ASM, Data Guard, Exadata, Flashback technologies, etc. The goal of MAA is to design the best high availability architecture with the greatest return on investment and quality of service
Downtime is something every mission critical business wants to avoid or minimize, whether it is due to planned or unplanned outages. Oracle offers a number of features and proven operational and configuration practices to minimize downtime.

This session aims to demystify the HA features offered by Oracle and outline a clear set of best practices to avoid and minimize downtime for all outages. I will provide real world examples of how MAA best practices have prevented prolonged downtime when faulty HBAs corrupted the primary database, how a leading telecom reduced downtime exposure from two hours to its minutes for outages resulting in site failover, and how legal and insurance firms reduced downtime to minutes using Data Guard switchover for upgrades and major system changes. I will also describe how to configure for zero downtime for most unplanned and some planned outages.

Register Now!

University Session: Advanced RMAN Backup and Recovery

Advanced RMAN Backup and Recovery
Robert Freeman, Church of Jesus Christ of Latter-day Saints
Database Administration
Room 102

So, you have RMAN up and running. You are backing up your database, and you are pretty sure you know how to recover it. Maybe. Beyond that, what else exists out in the RMAN world that can help you? In this presentation Robert Freeman, author of Oracle Database 10g RMAN Backup and Recovery will touch on a number of advanced RMAN topics. Topics include point-in-time recoveries, performance tuning, and database duplication. Several new Oracle Database 11g features will also be highlighted. Come join us for this exciting exploration of advanced RMAN backup and recovery topics.

Register Now!

University Session - Hands-On Oracle Application Express—From Zero to 60 in a Day!

Hands-On Oracle Application Express—From Zero to 60 in a Day!
Bradley Brown, TUSC—A Rolta Company Details
Application Development
PLEASE NOTE: This is a hands-on session. You'll need to bring your own laptop that has a wireless card that can connect to Brad's network.

In this session, you'll learn to use APEX from concept to delivery to support. We'll start with an existing "database" (i.e. an Excel spreadsheet) and build a real world application from the ground up. We'll also look at how APEX was used to solve specific business problems such as performing online property validations, keeping track of insured pilots, bug tracking, Agile development tracking, getting people to RSVP to monthly events without having to call them, and others. This session will discuss and demonstrate the functional requirements, how these applications were extended over time, the net results, and cost savings.

APEX is a declarative Web-based application development and deployment environment. It's a powerful and easy way to quickly develop a database-centric Web application. You can install APEX on your own machines or run it in a hosted environment on Oracle's apex.oracle.com site. All development (construction of pages) is done through the browser interface. You can use the SQL Workshop and the Data Workshop to run SQL and add data to your environment. This easy-to-use tool will impress you in no time at all! PL/SQL developers and DBAs love Application Express! This presentation gives the participants a good introduction and great hands on experience with the APEX development environment, as well as a good idea of the power that it contains to create quick, powerful Web application in a very short time.Brad will bring a server that has APEX installed along with a wireless network router that everyone will connect to for the class.

You'll need to bring your own laptop that has a wireless card that can connect to his network. You can share with someone else in the class if you would like, but the best experience is for you to do the typing. SQL and PL/SQL knowledge will be beneficial, but not absolutely necessary. This class is going to be limited in size, so sign up quickly!

Register Now!

Training Day University Sessions - on Tuesday

Come a day early to receive in depth training on specific topics at Training Days 2009 University Sessions. These are four-hour sessions offered on Tuesday, February 10 from 1:00 p.m. - 5:00 p.m. The fee is $125.00 and if you are registered for the conference you will receive a 10% discount. PDF Document

• The RMOUG University Sessions include:
  Hands-On Oracle Application Express—From Zero to 60 in a Day!
  Bradley Brown, TUSC—A Rolta Company
  Application Development Details
  PLEASE NOTE: This is a hands-on session. You'll need to bring your own laptop that has a wireless card that can connect to Brad's network.
  
• Advanced RMAN Backup and Recovery
  Robert Freeman, Church of Jesus Christ of Latter-day Saints
  Database Administration Details
  
• Maximum Availability Architecture 101
  Stephan Haisley, Oracle Corporation
  Database Administration Details
  Room 103/105
  
• Oracle SQL Developer: Hands-On Experience
  Sue Harper and Kris Rice, Oracle Corporation
  Application Development Details
  Room 108/110/112
  PLEASE NOTE: This is a hands on session. Users are required to bring their own laptops with a database 9.2.01 or above installed. XE database is fine too. This can be downloaded and installed from OTN. We will not do database setup on the day.
  
• Understanding Explain Plans
  Dan Hotka, Training Specialist
  Application Development Details
  Room 107/109
  
• A Guide to Fusion Web Development with JDeveloper 11g
  Peter Koletezke and Duncan Mills, Quovera and Oracle Corporation
  Application Development Details
  Room 111/113
  
• Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program
  William Wimsatt, Wells Landers Group
  Business Intelligence/Data Warehousing Details
  Room 104/106
  PLEASE NOTE: This is a hands-on session. Users are required to bring their own laptops. We will be sending an email to participants with directions for loading the required software prior to the session.

Register now!

RMOUG Training Days 2009 "The best little Oracle conference in the west..."

Oracle users from the Rocky Mountain region, many other states, and six other countries converge each February in Denver, Colorado to share knowledge about Oracle's software products and their use.

We invite you to join us February 10th, 11th, and 12th at Denver Colorado Convention Center click here for more information.

Don't miss this conference! Register now!