The Database Doctor

Diagnosing relational database problems and helping troubled database designers recover from NoSQL trauma.

News

• Finding things in Data Models with Property Bags
  When designing database schemas, you may find yourself in need of creating a property bag table that is in a … Read more
• LAST_VALUE and FIRST_VALUE Window Aggregate tricks
  When writing code for analytical databases, there comes a point where you learn that window aggregates often allow you to … Read more
• What is a good database key?
  A central value add of modeling databases for analytical purposes and speed is that you can restore the sanity, often … Read more
• Row or Column based Storage?
  These days, columnar storage formats are getting a lot more attention in relational databases. Parquet, with its superior compression, is … Read more
• Recommended Reading List
  This page maintains my list of recommended reading if you are interested in learning about databases. This is very much … Read more