I’ve been at the bloggers table for two years now. I felt honored to be selected this year too. The day has started a bit differently – bloggers were given an overview of what to expect from the board and staff of PASS. It was a very different and great move, in my opinion. It… Continue reading PASS Summit 2019: Day 1 Keynote – my takeaways

In the previous post I explored a query on how to construct a basic family tree with sql graph – including table set up and queries. In this post am going to explain how to query this to get relationships and some clues on DNA/ethnic mix.1 Relationships: We can use the ‘shortest path’ clause to… Continue reading Geneology with SQL Graph – Part II

This month’s T-SQL Tuesday is hosted by my friend across the pond – Alex Yates. Alex has a fantastic topic for us to blog about – he asks us to talk about why we changed our mind, on anything related to our careers. What was our original opinion, why we believed that, and what we… Continue reading T-SQL Tuesday: Changing my mind

‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between any two points, referred to as nodes in graph databases. The algorithm that helps you find the shortest distance between node A and node B is… Continue reading Graph – Shortest Path

In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with their relational counterparts. The main goal behind a graph design is to help you answer queries – so what are the questions you’d ask of a… Continue reading Simple Graph Queries

In the previous post on this we saw what is a basic graph data structure, and the layout of an example – a movie database with it. In this I am going to explain how to convert that design into graph tables. The SQL Server graph architecture is explained really well here. I already have… Continue reading Creating Graph tables