Wiki Articles

I have some obsolete Wiki pages that are of technical and historical interest. It's too hard to migrate the articles over here into the blog, so here are some links to them instead:

Azure Table Storage as an RDB

A curious discussion of how I attempted to use Azure Table Storage like a relational database. It basically worked acceptably well by using combination of code generation, async coding conventions and a trick to generate auto-increment keys. However, as the code grew more complex I started to feel progressively more like I was abusing the technology and I eventually dropped the idea.

Database History and Design

Many years ago I had a popular page in my personal web site that described how I designed and normalized the SQL Server database tables for the Nancy Street collections database. The original page has been partly reproduced and modernised to describe the design of the most recently used database.

Migrating away from SQL Server

In early 2018 I abandoned using SQL Server for my collections database. By migrating to Cosmos DB I underwent an epiphany about how many different database choices we have available now. Is your data best represented as simple tables, relational tables, documents, a hierarchy or a free-form node graph? There is something for you!

Orthogonal Programming