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 256: The Community Episode
Episode 255: Automate Complex CRUD with sp_CRUDGen
Episode 254: Code Smell Checks with sp_Develop
Episode 253: Go Mobile with Power Apps
Episode 252: The Cumulative Update Dilemma
Episode 251: Azure Cognitive Services
Episode 250: What happens before... “COMPANEROS!”
Episode 249: Data Marts in Power BI
Episode 248: Inventory Documentation
Episode 247: Pushing the Boundaries or Pushing Your Luck
Episode 246: Microsoft Build 2022 Announcements
Episode 245: Tooling Updates
Episode 244: Extended Events vs SQL Server Audit
Episode 243: Choosing What Content To Focus On
Episode 242: Upgrading Your SQL Server
Episode 241: Replicating Data with Azure SQL Data Sync
Episode 240: Azure Synapse Link
Episode 239: Bi-directional HA/DR to Azure SQL
Episode 238: Getting Started with Power BI - Part 2
Episode 237: Getting Started with Power BI - Part 1
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