A chronological history of research, tool evaluations, presentations and papers written for the local Oracle communities in which I’ve lived. Email me if a link is dead.
Tool Reviews and Comparisons
Embarcadero’s RapidSQL (from 2001)
Allround Automation’s PL/SQL Developer (from 2005)
KeepTool’s Hora (from 2007)
PL/SQL IDE Comparison Matrix (from 2008)
PL/SQL IDE Comparison Matrix Template (fill in with your own group of IDEs being compared)
Findings of Text Comparison/Difference Tools (from 2011)
Database Modeling Tools Comparison Matrix (from 2011)
DDL Script to check modeling tool reverse engineering compatability with well-known Oracle features
Slides and Papers from Speaking
Note on link convention:
doc/docx = Microsoft Word white paper
ppt/pptx = PowerPoint slide presentation. Sometimes the slides have notes, but usually less detail than a paper.
pdf = Portable Document Format white paper (pre-2011), or PowerPoint or Prezi converted to PDF
prezi = Interactive, flash-based, “Prezi” presentation; a user-controlled fly-through of a landscape with slides embedded in it. Too bad it used a technology that relied on Flash.
| Year | Event/Outlet | Topic | Links |
| 2001 | Online | Using LDAP as an Oracle Professional | [pdf] |
| 2003 | RMOUG | Collections | [ppt][pdf][folder] |
| 2008 | IOUG | PL/SQL Application Frameworks for Custom Systems | [pdf][pdf] |
| 2008 | RMOUG | PL/SQL Application Frameworks for Custom Systems | [ppt][doc][list] |
| 2009 | RMOUG | Hidden Gems of Oracle Text | [pptx][pdf] |
| 2010 | IOUG | Lazy Application Architecture (Frameworks) | [pdf][pdf] |
| 2010 | SORT | Reusable Models and Frameworks | [pptx] |
| 2010 | UTOUG | Dynamic Debugging | [pptx] |
| 2010 | UTOUG | Lazy Application Architecture (Frameworks) | [pptx] |
| 2011 | RMOUG | Oracle Streams AQ: Lessons from the Trenches | [pptx][pdf] |
| 2012 | IOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [pptx][prezi][pdf] |
| 2012 | RMOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [pptx][docx] |
| 2012 | SORT | Writing Great PL/SQL for Database Applications | [prezi] |
| 2012 | UTOUG | Dynamic Debugging & Instrumentation of Production PL/SQL | [pptx] |
| 2012 | UTOUG | Writing Great PL/SQL for Database Applications | [pptx][prezi] |
| 2013 | RMOUG | Writing Sweet PL/SQL! | [prezi][pdf] |
| 2014 | RMOUG | How to Write Awesome PL/SQL | [prezi] |
| 2014 | SORT | Data Layer Decisions | [pptx] |
| 2014 | UofU | Data Modeling: Lessons from the Trenches | [prezi] |
| 2014 | UTOUG | How to Write Awesome PL/SQL | [prezi] |
| 2014 | UTOUG | Mastering PL/SQL Programming | [pptx] |
| 2015 | UofU | Data Modeling: Lessons from the Trenches (repeat) | [prezi] |
| 2015 | UTOUG | Data Layer Decisions | [pptx][pdf] |
| 2016 | RMOUG | PL/SQL: From Newbie to Knowledgeable (8 hr course) | [slides] |
| 2016 | UTOUG | PL/SQL: From Newbie to Knowledgeable (8 hr course) | [pptx][slides] |
| 2016 | UTOUG | Stateful to Stateless: Modernizing with JSON and PL/SQL | [pptx][pdf][slides] |
| 2016 | UTOUG | Doh! How Do I Get My Data Back? | [slides] |
| 2016 | ODTUG | Stateful to Stateless: Modernizing with JSON and PL/SQL | [pptx][pdf] |
| 2017 | UTOUG | Save the Company by Modeling Data Right | [pdf] |
| 2018 | UTOUG | Enterprise-Grade PL/SQL | [pptx][pdf] |
| 2023 | UTOUG | Document Modeling for Relational Modelers | [pptx][pdf] |