cneumuel

11 ms·

1.
by cneumuel 8y ago
Right. There are many Oracle internals experts who are presenting at conferences, they are also quite approachable. I'd especially recommend Tanel Poder, several of his troubleshooting sessions are available on youtube.
2.
by cneumuel 8y ago
For Oracle, there is https://livesql.oracle.com
3.
by cneumuel 9y ago
Not only ADA itself is far from dead. PL/SQL is a descendent of Ada and a niche language used in the Oracle RDBMS, but it has a TIOBE index of 18.
4.
by cneumuel 10y ago
There are several unit testing frameworks for PL/SQL. Code in the database encapsulates business logic, it gives you unified access from all clients. It can also be orders of magnitude faster. The presentation linked here https:/
5.
by cneumuel 10y ago
That's not how it's supposed to work. You want DBAs to be able to tune the existing data model with indexes and materialized views. The optimizer should be smart enough to rewrite queries and, in your case, look up the necessary d
6.
by cneumuel 10y ago
This reminds me of Nassim Taleb's barbell risk management strategy: Avoid the middle in favor of the extremes. For investments, it means a combination of very conservative plus some high risk investments to win big. He applies it to ma
7.
by cneumuel 10y ago
Disclaimer: APEX dev team member here. Independent of APEX and even the Oracle database, if you are not using stored procedures, you are not using the database efficiently. See e.g. this presentation for a performance analysis: https:&#x2F
8.
by cneumuel 10y ago
Working for the man (and in DB dev), I am obviously biased. However, I'd be interested in what you actually find horrible to use and compared to what.
9.
by cneumuel 10y ago
Right, and just in case anyone is in doubt, the ratio for cattle is also 50/50. There is no sexing that I am aware of, but if someone is a vegetarian and drinks milk, they are still supporting the schnitzel industry.