Books online state: “There is nothing a graph database can achieve, which cannot be achieved using a relational database.” Why then are we putting graph technology in SQL Server? To help me answer this question, I invite my friend AZ to chat about the Graph feature in SQL Server 2017 and introduce how graph differs from a relational model. If you have every tried to implement complicated hierarchies in SQL Server, you know what a pain this can be. I, for one, am hopeful this new feature will allow us to tackle the various relationships even though it may be lacking certain features compared with other graph databases.
Are you using graph technology in SQL Server or even another platform? I would be very interested to getting your thoughts on what you like and what you still find painful.
The show notes from today's episode can be found at http://sqldatapartners.com/2018/03/28/episode-129-graph-databases. Have fun on the SQL Trail.
Episode 195: Understanding DAX
Episode 194: PolyBase Use Cases
Episode 193: Power BI Premium
Episode 192: The DBA is Dead! Long Live the DBA!
Episode 191: Power BI Row-Level Security
Episode 190: SQL Server 2019
Episode 189: Power BI Common Data Model
Episode 188: Databricks
Episode 187: Power BI Performance Tuning
Episode 186: Analytics & Security: Find Pain Points, Make a Plan
Episode 185: DBATools in a Month of Lunches
Episode 184: Where do people get stuck with Power BI?
Episode 183: SQL Server Big Data Clusters
Episode 182: XEvents
Episode 181: Paginated Reports in Power BI
Episode 180: PolyBase in SQL Server 2019
Episode 179: SQL Trail Recap & Buying Power BI
Episode 178: Database Design
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast