Dominic Delmolino


For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application development processes. Time and time again I’ve encountered poorly performing database systems whose foundations were laid in the impedance mismatch between application developers and database developers. While ORMs are the most prominent area of mismatch, I’ve chosen to focus on… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

This video is a follow up to the webinar broadcast by Red Gate on 14th November 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary The journey of a team-developed database, from initial development to successful deployment to production, involves many stages. Regardless of the specific development methodology employed (ITIL, Scrum, etc.)… Continue Reading →

Application Development, Database Development, Webinar

Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for the better part of your career, you may be wondering why the technologies you work with everyday seem to be acquiring such a bad rap. From NoSQL to No DB the current influx of brogrammers seem to take extreme pride in describing… Continue Reading →

Application Development, Database Administration, Database Development

I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided some very nice commentary on the problem, complete with diagrams and 2 alternative solutions. I thought I’d walk through my solution in order to explain my thought process and see if it resonates with anyone. Usually when I think about… Continue Reading →

Application Development, Database Development, PL/SQL

Oracle (I know, version out-of-date) on Windows 2003: The other day one of my stored procedures error’ed out with: ORA-01801: date format is too long for internal buffer somewhere near a line in which I was doing the following assignment: d := to_char(c.date_field,’YYYYMMDD’); Where d is of type varchar2, and c is a row from a cursor for loop,… Continue Reading →

Database Administration, Database Development, Troubleshooting

This article is based on the webinar delivered on 22 Nov 2011. You can read the full article below including the Q+A or: Download a PDF version Watch a video recording: Applied Rapid Development Techniques for Database Engineers In this article, Dominic Delmolino describes his experience in implementing a rapid refactoring and professional schema management process using standard software development… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database, Video, Webinar