13 March 2013
13 March 2013

Bridging the Developer/DBA Divide: Advances in Database Source Control

0
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
0
22 November 2012
22 November 2012

Improving Development Processes for Database Teams

0
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.)… Read more
0
16 July 2012
16 July 2012

Hate the player, not the game — or my case for Data Engineers

0
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
0
19 June 2012
19 June 2012

Pascal matrix SQL puzzle solution

0
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
0
27 March 2012
27 March 2012

ORA-01801: Date Format is too Long for Internal Buffer

0
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
0
31 January 2012
31 January 2012

Applied Rapid Development Techniques for Database Engineers

0
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… Read more
0