Tag: cook‑book
Finding things in Data Models with Property Bags
When designing database schemas, you may find yourself needing to create a property bag table that is in a 1-n relationship with an entity table. It isn't always viable to just add more a...
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 express complex joins in new ways. Sometimes, they even allow...