Vote Early, Vote Often: From Napkin to Canvassing Application in a Single Weekend

The frenetic pace of application development in modern IT organizations means it’s not unusual to demand an application be built with minimal requirement gathering – literally, from a napkin-based sketch – to a working first draft of the app within extremely short time frames – even a weekend! – with production deployment to follow just a few days later. We’ll explore a real-life application development scenario – the creation of a mobile application that gives election canvassers a tool to identify, classify, and inform voters in a huge suburban Chicago voting district – using the latest Oracle application development UI, data modeling tools, and database technology. Along the way, we’ll show how Oracle APEX makes short work of building a working application while the Oracle DBA leverages her newest tools – SQL Developer and Data Modeler – to build a secure, reliable, scalable application for her development team.

Autonomous Data Warehouse (ADW): These Are the Droids You’re Looking For

Introduced in Oracle 18c, the Autonomous Data Warehouse (ADW) provides a tightly-controlled, Cloud-based environment for application workloads focused on analytic reporting and data warehousing. This presentation looks at how ADW performs against the TPC-DS decision support benchmark queries and explains the details of how best to take advantage of ADW features, as well as understand precisely what ADW means for the role of Oracle DBA in the near- and long-term.

Autonomous Transaction Processing (ATP): In Heavy Traffic, Why Drive Stick?

Autonomous Transaction Processing (ATP) – the second in the family of Oracle’s Autonomous Databases – offers Oracle DBAs the ability to apply a force multiplier for their OLTP database application workloads. However, it’s important to understand both the benefits and limitations of ATP before migrating any workloads to that environment. This presentation offers a quick but deep dive into how best to take advantage of ATP – including how to load data quickly into the underlying database – and some ideas on how ATP will impact the role of Oracle DBA in the immediate future. (Hint: Think automatic transmission instead of stick-shift.)

Conquer Big Data with Oracle 18c, In-Memory External Tables and Analytic Functions

There’s an onslaught of Big Data coming to our IT shops – zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c? This presentation demonstrates how to tackle handling the coming Big Data tidal wave with the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language. We’ll also take a closer look at using some new Analytic Functions in 18c to make short work of complex analyses and how best to leverage 18c’s new Database In-Memory features for External Tables.

An Airline Pilot, A Urologist, and a DBA Walk Into a Bar: Thinking Like a Professional

It’s no joke! The IT industry is undergoing a maelstrom of change – ever-increasing data volumes, horrendous security incursions, the promise / threat of Cloud-based computing, and a gradual loss of its most talented people through age-based attrition. What’s needed more than ever is a revival of professionalism within our ranks, and it’s time for us to rise up as a community to strive towards that goal. Seriously – if you are just doing your IT job and are perfectly satisfied with your status in our industry, please don’t waste time reviewing this presentation.


Everything You Know Is Wrong: DBA Intuition, Meet Hard-Core Metrics

Handling application performance degradation – especially when an RDBMS as complex as Oracle Database 12cR2 underlies the application – can be a complex, time-consuming, frustrating task. Via actual use cases, stories of painful discoveries, and of course some hard-core metrics, this session will take a look at some of the simplest mistakes even an Oracle DBA can make when probing application performance issues and how to overcome one’s own blind spots when searching for the true root causes of that degradation.

Caveat Nuba Emptor: Matching Your Organization’s 12cR2 Needs To the Best OPC Database

 You’re an Oracle DBA whose CIO has at last agreed to embrace the Oracle Public Cloud (OPC) and now you’re ready to begin your journey. But now you face another difficult task: choosing from an almost dizzying array of options as you start your trek to building your first 12cR2 database in the OPC.

This session will give you some much-needed practical advice using an actual example of implementing an application performance evaluation environment using Swingbench’s TPCDS model to compare the original Oracle Database as a Service (DBAAS) – aka the Database Schema Service – versus its latest and greatest incarnation, Exadata Express and even the newest “bare metal” OPC options so that you can choose wisely, begin your OPC trek, and never regret your decision.

Saving Your Database from Alzheimer’s: Analytic Performance Improvements From Oracle 12cR2 Database In-Memory (DBIM)

Oracle Database (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.

Leveraging Partitioned External Tables: Primer and Practical Examples

Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language.

Get Smart! Embrace #SmartDB To Restore Application Code To Its Rightful Place 

Almost every modern IT organization has struggled with the best place to locate crucial application code bases -inside the application server layer, or inside the database itself? The good news is that Oracle Database 12c has helped push the argument towards locating the majority of application code within the database through several key feature sets, especially Edition-Based Redefinition (EBR). This session will offer several practical examples of how any Oracle DBA can build a case for and then implement the best practices of the #SmartDB paradigm within their organization while making their application developer colleagues happier than ever.


Oracle 12cR2 Database In-Memory Adventures with Swingbench TPC-DS

Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2

DBA 2.0 Is Dead. Long Live DBA 3.0!


Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime

Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite

DBA, Heal Thyself: Five Diseases of IT Organizations and How to Cure Them

The Wolf is Always At the Door: Oracle Database 12c Security Solutions

Analyze This! Leveraging Oracle 12c Analytic Functions


The Best of Both Worlds: In-Memory Column Store and Advanced Index Compression in Oracle Database

Precisely My Point:  Leverage Attribute Clustering and Zone Mapping in Oracle Database

A Smart Optimizer Gets Even Smarter: Demystifying Oracle 12c Database’s New Histograms

Just SQL Often Needed: Leveraging JSON Features in Oracle Database


How Hot Is My Data? Leveraging Automatic Data Optimization (ADO) Features in 12c Database for Dramatic Performance Improvements

Blink and You’ll Miss It: Migrating, Cloning and Recovering Oracle 12c Databases At Warp Speed

Something Old, Something New: Leveraging Oracle 12c’s Information Lifecycle Management (ILM) Features for Improved Database Performance

Hands-Free Optimization of Complex Queries in Oracle 12c Using AEP, ARO, and SPDs


An Exploration of the Next Generation of the Oracle Database

Parallelize or Perish: Implementing Oracle 11gR2 Parallelism Features for Maximum Performance

When Smart Scan Plays Dumb, Teach Exadata Some New Tricks


2 thoughts on “Presentations

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s