SQL Graph: best practices for easily modelling & querying complex data models by Arvind Shyamsundar

Session Title: SQL Graph: best practices for easily modelling & querying complex data models
Speaker(s): Arvind Shyamsundar

Abstract: Have you struggled with how to represent a “many-to-many” relationship in relational tables? Has your mind been strained in the process of writing a recursive CTE to query a hierarchy? Have you given up trying to implement core graph algorithms efficiently in T-SQL?

For all these cases, and more, SQL Graph provides an elegant way to model a graph (nodes and edges) built-in T-SQL support (MATCH / SHORTEST_PATH) to help with pattern matching and recursive path finding in such a graph. In this session we will use examples derived from real-world cases where SQL Graph has been used to ease development effort and enable new types of workloads on Azure SQL DB, Azure SQL Managed Instance, and SQL Server.