Toad World

Blogs

Iggy Fernandez
Follow /1 May 2016 at 7:00am / Oracle

When SQLT is not enough

When tuning a SQL query, I rely on a SQLT report because it has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, recently I came across a...
1206 0 /
Iggy Fernandez
Follow /30 Apr 2016 at 4:00am / Oracle

How is data modeled in NoSQL?

The first question that you will have when you start your NoSQL journey is “How is data modeled in NoSQL?” The important thing to understand is the data does not change just because it is managed differently. If the data does not change, then...
1017 0 /
Iggy Fernandez
Follow /30 Apr 2016 at 2:00am / Oracle

Why should Oracle Database professionals care about NoSQL and where to start?

Dr. Edgar Codd, the inventor of relational theory wrote in 1986 (thirty years ago): “Only if the performance requirements are extremely severe should buyers rule out present relational DBMS products on this basis.” Of course, he was comparing...
1585 0 /
Iggy Fernandez
Follow /29 Apr 2016 at 2:00pm / Oracle

Why Brian Hitchcock and I (probably) know more about Oracle Database than you‏

Click on the picture to download the latest issue of the NoCOUG Journal Brian Hitchcock’s secret is simple. For twelve years, he has been reading books on Oracle Database. And taking extensive notes. And publishing them in the NoCOUG Journal...
1072 0 /
Iggy Fernandez
Follow /31 Mar 2016 at 11:30pm / Oracle

NoCOUG changes its name (Happy April Fools Day)‏

Click here to register for the first-ever NoCOUG hike APRIL 1, 2016: The board members of NoCOUG met in closed session to discuss the continuing decline in memberships and conference attendance. “This is like global warming, only worse; much...
1280 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle

The company that is most responsible for NoSQL is not Amazon

Surprise! The company most responsible for NoSQL is that relational behemoth Oracle Corporation itself by virtue of its purchase of Sleepycat Software in 2006. In the beginning, there was Berkeley DB: “Berkeley DB originated at the University...
720 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle

Oracle has a complete family of data management products that solve all use cases

At YesSQL Summit 2016, Andy Mendelsohn—Executive Vice President of Database Server Technologies at Oracle Corporation—said “We want to have a complete family of data management products that solve all use cases.” ( http://www.toadworld...
670 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle

The First and Last Word on NoSQL

Amazon had the first word on NoSQL. In Dynamo: Amazon’s Highly Available Key-value Store published in 2007, Amazon said: “For many services, such as those that provide best seller lists, shopping carts, customer preferences, session management...
759 0 /
Iggy Fernandez
Follow /29 Feb 2016 at 2:00pm / Oracle

Make SQL Great Again! (SQL is Huuuuuge) Part VII What is Oracle doing to fend off NoSQL and Hadoop?

Part VII of a lightly-edited partial transcript of a panel discussion titled “Making SQL Great Again (SQL is Huuuuuge)” at YesSQL Summit 2016 organized by the Northern California Oracle Users Group (NoCOUG) at Oracle Corporation’s headquarters...
749 0 /
Iggy Fernandez
Follow /29 Feb 2016 at 2:00pm / Oracle

Make SQL Great Again! (SQL is Huuuuuge) Part VI What is the Oracle Developer Advocates team doing to defend RDBMS?

Part VI of a lightly-edited partial transcript of a panel discussion titled “Making SQL Great Again (SQL is Huuuuuge)” at YesSQL Summit 2016 organized by the Northern California Oracle Users Group (NoCOUG) at Oracle Corporation’s headquarters...
559 0 /