The point that keeps cropping up here is that anERD document is useful in the short term until the individual learns the system. The benefit the individual gets from the...

The whole point of these models is that they are communication tools and I've found that people generally want one and curse the fact that one doesn't exist but are...

I have Aspergers. I have had to learn to think about peoples motives and what will enable them to understand my point of view and to accept that even...

I think the first thing to do is look at your use case, identify the pain points and see if the proposed solution addresses more pain than it solves.

OLTP does...

Where there are utility procs such as those used to test for absent clustered indexes, primary keys, use of reserved words etc it makes sense to install these in the...

I'd say that a business should upgrade at the latest time possible but while it is still a choice rather than a diktat. An upgrade should take place when...

Hmm... I guess why I find this topic so interesting is that I keep hearing this "the consequences will dire" statement about not using foreign keys and I just don't...

If you are the person who will bear the consequences then if you are willing to do so then you can do without foreign keys. Chances are that if...

If I have to paint an 8ft x 16ft wall then I can tell you with a fair degree of accuracy how long it will take having painted several such...

Thanks Solomon. The strange additions to the characters in the alphabet can be dealt with by a function called ASCII folding. In the Apache Commons library the Daitch...

Hive and Pig both generate map reduce code under the hood. Where optimisation is required you can grab the output code and adjust it to your needs.

Hive has something...

I do take exception to the comment made in the article:

While I understand the pressure to adopt a SQL like language I do think it is a mistake to base...

That is why I'm optimistic about graph...