Skip to content

SYSTEM Cited by 1 source

Microsoft SQL Server

Microsoft SQL Server is Microsoft's commercial OLTP relational database — the dominant Windows-native enterprise OLTP engine and one of the big-three commercial RDBMSs alongside Oracle and IBM Db2. On this wiki, SQL Server surfaces primarily as a CDC source database for streaming-ingest pipelines.

Stub page — expand on future SQL Server-internals sources.

CDC mechanism (architectural note)

SQL Server exposes change data capture via its native change tables mechanism: enabling CDC on a source table materialises the per-row insert / update / delete deltas into a dedicated system table that consumers read. This is the SQL Server-native analogue of MySQL's binlog and Postgres logical replication; the general pattern is the same CDC substrate.

Seen in

Last updated · 470 distilled / 1,213 read