Data Platforms & Analytics

H19 SQL ❤️ Multimodel Schemas

03/25/2027

2:45pm - 4:00pm

Level: Introductory

Jerry Nixon

SQL Server Product Manager

Microsoft

SQL Server continues to expand beyond a single way of modeling data. In this session, we will look at multimodel schema design across relational tables, documents, graph relationships, vectors, spatial data, and time-based data patterns. We will explore how these models can work together in one database, allowing developers to choose the right shape for each part of the application without splitting data across disconnected systems.

You will leave with a practical view of how SQL Server supports flexible schema design while preserving queryability, governance, indexing, security, and operational consistency.

You will learn:

  • How SQL Server supports multimodel schemas across relational, document, graph, vector, spatial, and temporal patterns.
  • When to use each model and how to combine them within a single application architecture.
  • How indexing, query patterns, security, and governance apply across different data shapes in SQL Server.