Erik Darling takes an academic concept and explains what it means in practice for SQL Server. Erik does a good job describing the concepts of atomicity, consistency, isolation, and durability. I do agree with Erik’s take on consistency, which tends to be the property that database platforms minimize in return for scalability. The descriptions of all four are good, though Erik has a lot more content that digs into consistency and isolation.