blog.kdgregory.com

One of the standard practices in database design is to use a “synthetic” primary key — often an auto-increment integer — rather than a ...

I learned something last week: when you start an RDS database instance from a snapshot, the instance's volume isn't copied all ...

When you want to perform a difference operation between two tables, you have a choice: NOT EXISTS with a correlated subquery, or NOT I...