22-25 April 2026 
SQLBits 2012
Luke I’m your father - Hierarchies in SQL Server
Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). See typical business problems and how they are solved in SQL Server.
Hierarchies are the bread and butter of most business applications (departmental diagram,
product categories, sales territories, calendar, …). Markus offers insights
into best practice through typical business problems in his samples (e.g. hierarchy
through different tables, parent-child-hierarchy, datatype hierarchieID,
hierarchy as slowly changing dimension, hierarchy in LINQ and MDX, …).
Speakers
Markus Ehrenmüller-Jensen's previous sessions
Introduction to Graph Processing with SQL Server 2017
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Luke I’m your father - Hierarchies in SQL Server
Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). See typical business problems and how they are solved in SQL Server.