Oracle 12c has arrived

I really didn't think we would be seeing 12c until OpenWorld. I got a nice surprise a couple of weeks ago when people started tweeting that the docs were out. That followed quickly with the actual software being available for download.

 

I realize that people won't really be producing (more...)

OTN Interview on Youtube

Last week, I was interviewed by Bob Ruhbart of the Oracle OTN blog. He's also known as oracletechnet on twitter.

When to consider sharding a MySQL database

Uncategorized
| Mar 13, 2013

When to consider sharding a MySQL database

 

Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is required to maintain acceptable performance. So when is the right time to shard your database?

 

When to consider sharding a MySQL database   Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is […]

-->

The Three Major Areas of Difference Between MariaDB and MySQL

Uncategorized
| Mar 11, 2013

This entry and my next will be a little different from what I normally write. This info comes from some research I did recently into MySQL.

 

The Three Major Areas of Difference Between MariaDB and MySQL

 

An unresponsive web site is as good as asking your customers to leave. According to surveys, almost 50% of web users expect a page to load in less than 2 seconds, and 4

8 Steps for Source Control Perfection

Uncategorized
| Mar 8, 2013

Red

What’s all the fuss about Big Data?

Uncategorized
| Mar 6, 2013

What’s all the fuss about Big Data?


Big Data is the collective term for very large and potentially complex data sets that are deemed to be so large that it’s difficult to handle the data using traditional tools and applications such as Relational Database Management Systems. Scientists in the fields of physics, genetics and meteorology were previous examples of those that encountered Big Data.

 

However,

Oracle ACE Cookbook

Uncategorized
| Mar 5, 2013
This is a FOOD cookbook, not a code cookbook.

Netbeans 7.3 Available

Uncategorized
| Feb 25, 2013
Are you a netbeanie?

First 750 Books and Reviews

Uncategorized
| Feb 16, 2013
So I started a new web site called First 750. A blog really. It's a site where writers can list their books, where I will be doing book reviews and where others can submit reviews. I have a few author interviews coming soon.

10 Signs that your project may be doomed

Uncategorized
| Feb 14, 2013
Version control is a USB stick and a guy named Sahib

Interview with Yalim Gerger (CEO Formspider – the PL/SQL Web Framework)

Uncategorized
| Feb 12, 2013
In every other profession having a 20 year experience is a good thing, in ours you are treated as a has-been who is kept around only to maintain the legacy system. This is insane.

Beyond The Fence

Uncategorized
| Feb 10, 2013

My house butts up against a park. It's an animal and bird preserve and there s a spring that feeds the Alifia river.

 

I was sitting on the back swing with my younger son and something started shaking the bushes on the other side of the fence.We got to joking around and I said it was probably an escaped monkey. My older son came out and we started making jokes and decided it was probably a goblin.

 

From that I decided to write a short story

Tables of the Heapish Variety – Tables 101

Uncategorized
| Jan 30, 2013

A table is the basic storage unit in an oracle database. A table stores the data that you think of when you think of a database.

 

A heap table is the default table type in Oracle. When we refer to a table, we are usually refering to a heap table. A heap table is just a table that stores the data in no partiuclar order. It just heaps the data on.

 

A heap table can be a relational table or an object table. A relational table is a t

MauDweeb: Database Architects of Dune, Chapter 1

Uncategorized
| Jan 24, 2013

This is a flashback to 2007. My Apologies to Frank Herbert and his estate.

Any road followed precisely to its end leads precisely nowhere. Climb the mountain just a little bit to test that it's a mountain. From the top of the mountain, you cannot see the mountain. 

      From MuaDweeb: Family Commentaries by the Princess Irulan 


Summoned! Summoned to meet with the local representatives of the Bene Management. To discus

Schema and User 101

Uncategorized
| Jan 22, 2013

Schemas and users are frequently used interchangeably as if they were the same thing. For the most part, that's ok. In Oracle the concepts are so tightly coupled that thinking of them as the same thing is not really that far wrong. 


In reality, a user is a database account that is given a password and permissions. A schema is a container, or namespace, for containing schema objects. Schema objects are things like tables, views and indexes.


In Oracle, when a us