Features
Built for SMB reality: fewer moving parts, safer defaults, clearer visibility.
Operator-friendly
Integrity sweeps
Regular verification (checksums, scans) with calm reporting.
Visibility
Designed to be inspectable: pages, WAL, transaction timeline, and health signals.
Developer-focused
Business transaction metadata (TxMeta)
Add human-readable names/categories/severity to transactions without breaking ADO.NET usage.
Replay-safe DML (Idempotency)
Provide a RequestId so client retries don’t create duplicate writes; replays return the original outcome.
Temporal history & point-in-time
Opt-in WITH HISTORY keeps an automatic change record; query any table AS OF a past moment.
Data governance
Self-documenting schema
Attach descriptions to tables and columns directly in DDL or via SQL commands. The engine auto-tracks all DDL changes and can generate full schema documentation on demand.
Business process tracking & comparison
Tag DML operations with business process identifiers and JSON metadata. Trace operations by process ID. Compare table state across time points to detect drift.
Self-documenting system tables
Eight System.* tables — including System.SchemaHistory and System.ProcessLog — make a database instance self-describing and safer to operate.