Every developer should know how to design a relational or a dimensional database. Nevertheless, there are still many advanced problems which are commonly solved in an inappropriate or at least inefficient way, or even not solved at all, because there is no solution out of the box in SQL Server. In addition, although the relational model is more than 40 years old and the dimensional model is also more than 30 years old, there are still many common myths and urban legends around them. In this seminar, we are going to deal with some of the most advanced problems and bust many common myths. The topics include:
  • Database design myths
  • Graphs in a relational database – basics, constraints
  • Optimizing general graphs and spatial data
  • Dynamic relational schema
  • Temporal data in SQL Server
  • Optimizing temporal data
Presented by Dejan Sarka at SQLBits XII