This blog post is a bit of a different post than the normal blog posts which I write as the topic of this blog post is SQL Terms vs MongoDB Terms.
Big Data Upgraded: The 2013 Series Rewritten for Today
Big Data Upgraded is the reading path for 23 articles, most of them first written in 2013, now rewritten for today’s tools. Most new platforms now build on Spark, Parquet, open table formats and change data capture. Here is the whole set in reading order, with one line on each.
Key-Value and Document Databases: When Each One Fits
Key-Value and Document Databases are two NoSQL models. One finds a value by its key, the other stores a whole JSON document you can query by any field. This post shows when each one fits and builds both patterns in SQL Server 2025 with a key-value table and the json data type.
What Is NoSQL? Data Models, the CAP Theorem and Trade-Offs
What Is NoSQL? It is a family of data models other than the classic table, each built for one kind of access pattern. This post covers the four data models, eventual consistency and the CAP theorem in plain words, and how to choose.
SQL or NoSQL for a New Project
Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.
Relational, Document, Graph and Vector: Choosing the Right Data Model
Choosing the Right Data Model means matching the shape of your data to the questions you ask. This post stores one bookshop four ways in SQL Server 2025, with relational tables, JSON documents, graph tables and a vector column, and runs the question each one answers best. It ends with a rule for choosing.