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...

I don't believe Array.Clear() is doing what you expect it to do. The MS documentation says it sets a range of array elements to a default value. I don't think...

And as with surfing the time it goes well makes the 100 times you fell worth while.

Until someone of suitable authority ring fences quality control and says "short cut and descope what you like but thorough testing is non-negotiable" this will continue to happen.

In theory testers...

If you want to understand how something works try and change it.

I've been playing around with NOSQL for long enough to know that if you choose the right tool for...