MOC: SQL Server
This chapter is organized around the three jobs people actually do with SQL Server in production:
- operate and maintain the server
- create and shape databases, tables, and storage structures
- write and optimize queries
A fourth track collects the applied pipeline patterns built on top of those foundations.
Server Operations and Maintenance
Connectivity, instance configuration, backup and restore, security, high availability, audit, incident triage, and estate-level operational review.
Database Design, Tables, and Storage
domain-database-design-and-storage
Database creation, schema and table design, keys and constraints, change tracking, storage internals, index design, compression, partitioning, and maintenance.
Query Writing and Optimization
domain-query-writing-and-optimization
Core T-SQL reference, execution plans, Query Store, waits, blocking, deadlocks, race conditions, and production query optimization workflows.
Applied SQL Server for Data Pipelines
domain-applied-sql-server-pipelines
Loading patterns, incremental transforms, medallion implementation, pipeline anti-patterns, point-in-time integrity, and pipeline operability guidance.
SQL Server Cross-References
- DB Queries — SQL Server query notebooks with executable examples
- GCP — SQL Server VMs on Compute Engine
- Terraform — Provisioning SQL Server infrastructure
- Data Architecture — Medallion architecture theory
- 25_py_functional_pipeline — Python pipeline using SQL Server as the persistence layer