development

5 in 5 Vizualization 2 - Generating a d3.js visualization from a SQL Developer HTML report...

This second vizualization is more of a workflow proof of concept compared to some novel visualization but I can guarantee you haven't seen the SCOTT.EMP table like this before. I have wanted to combine my two favorite tools for a while. Here is how you can drive a d3.js visualization directly from a SQL Developer custom report.

Food for thought - Who Should Tune SQL - DBA or Developer?

Iggy Fernandez covers the topic of who is better suited to tune SQL - Developers or DBAs. Also listed are 5 Dangerous Beliefs which may influence the answer to that question.

https://iggyfernandez.wordpress.com/2009/07/12/who-should-tune-sql-the-dba-or-the-developer/

-Dave

For Developers: Making Friends with the Oracle Database - presentation by Cary Millsap

Here is a link to a Cary Millsap presentation -- a must read for developers who interact with Oracle Databases. This article can save you some time and heartache!

http://method-r.com/papers/file/10-for-developers-making-friends-with-th...

From the Abstract:

Perl has been Eclipsed...

I've been using TextPad for writing Perl programs forever. TextPad is a pretty lightweight editor with a lot of decent features. Its nice because you can set up a PL document class with a syntax file to enable highlighting whenever you edit a *.pl file.

But today I'm working on a more complicated script with multiple functions. My main requirement is that there be an outline view so I can quickly jump between functions.

Agile Development for Database Schemas

I've recently been working on improving the Database Change procedures and Deployment procedures where I work. We like to turn around releases every 2-4 weeks or so but sometimes the friction of keeping a sane and organized development process slows us down. At this point I would rather be slow than to introduce errors to our production environments but I am always looking for ways to improve accuracy and speed of our processes.

Subscribe to development