---
tag: sql
articles: 8 · beats: 3
latest: November 17, 2026
---

Sql

8 Crashtech articles on Sql, spanning System Design & Architecture, Databases and Development Best Practices, published in November 2026. Every piece is full-text HTML with sources, structured data and an authored FAQ.

They span System Design & Architecture (6), Databases (1), Development Best Practices (1). System Design & Architecture Databases Development Best Practices

Databases5 min

Relational Database Design Guide: Keys, Relationships, Normalization, and Joins

A comprehensive guide to relational schema design, primary and surrogate keys, normal forms (1NF to BCNF), and indexing join performance trade-offs.

Archivists route records from a divided city map to separate shelves, illustrating shard keys and data placement.
System Design & Architecture2 min

Database Sharding Guide: Horizontal Partitioning, Shard Keys, and Cross-Shard Joins

Why databases resist horizontal scaling: deep dive into database sharding, range vs hash vs directory strategies, cross-shard joins, and resharding.

Polyglot database architecture visualization with relational tables and vector point clouds
System Design & Architecture4 min

Database Types Guide: Storage Models, Access Patterns, and Polyglot Persistence

A practical guide to modern database types: relational, columnar, key-value, document, time-series, graph, and vector engines matching storage to workloads.

System Design & Architecture5 min

Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity

What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.

Development Best Practices3 min

Pessimistic vs Optimistic Locking: Choosing by How Often Your Writes Collide

Lock first or check at commit? Version columns, SELECT FOR UPDATE, retry logic and the contention numbers that decide which strategy fits.

System Design & Architecture4 min

Relational Schema Design That Survives Contact With Production

Keys, relationships, constraints and indexes: the schema decisions that decide integrity and speed, with worked SQL for one-to-many and many-to-many.

System Design & Architecture3 min

Database Normal Forms, Worked Through One Ugly Table

1NF to 4NF are easier to remember as the specific anomaly each one removes. One messy orders table, fixed step by step, shows what each form is for.

System Design & Architecture3 min

What Actually Happens Between You Hitting Enter and Rows Coming Back

A SQL query passes through five stages before you see a row: connection, parsing, planning, execution, storage. What each does and where it breaks.

Questions we answer about Sql

Frequently asked questions

What does Crashtech publish about Sql?

8 articles tagged Sql, the most recent published November 17, 2026. They span System Design & Architecture (6), Databases (1), Development Best Practices (1). Each carries numbered sources, an authored FAQ and full structured data.

What questions about Sql does Crashtech answer directly?

10 questions have a dedicated answer page under this tag, including “What is the core distinction between database replication and database sharding?”. Each answer is authored prose from the article it belongs to, not a generated summary.

Can AI assistants read Crashtech's Sql coverage?

Yes. Crashtech serves full static HTML to every crawler, allows all major AI user agents in robots.txt, and publishes an llms.txt manifest plus a full-text corpus, so assistants can retrieve and cite these articles directly.