Blogs

Iggy Fernandez
Follow /28 Aug 2015 at 1:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 39: Unfriending the optimizer statistics

Previous installment: Shakespeare’s advice for database upgrades First installment: DON’T PANIC “Heigh-ho, sing heigh-ho, unto the green holly. Most friendship is feigning, most loving mere folly. Then heigh-ho, the holly. This life...
774 0 /
Iggy Fernandez
Follow /10 Jul 2015 at 2:00pm / Oracle

OT: Some advice for beginning Oracle Database professionals

And if you don’t know Which to Do Of all the things in front of you, Then what you’ll have when you are through Is just a mess without a clue … —Winnie the Pooh in The Tao of Pooh, by Benjamin Hoff Excerpts from the first...
1323 0 /
Iggy Fernandez
Follow /5 Jul 2015 at 6:28am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 38: Shakespeare’s advice for database upgrades

Previous installment: POISED: A problem-solving method First installment: DON’T PANIC “ Those friends thou hast, and their adoption tried, Grapple them unto thy soul with hoops of steel; But do not dull thy palm with entertainment Of each...
1080 0 /
Iggy Fernandez
Follow /7 Jun 2015 at 9:00pm / Oracle

OT: How to interview an Oracle DBA candidate (NOT)

Yesterday T.J. wrote on the Oracle-L mailing list : “ For those of you who have conducted job interviews, what sort of questions have you found to be effective in evaluating a candidate’s skill level?” I remember the interview at...
1312 0 /
Iggy Fernandez
Follow /1 Jun 2015 at 5:49am / Oracle

OT: Update on the Fourth International NoCOUG SQL Challenge (Part III)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-challenge . Chris Goerg submitted the following MODEL-clause solution. The use of two measures (named cd...
1242 0 /
Iggy Fernandez
Follow /1 Jun 2015 at 5:35am / Oracle

OT: Update on the Fourth International NoCOUG SQL Challenge (Part II)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-challenge . The NoCOUG challenge does not come with a fixed data set such as the 10 dates in the Cheryl’s...
1120 0 /
Iggy Fernandez
Follow /1 Jun 2015 at 5:28am / Oracle

OT: Update on the Fourth International NoCOUG SQL Challenge (Part I)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-challenge . The previous NoCOUG SQL challenges ( First , Second , Third ) were about devising clever algorithms...
759 0 /
Iggy Fernandez
Follow /29 May 2015 at 2:00pm / Oracle

OT: Get your next job through Twitter?

From Gwen Shapira’s interview in the May 2015 issue of the NoCOUG Journal : “I got my current job at Cloudera through Twitter. At the time, I was working with a retailer in Japan, as a consultant through Pythian. I was there to help...
742 0 /
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...
972 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...
615 0 /