A Game of Hierarchies - Graph Processing with SQL Server 2019

Explore graph processing and hierarchical data structures in SQL Server 2019 through this conference talk from PASS Data Community Summit. Dive into the world of hierarchies and graphs, essential components in business applications such as product categories, sales territories, bill of materials, and networks. Learn best practices for transforming self-referenced hierarchies and graphs into valuable information using SQL Server's Graph Database feature, introduced in SQL Server 2017 and enhanced in SQL Server 2019. Discover how to effectively query and manipulate hierarchical data structures using loops, recursive Common Table Expressions, and the new Graph Database approach. Engage with practical examples based on G. R. R. Martin's "Game of Thrones" to illustrate these concepts in a fun and relatable manner. Gain insights into optimizing your database queries and improving the flexibility of your hierarchical data models.

A Game of Hierarchies: Graph Processing with SQL Server 2019 - Markus Ehrenmueller-Jensen