Introduction

• High performance transactional systems
  • Enforces ACID transactions
• Strong security + tooling
• Tight integration with .NET / Azure
• Uses T-SQL (Transact-SQL)

Locking & Concurrency Model

MSSQL uses:

• Locks (row, page, table)
• Latches (in-memory protection)

Isolation levels:

• READ COMMITTED (default)
• REPEATABLE READ
• SERIALIZABLE
• SNAPSHOT

// Snapshot isolation = versioning via tempdb