But the division between SQL and NoSQL is increasingly fuzzy, especially as database developers integrate the technologies together and add bits of one to the other. The genesis of NoSQL ...

JSON is great for moving data around but not so hot when you need to convert it into data stored in a relational database -- it's a problem complex enough that you might consider using a ...

1. Index by workload, not by table Many people make the mistake of just guessing at some indexes to create when they are creating database tables. Without an idea of how the tables are going to be ...

We had formatted a string that looked like {ts 25-4-2002 6:02:58} (as an example) and SQL was barfing on the 4. It wanted 04. and when we fixed that, it barfed on the 6. It wanted 06. Highly annoying.