What is the ACID Property in a database? A classic interview question, with Atomicity, Consistency, Isolation and Durability explained in plain words.
What Is NewSQL? Distributed SQL Databases Explained
What is NewSQL? It’s the name for relational databases that spread data over many servers and still give you SQL and ACID transactions. This post walks one orders table through key ranges, replicas and a majority vote.
Relational Database in Big Data: Still at the Center
The relational database in big data projects is still the system of record, and most analytics platforms copy their core business data from it. This post shows what a relational database does well, where it sits in a modern platform, and how the SQL Server 2025 json type adds a flexible schema next to ordinary tables.
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.
ACID Properties Shown With Real Transactions
ACID properties shown With Real Transactions uses short SQL Server scripts to explain atomicity, consistency, isolation, and durability.
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
ACID stands for Atomicity, Consistency, Isolation and Durability, the four properties every reliable database needs. Each one explained in a line or two.