Did you know that Edgar F. Codd is considered the father of the relational model that is used by most database systems? He authored papers on both relational calculus and normal forms in the 1970s. It is especially important to know where the history of where today’s technology comes from. The Fabric Warehouse does support a subset of Microsoft’s Transact Structured Query Language (T-SQL). However, the Fabric storage engine (OneLake) is based upon the delta lake file format. With this knowledge, we can understand why one design pattern performs well over another one.
Business Problem
Our manager has asked us