HTTP and HTTPS – What Every Web Developer Needs to Know
John Flack, Synectics for Management Decisions, Inc.
Get a web developer’s eye view of the HyperText Transmission Protocol (HTTP).  Learn how to avoid its pitfalls and take advantage of its capabilities.  Understand the place of authentication and authorization in the protocol.  This is NOT oriented toward any particular programming language, but is for ANY person who develops application systems for the World Wide Web.

Introduction to Data Modeling: Using the IDEF1X Notation
Scott Lurton, Data Tactics Corporation
This presentation is an introduction to relational data model with a focus on the IDEF1X notation.

Secure APEX Development
Scott Spendolini, Sumneva
Security should never be an afterthought with any type of application development.  Rather, it should be incorporated into your system design from day one.  Unfortunately, many APEX developers forget this rule and try to retrofit in security during the last hours of development before going live.

APEX 4.0 New Features
Scott Spendolini, Sumneva
This session will highlight the major new features of Oracle APEX 4.0.  It will also cover the benefits and risks in upgrading from previous releases.

Data Warehousing/BI

How to Setup Parallel Execution
Margaret Norman, Duke Energy
Parallel execution can dramatically reduce execution times – at least until the server runs out of resources.  This “how to” presentation focuses on implementing parallel execution to provide stable execution times and obtain the maximum performance the available hardware can deliver while avoiding server saturation.  A testing methodology to determine the server saturation point and a strategy for allocating those resources among database users will be showcased.

Dashboarding for Fun and Profit
Jim Raper, City of Charlotte
Strategic and Operational Dashboards are tools that more are turning to in order to plot their course through these turbulent times. Designing and implementing dashboards involves both art and technology. This presentation will provide a framework upon which to knit business specific solutions using the tools that are currently onboard.

Sustaining Government Effectiveness through Visual Analytics
Jim Raper, City of Charlotte
In less than a year, the City of Charlotte has increased its use of visual analytics seven fold.  This presentation provides the groundwork for expanding the acceptance of new technology, such as Tableau or Hyperion Visual Explorer, among business analysts and reducing IT’s reporting load.

Learn About ANR's Strategy to Leverage OBIEE Over Oracle EBS and Hyperion
Greg Vlahos, Analytic Vision
This presentation describes how ANR is leveraging the Oracle prebuilt business intelligence applications over Oracle EBS 12 to quickly generate integrated reporting across their enterprise with drilldown capabilities into the transaction detail.  We will review what's involved in these implementations, describe how ANR will leverage this over their Essbase and HFM solutions, and show a detailed demonstration of OBIEE reporting capabilities.

DBA

Detailed AWR and Statspack Report Analysis
Michael Ault, TMS, Inc.
The attendee will learn how to quickly analyze an AWR or Statspack report to make tuning decisions in an Oracle database.

Testing to Destruction: Part Two
Michael Ault, Texas Memory Systems
This presentation will cover the use of synthetic workloads (TPC-C and TPC-H) in testing Database systems and show comparisons between HDD and SSD based systems.

Successful Oracle Database 11gR2 Upgrades with Oracle E-Business Suite
Michael Brown, Colibri Limited
Upgrades to a production database can be a complex task.  This is especially true when the E-Business Suite is involved.  This session will consolidate the multitude of resources that need to be followed for a successful upgrade.

Simplify Your Project Accounting Close Process
Grant Chen, UC4 Software
Having a system in place to run Project Accounting close cycles in parallel provides companies a significant competitive advantage over their counterparts still using a manual close process. Automating the close cycle to track multiple jobs belonging to multiple operating units allows companies to reduce their PA close cycle time. Combined with automated error handling and e-mail notification with report outputs, project administrators can focus on business issues instead of system issues, significantly improving the company's efficiency.

BaSQing in Oracle—Delving into the Depths of the Internal Tables Just for Fun
John Claxton, B/E Aerospace
Core database tables owned by "SYS" will be discussed.

The Database Breaks—You Fix It: An Introduction to 11g Data Recovery Advisor
Break System / Break a Controlfile / Break a Datafile / RMAN Repair Advisor
John Claxton, B/E Aerospace
When a database "breaks" (disaster), it’s the DBA's job to "fix it" (recovery). With 11g, the Data Recovery Advisor (DRA) can help. Either through command line or GUI tools, DRA can show you what’s wrong, tell you how it can be fixed, and even fix it for you.

Increase Performance using Results Cache in Oracle 11g
Janis Griffin, Confio Software
This presentation looks at several real life scenarios where using Results Cache could greatly enhance performance. Several comparisons of performance with and without Results Cache are shown.

