Blogs

Iggy Fernandez
Follow /3 May 2015 at 1:00am / Oracle

Fourth International NoCOUG SQL Challenge (teaser announcement)

The Fourth International NoCOUG SQL Challenge will be published in the May issue of the NoCOUG Journal which will be available at http://www.nocoug.org/Journal/NoCOUG_Journal_201505.pdf at 9 AM PDT on Monday, May 11 . Here's a sneak preview: How...
797 0 /
Iggy Fernandez
Follow /29 Apr 2015 at 2:00pm / Oracle

Eventual Consistency is NOT a violation of the relational model (says C. J. Date)

C. J. Date was kind enough to comment on my article in the last issue (February 2015) of the NoCOUG Journal (see The Rise and Fall of the NoSQL Empire ). The full text of his remarks will be published in the next issue (May 2015). Here’s a sneak...
455 0 /
Iggy Fernandez
Follow /7 Apr 2015 at 2:00pm / Oracle

The Rise and Fall of the NoSQL Empire (2007–2013)

“Ding, dong! The witch is dead. Which old witch? The wicked witch! Ding, dong! The wicked witch is dead. Wake up sleepy head, Rub your eyes, get out of bed. Wake up; the wicked witch is dead. She’s gone where the goblins go Below, below, below;...
10888 2 /
Iggy Fernandez
Follow /1 Apr 2015 at 2:00pm / Oracle

OT: New Oracle Database features spell doom and gloom for NoSQL

FOR IMMEDIATE RELEASE New Oracle Database features spell doom and gloom for NoSQL SILICON VALLEY (APRIL 1, 2015) – In a move calculated to gladden the hearts of the hardest Oracle Database diehards, Oracle Corporation has released a slew of...
1482 1 /
Iggy Fernandez
Follow /1 Apr 2015 at 2:00am / Oracle

OT: Oracle wants your votes

It used to be that if you had an enhancement suggestion for Oracle Database, you had to file an enhancement request in MOS and pray that the Oracle product management gods would hear your request someday. It is now possible to make your enhancement...
959 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 2:00pm / Oracle

OT: Never buy an Oracle book again (if you live in California)

If you are a resident of California, you are entitled to become a member of the San Jose Public Library (register at https://catalog.sjlibrary.org/selfreg/public ). Library members have access to Safari Books Online and Books24x7 . At last count, there...
970 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 2:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 37: POISED: A problem-solving method

Previous installment: The sisters of the mother of all SQL antipatterns First installment: DON’T PANIC P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance...
588 0 /
Iggy Fernandez
Follow /23 Mar 2015 at 2:00pm / Oracle

OT: A software tool that improves my writing

I would like a little more help with my writing than the Spelling & Grammar check in Microsoft Word can provide so I am checking out a tool called Word Rake . Here is the first paragraph of the third post in this series The Impossible Dream (and Why...
757 0 /
Iggy Fernandez
Follow /2 Mar 2015 at 5:10am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 36: The sisters of the mother of all SQL antipatterns

SECOND WITCH. Fillet of a fenny snake, In the caldron boil and bake; Eye of newt, and toe of frog, Wool of bat, and tongue of dog, Adder's fork, and blind-worm's sting, Lizard's leg, and owlet's wing,— For a charm of powerful trouble...
1574 0 /
Iggy Fernandez
Follow /7 Feb 2015 at 8:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 35: Robust v/s optimal query execution plans

Previous installment: SQL Aaargh! Next installment: The sisters of the mother of all SQL antipatterns First installment: DON’T PANIC In a prior post The Mother of All SQL Antipatterns , I suggested that the best solution for the ad-hoc query...
1436 0 /