The Data Modeling Essentials seminar explains the relational model for transactional databases and the dimensional model for data warehouses. However, even the best logical model can’t help when the physical implementation is bad. Therefore, the seminar shows in details how SQL Server stores and accesses data, and how to optimize the relational and the dimensional model.
Besides the seminar, you are also welcome to join my conference sessions:
- High performance statistical queries
- Temporal data in SQL Server
- Minimally logged (bulk) inserts
- SQL Server data mining
- Market basket analysis