How IntelliReal used Oracle Application Express to Rapidly Build their Production Environment (3.16MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 11/17/2006 Abstract: IntelliReal (www.intellireal.com) is a real property market intelligence company. IntelliReal utilizes advanced technology and data aggregation to provide significantly enhanced data mining, accuracy, speed and reduced cost delivering valuation solutions. IntelliReal's user interface was developed using Oracle Application Express (APEX). With most any technical presentation that you’ve attended, you’re likely always thinking about how to relate your environment to what the speaker is discussing and building a real world application using the tool. This presentation covers a specific business problem that was solved using APEX: delivering a rich user interface for "show." IntelliReal's primary customer base are businesses. Most of the customers actually access the IntelliReal systems using SOA. The APEX application uses the SOA components too. This presentation will discuss the functional requirements, how the application continues to be extended, the net results and cost savings. This presentation will include an online demo and discussion of the components.

How IntelliReal is using Web Services to enable customers to better service their clients (3.42MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 11/17/2006 Abstract: IntelliReal (www.intellireal.com) is a real property market intelligence company. IntelliReal utilizes advanced technology and data aggregation to provide significantly enhanced data mining, accuracy, speed and reduced cost delivering valuation solutions. The Service Oriented Architecture (SOA) provides the foundation for IntelliReal's business-to-business delivery. IntelliReal's customers are able to seemly access the IntelliReal core technology as if that technology is running in their own IT environment. This presentation will include a demonstration of the SOA application in action. IntelliReal uses Oracle Application Express (APEX) as the "sales" tool, but typically delivers their solution from business-to-business using the SOA solutions. This presentation will cover the SOA and how it can change how you work to deliver applications to your customers (and other internal groups).

Quick Web Development using JDeveloper 10g (2.14MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 11/17/2006 Abstract: JDeveloper 10g is an amazing development environment. Each new version gets closer to rivaling Oracle Forms. Now with the Oracle Application Developer Framework (ADF), which includes TopLink and Struts, you can quickly and easily develop a GUI/HTML-based Web application using this point-and-click, drag-and-drop development tool. This presentation will show you how to: Map a database object into an ADF Business Component - a persistent business object using BC4J An ADF Business Component view object - providing the data access An ADF Business Component Application Module - providing the business services The ADF Data Bindings and Control components - the "Model" in MVC The Struts Controller - the "Controller" in MVC The Java Server Page - the "View" in MVC In one hour you'll learn how to quickly develop an application using JDeveloper 10g.

Case Study - Using Web Services to seamlessly integrate companies (5.67MB) Presented at: Oracle Open World (OOW) Presented by: Brad Brown Date: 10/21/2006 Abstract: IntelliReal (www.intellireal.com) is a real property market intelligence company. IntelliReal utilizes advanced technology and data aggregation to provide significantly enhanced data mining, accuracy, speed and reduced cost delivering valuation solutions. The Service Oriented Architecture (SOA) provides the foundation for IntelliReal's business-to-business delivery. IntelliReal's customers are able to seemly access the IntelliReal core technology as if that technology is running in their own IT environment. This presentation will include a demonstration of the SOA application in action. IntelliReal uses Oracle Application Express (APEX) as the "sales" tool, but typically delivers their solution from business-to-business using the SOA solutions. This presentation will cover the SOA and how it can change how you work to deliver applications to your customers (and other internal groups).

High-Availability Development Methodology: What Do You Need To Be Successful? (1.44MB) Presented at: Oracle Open World (OOW) Presented by: Shaun O'brien Date: 10/21/2006 Abstract: High-availability (HA) development brings with it some unique requirements and, by extension, some unique challenges that need to be adequately addressed when attempting to deliver rigorous guaranteed levels of uptime. In this session, you hear the basics of HA, what it means, what some of its challenges are, and the specifics of an HA development methodology that addresses these challenges. The methodology presented is a TUSC-recommended methodology that is based on industry standards. Included in the presentation are insights provided from a case study based on implementation of this methodology with one of the leading U.S. university hospital and medical organizations.

How Oracle Came to Rule the Database World (4.76MB) Presented at: Midwest Oracle Users Group (MOUG) Presented by: Rich Niemiec Date: 09/08/2006 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

New Oracle 10g & 9i Features For Developers (115KB) Presented at: Midwest Oracle Users Group (MOUG) Presented by: Tony Catalano Date: 09/08/2006 Abstract: This presentation covers the following: Internal PL/SQL Enhancements PL/SQL Compile Time Warnings DBMS_DDL DML Error Logging Merge Statement Flashback Query Flashback Table DBMS_METADATA Multi-Table Inserts Native Dynamic SQL Global Temporary Tables Bulk Binds with Collections

Giving Winning Presentations (14.6MB) Presented at: Oracle Development Tools Users Group (ODTUG) Presented by: Rich Niemiec Date: 06/19/2006 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include: Why you're giving the presentation Why your audience came to listen The opening Your speaking style and tone The abstract and material to cover Practicing Keeping it exciting The handouts Taking questions The summary and ending

Tuning Oracle9i/10g using Statspack & AWR (11.1MB) Presented at: Oracle Development Tools Users Group (ODTUG) Presented by: Rich Niemiec Date: 06/19/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick ways to solve many of your performance issues that plague your system. This presentation will show how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file i/o issues. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events.

How Oracle Came to Rule the Database World (7.93MB) Presented at: Oracle Development Tools Users Group (ODTUG) Presented by: Rich Niemiec Date: 06/19/2006 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success. The Paper that started it all - E. F. Codd System-R & Ingres Oracle is Founded as SDL V1-V10g Why did Oracle win? Future market direction Summary

Exceptional Leadership; Be the Uncommon Leader (1.00MB) Presented at: Mid-America Association of Educational Opportunity Presented by: Rich Niemiec Date: 05/16/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

New 10g and 9i Features for Developers (369KB) Presented at: Collaborate Presented by: Tony Catalano Date: 04/26/2006 Abstract: As the new database versions roll out, so do some exciting new features. This presentation discusses the new Oracle 10g, Oracle9i and Oracle8i features that enhance the developer's ability to develop mission critical Web-based applications. Using the new features demonstrated in this presentation add reliability, stability, speed and flexibility to any application. Just a few of the topics featured in the presentation are: PL/SQL compilation, Merge, multi-table inserts, bulk binds, triggers on system events, and Native Dynamic SQL. Attendees gain an understanding of the features; learn when to use them and learn the design considerations associated with each.

Content Management with OracleAS Portal 10g R2 (1.04MB) Presented at: Collaborate Presented by: Chris Ostrowski Date: 04/26/2006 Abstract: Many people think of content management as icons on a web page that users can click to download an Excel file. The features Oracle provides in OracleAS 10gR2 to manage content give administrators incredible amounts of flexibility and security. This presentation will show the advanced features of Oracle's Content Management and show that, with the right planning, Content Administrators can deploy a dynamic content management system with virtually no written code whatsoever.

Using JDeveloper to Create and Deploy Portlets (592KB) Presented at: Collaborate Presented by: Chris Ostrowski Date: 04/25/2006 Abstract: The OracleAS Portal wizards are extremely powerful, but there many reasons for needing greater control of your portlets than the OracleAS Portal wizards can give you. Oracle JDeveloper gives you total control over your Portlet development. Previous versions of JDeveloper used an arduous process for developing and deploying portlets. This presentation will focus on the ease with which developers can develop and deploy portlets in the latest versions of JDeveloper and the Oracle Application Server.

The PL/SQL Grid: Time to Expand to 10g R1 and 10g R2 (899KB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/24/2006 Abstract: This presentation will cover the new PL/SQL related features specific to Oracle10g release 1 and release 2. The new features covered include the following: new conditional compilation, new PL/SQL commands (regular expressions), new and enhanced Oracle supplied packages (dbms_output, dbms_ddl wrap procedure, dbms_warning, dbms_stats), new functions, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Controlled Flights Into Terrain: Learning from Catastrophic Database Design Failures (643KB) Presented at: Collaborate Presented by: Kevin Loney Date: 04/24/2006 Abstract: Many database application failures result from design errors. These errors limit the performance and functionality of the application, ultimately limiting the business process the application is supposed to service. This presentation will provide a review of database application failures and a list of design principles that would have avoided the failures. From a performance perspective, every system is designed to fail at some point - and the system design is the key to extending the viability and usefulness.

Tuning Oracle at the Block Level; Beginners, Go Away! (1.54MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: If this talk doesn't kill me nothing will. This is a look at Oracle moving at the block level. We'll look at how blocks move from disk to memory, how they become Current blocks, how they become Consistent Read (CR) versions and other interesting tidbits of information that only keep you from achieving the business goals of the company. Ok, it's because you want to know why. We'll also look at some of the cool x$ tables out there that you should stay away from including many that begin with x$ksm (like x$ksmsp - kernel storage memory SGA heap) what they'll reveal to you. We'll look at why the move toward 64-bit technology, memory resident databases and RAC/Grid makes this even more important to understand. Why you should understand some block level concepts Move toward memory resident databases Move toward RAC/Grid computing This is where the problems are hiding Block level concepts Current, CR and other blocks Versions of blocks Over the years Delayed block cleanout Blocks and the Grid Useful Scripts Summary

Tuning Oracle9i/10g using Statspack & AWR (5.07MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick ways to solve many of your performance issues that plague your system. This presentation will show how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file i/o issues. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events. Overview of statspack Top 5 wait events Load Profile Instance Efficiency Hit Ratios Wait Events Latch Waits Top SQL Instance Activity File I/O Memory Allocation Undo Oracle Recommendations Using Enterprise Manager Using other OEM screens to monitor and tune Helpful V$/X$ Scripts Summary

Beginner Tuning Tips for Developers (3.19MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This is a beginner level presentation on developer tuning. This presentation is focused on developers who are relatively new to Oracle. It will focus on some basic tuning tips and techniques that you can use to tune your code. After a brief look at how Oracle works and where a query fits into the process. We will look at how to find the problem queries in your system. We will also look at various indexes that can be built and things to watch out for with certain indexes. We'll review how to use explain plan and Autotrace. Lastly, we'll look at using hints to tune queries and joining tables. Overview of how Oracle works and where queries fit into the process Finding the problem queries Your indexing arsenal Using Explain Plan and Autotrace Hints that can help Joins and the Driving Table Partitioning Basics

Giving Winning Presentations (4.45MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include: Why you're giving the presentation Why your audience came to listen The opening Your speaking style and tone The abstract and material to cover Practicing Keeping it exciting The handouts Taking questions The summary and ending

Tuning the Oracle Grid (16.7MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. Getting good information RAC SIG OTN Oracle Technical Guides Grid Basics The interconnect and block coordination Tuning quick tips Tuning using statspack Tuning using grid tools High inserts Load balancing and FAN Future trends Installation Tips Where does ASM fit in? Enterprise Manager and Grid Control

Oracle Application Server 10g R2 New Features (198KB) Presented at: Collaborate Presented by: Chris Ostrowski Date: 04/24/2006 Abstract: Oracle Application Server embraces almost all of the major development frameworks available today. Oracle continues to add enhancements to its Application Server and keeping up with these new changes can be a challenge. The presentation will delineate the additional functionality Oracle has incorporated into the Application Server and will discuss Oracle's focus on SOA.

Spatially Enabling Your BI Applications with Oracle Spatial and Mapviewer (3.02MB) Presented at: Collaborate Presented by: Matt Topper Date: 04/24/2006 Abstract: Almost every data warehouse is litered with spatial information. Customer addresses, store locations, competitor locations, etc. All of this data has great potential to add value to your Business Intelligence products. This presentation will cover how to spatially enable your data and include it in your BI dashboards. I will show the Oracle Locator and Geocoder and how to transform address information to latitude and longitude numbers. Using the database data I we will show how to create store territories based on real customer data. Now that the territories have been made we can display the information utilizing Oracle Mapviewer to visualize the data. Lastly, we will turn the map created in Oracle Mapviewer and add it to a Portal BI Dashboard.

How to use Regular Expression Functions in 10g (339KB) Presented at: Collaborate Presented by: Kevin Loney Date: 04/24/2006 Abstract: As of Oracle Database 10g, you can use the regular expression functions to perform very complex searches. This presentation will show the formats for the functions along with examples of searches. Examples include case-insensitive searches and searches for classes of characters (such as all numbers, or all uppercase letters). As a bonus, case-insensitive search options that do not use the regular expressions will also be shown.

Exceptional Leadership; Be the Uncommon Leader (1.00MB) Presented at: Upward Bound Presented by: Rich Niemiec Date: 04/01/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

Exceptional Leadership; Be the Uncommon Leader (3.57MB) Presented at: Virginia Oracle Users Group Presented by: Rich Niemiec Date: 03/01/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

Tuning Oracle9i/10g using Statspack & AWR (1.98MB) Presented at: Virginia Oracle Users Group Presented by: Rich Niemiec Date: 03/01/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick ways to solve many of your performance issues that plague your system. This presentation will show how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file i/o issues. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events.

3 Major Trends in the Database World (3.59MB) Presented at: WebEx Briefing Presented by: Rich Niemiec Date: 02/15/2006 Abstract: I've worked with TUSC, a major Oracle integrator, for almost two decades. Over the past five years, I've seen three major trends that seem to be molding the future of database administration. The first is the adoption of clustering and an accelerating trend toward grid computing. The second is a movement toward Linux for smaller and mid-sized systems. The third is the pendulum swing first toward offshoring database work and then a shift away from offshoring and toward a new mixed model. All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs. This presentation will show how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.