Blogs

Iggy Fernandez
Follow /7 Apr 2015 at 1: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;...
10088 2 /
Iggy Fernandez
Follow /1 Apr 2015 at 1: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...
1417 1 /
Iggy Fernandez
Follow /1 Apr 2015 at 1: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...
911 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 1: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...
539 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 1: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...
911 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...
711 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...
1485 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...
1384 0 /
Iggy Fernandez
Follow /7 Feb 2015 at 7:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 34: SQL Aaargh!

Previous installment: The mother of all SQL antipatterns? Next installment: Robust v/s optimal query execution plans First installment: DON’T PANIC The biggest problem with SQL query optimization is that semantically equivalent SQL queries are...
1224 0 /
Iggy Fernandez
Follow /5 Feb 2015 at 9:00pm / Oracle

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

“Beware the Jabberwock, my son! The jaws that bite, the claws that catch! Beware the Jubjub bird, and shun The frumious Bandersnatch!” —from Through the Looking-Glass and What Alice Found There by Lewis Carroll Previous installment...
1760 0 /