Database Performance Made Easy Through Graphics
Scott Walz , Embarcadero Technologies
This presentation will discuss the use of sample data to create Active Sessions History (ASH). ASH is dense, multidimensional data, which makes it difficult to analyze but can be simplified using a metric called Average Active Sessions(AAS)which shows the load on the database and allows you to drill down with precision and clarity into the cause of each bottleneck.Most often, bottlenecks are caused by poor-performing SQL statements. For analyzing suboptimal SQL statements, attendees will be shown how to lay out the query graphically in a Visual SQL Tuning (VST) diagram. Through the VST, you'll learn how to quickly visualize any coding errors in the query, discover flaws in the
underlying database schema, and most importantly, find the best execution path through the query.

Version Magic with Oracle 11gR2:  Edition-Based Redefinition
Chuck Markham, Silverlink Bay Solutions
Edition-Based Redefinition is a great new feature of Oracle 11gR2 that allows you to make upgrades to a critical application, even in a production environment, while taking little or no downtime. Major changes can be made online and transparently as a new "edition" while current users continue undisturbed. You can then permit selected users to register for new editions of objects and verify the system right in the production system before the cutover for all users.

Can't We All Just Get Along??—Interacting with Other Popular Databases
Greg Mays, B2B Solutions, LLC
This presentation will provide the "nickel tour" of other popular databases including SQL Server, MySQL, and PostGRESQL and look at in general what their strengths and weaknesses are in comparison to Oracle, what significant technology distinguishes them, and how to work with them via heterogeneous services for Oracle or various other connectivity specific to the database.

Upgrading to 11g Statistics
Margaret Norman, Duke Energy
With the introduction of table level preferences, database defaults, global incremental statistics and resource control in 11g, Oracle 11g statistics are more versatile, more accurate, and require less gathering time than in 10g.  Presentation demonstrates reduced elapsed time scripts that gather statistics using multiple threads and parallel execution.

Setting Up a Powerful and Functional Oracle Development Desktop
Paul Stallard, B2B Solutions, LLC
This talk will provide a detailed overview of setting up a machine that will support development/testing against a variety of Oracle client, middleware, and database configurations (e.g. RAC, multiple versions, multi OS). Utilizing free or low cost virtualization products, storage software, and cloud services we'll review options for setting up a desktop or laptop that can be used both on the network or disconnected.

Management/Trends

Virtualization and Cloud Technologies—An Overview for Database Professionals
Joseph D'Antoni, Synthes
This presentation will provide an overview of cloud technologies for hosting databases and will discuss server virtualization.

Oracle Applications

E-Business Suite 12 Upgrades— Three Easy Steps
Michael Barone, OATC, Inc.
Attendees will learn the new installation and upgrade features, E-Business Suite 12 supported upgrade paths, technology (Tech-Stack) differences in E-Business Suite Release-11i and Release-12, step-by-step new technology features and setups, and upgrade methodology and the 12-bullet-points milestones for a great upgrade.

Moving to BI Publisher, Now What? Automated Document Delivery from Oracle EBS
Ben Bruno, STR Software
Join us as we explore the pros and cons of the native delivery functionality of Oracle EBS and BI Publisher.  This presentation includes a customer case study.

Managing an R12 Upgrade— Tips and Methodology That You Need to Know to be Successful
Art Dowd, O2Works, LLC
Our experience has shown that the R12 upgrade is different than the 11i technical upgrades. The technical tools are better but the changes to the applications will be felt by all users. As a result, all end users will need to be prepared. We’ll show you how to be successful.

Enterprise Applications: CRPs Myth, Method, or Madness?
Bill Dunham, OATC, Inc.
Enterprise application projects should not be over-complicated by needless processes and paper. This happens quite often and unnecessarily. The CRP Method approach is unique as the primary focus is getting to iterations of testing the enterprise applications. The testing iterations (CRPs) has many residual effects such as increased organizational learning of the enterprise applications, decreased change management because of this involvement, decreased application issues and problems in production, and progressively satisfied team members and management. The testing iterations (CRPs) exercise the implemented or upgraded applications while validating business requirements, setups, migrated data, and customizations - all while simulating real business transactions using real business data. The rewards and residual effects of this approach are astounding.

Using Every Tool in the Box for Oracle EBS iExpense
Jim Flinn, University of Virginia
UVA encountered a number of challenges while implementing travel policies in iExpense.  Learn how UVA implemented iExpense using OA Framework Extensions, OA Framework Personalizations, PLSQL Client Extensions, WF customizations, and custom profile options to meet a vast array of requirements.

