Articles & Publications
My published MOS Notes
While with Oracle, I wrote over 100 My Oracle Support documents. Here’s a list of the published ones.
Other articles
I’ve written articles for several database and developer blogs, covering both database analysis and programming.
SQL
- Mind the Gaps – Using row generators to fill gaps in data
- Row generators, part 2 and Followup – Which row generator is fastest?
- FizzBuzz – Solve FizzBuzz in SQL
Database Administration
- 10gR2 New Features: RAC Enhancements on OraFAQ.com
- Monitoring Open and Cached Cursors on OraFAQ.com
- RAC Filesystem Options on OraFAQ.com
- Using srvctl to Manage Your 10g RAC Database on OraFAQ.com
- Extending Database Monitoring in Oracle Applications, in the premiere issue of OraTIPS Magazine
- Spice up your SQL Scripts with Variables on OraFAQ.com
- Oracle Auditing, presentation given to Oracle users’ group at Harvard University
Database Analysis & Programming
- Write Time Zone Aware Code in Oracle on DevX.com
- The Oracle 10g Data Pump API Speeds Up the ETL Process on DevX.com
- Integrate COM Component Functionality into your PL/SQL Codebase on DevX.com
- Spice up your SQL Scripts with Variables on OraFAQ.com
- 10gR2 New Features: Asynchronous Commit on OraFAQ.com
- 10gR2 New Features: DML Error Logging on OraFAQ.com
More articles are available in the Scripts section of my 9i/10g Toolkit.