Category: Data Modeling
OLTP and OLAP design, dimensional modeling, star schemas and the modeling decisions that make analytics fast and trustworthy.
-
OLTP vs OLAP: Designing Models That Serve Transactions and Analytics Without Compromise
The same SQL Server cannot be tuned for 2,000 writes a second and a ten-table aggregate at once. Understanding why OLTP and OLAP pull in opposite directions is the key to designing both well, and to knowing when columnstore, mirroring or a lakehouse is the right bridge.
-
Dimensional Modeling in 2026: Kimball Still Wins, and Where It Needs Help
Lakehouses, Direct Lake and AI agents did not retire the star schema; they made it more important. What still holds from the Kimball toolkit, what has changed, and the handful of modern additions a dimensional model needs today.
