Daily Archives: December 1, 2025

Don’t Let Corner Cases Drive Your Design

If you graph computer/query cost against the size of data, you can get four quadrants: small data, small compute (most CRUD app queries) small data, big compute (complex BI queries for this quarter, most reporting) big data, small compute (logs, … Continue reading

Posted in Editorial | Tagged | Leave a comment

Reverse Engineering a Physical Model Diagram

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical diagram from an existing database. This post looks at the experience. … Continue reading

Posted in Blog | Tagged , , , | 1 Comment