Best Practices and Technologies for Building Microsoft Excel-based Oracle Financial Reports
Michael Gerard & Daniel Havey, GlobalSoft
Learn how to make your spreadsheet reporting more interactive and dynamic with Global Software’s Microsoft Excel-based automation tools. Empower your organization’s users to access critical Oracle data with minimal IT intervention. Gain an understanding of creating custom Microsoft Excel-based financial reports and populating them with Oracle General Ledger data using Spreadsheet Server. Examine benefits Tekelec has realized by automating the population of Microsoft Excel spreadsheets with Oracle data. Hear how the company enhanced its overall spreadsheet experience, including month-end report running, preparing financial statements, budget to actual statements, currency rate analysis and distribution and publishing.

Validating the Oracle EBS Purchasing Hierarchy
Talbott Jones, Colibri Information Management
We will discuss methods of  validating or reporting the purchasing hierarchy in a format that mirrors the input forms, but provides a comprehensive view of the data instead of the limited slice displayed by the forms.  SQL queries will be shared with the attendees.

Oracle's AIA Integration for E-Business Suite and Primavera
Michael Zwain , Project Partners, LLC
Learn about Oracle's Application Integration Architecture (AIA) integration for Oracle Primavera and Oracle E-Business Suite, and how this integration can help bring your E-Business Suite and Primavera project management silos together.  Learn about the benefits of integration, business process improvements, data flow, and integration options. Includes a live demonstration.

Data Exchange and Event Management Between Oracle EBS and Other Systems—The Easy Way
Brent Lowe, STR Software
This presentation investigates a tool that affords EBS users the ability to create, configure, and manage automated event-driven processes (FTP file, email file, submit request, etc.) between EBS and 3rd party systems, without engaging specialized IT resources.

Transform your Financial Statement Generator (FSG) Processes
Matthew Topfer, InsightSoftware.com
Find out how these 6 easy steps can transform your financial reporting processes: 1. Import-Fast track your FSGs in an Office 2007-style environment; 2. Validate-Automatically check for reporting integrity issues; 3. Format-Transform boring report definitions into elegant interactive reports; 4. Extend-Augment your reports with 100s of new reporting features; 5. Drill-Drill down from any level to live transactions in a single click; and 6. Replace-Leave technical FSGs behind with a true end user reporting solution.

Getting it Right the First Time: Architecting a Highly-Available, Fast, and Secure Oracle Deployment
Thom Walker, F5 Networks
You've spent hundreds of thousands, or even millions of dollars developing and deploying Oracle solutions.  Upon deployment, you discover that many remote users are unable to use the application due to unacceptably slow network performance.  At the close of every financial quarter, your application slows to a crawl.  New security concerns are coming up faster than you can update the applications.  The complaints from your customers, partners, and co-workers are starting to mount.  Sound familiar?  Fortunately, there is a simple solution that can help you get things right the first time.  Come learn how the discipline of application delivery networking can provide an agile infrastructure to ensure your Oracle applications are always available, fast, and secure.

SLA: The Basics
Nicole Wilson, Rolta TUSC
In this presentation, we will discuss the basics of setting up and defining SLA.

Security

Solving SQL Injection
Rob David, Sentrigo, Inc.
Though many types of SQL injection can be prevented by secure coding practices, one can limit and even stop SQL injection attacks by using certain tools to protect applications and databases. As we will demonstrate, certain classes of SQL injection are entirely blocked by deployment of deep inspection tools.

Data Topics in Cyber Security
Carl Willis-Ford, SRA International, Inc.
The bad guys are after your data, but technology alone won’t protect that data.  People, process and technology are all required to protect the enterprise.  This presentation takes a non-technical look at various topics: SQL Injection, Social Networks, and Social Engineering and how every employee participates in security.

System Architecture/Administration

When You Don't Know What You Don't Know
Faun DeHenry, FMT Systems, Inc.
This discussion includes case study presentation investigating an Oracle EBS implementation with highlights and life experiences of the challenges and successes of the processes.

Sunset for Big Iron?  Are Monolithic Disk Arrays Obsolete?
Hank Tullis, BIAS Corporation
With the high performance of the Exadata2 architecture,  are closed disk arrays on the way out?  This presentation addresses the storage architecture supporting the Exadata2 system and applies the concept to both RAC and non-RAC systems.  This application of commodity storage components with Oracle’s ASM architecture provides a viable approach to low cost system implementations.