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… Read more
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… Read more
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… Read more
Oracle 10.2.0.1 (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,… Read more