I work on certifications more for me than anything else. If forces me to learn the depth and breadth of the product, esp. true with Microsoft's exams.

What has impressed...

The use of schemas is common in Oracle because small "databases" in Oracle tend to be implemented within a single instance, each owned by a separate schema. This, along...

I agree with AdiCohn's type of approach.

The standard ODBC Canonical format (the convert function style: 120) is yyyy-mm-dd hh:mi:ss(24h) and never needs to be converted back from that format in...

I like this idea, Oracle has a similar command but their version is unfortunately structured in a way that makes it difficult (if not impossible) to code against.

But very useful...