‘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
In part 1 of this interview we talked at length about what it took for Lashana to make it into tech, her recognition by the then President to a huge audience, and related. In the second part I asked her some questions regarding her advice for women in tech and various situations we have to… Continue reading Vajrasara – An interview with Lashana Lewis – Part 2
I have been impressed by profiles of women invited to the annual Women-in-Technology luncheon at the PASS summit in the recent past. When the announcement comes out, I normally look up who the person is and read about them. When PASS offered an opportunity, as an official blogger at the summit this year – to… Continue reading Vajrasara – an interview with Lashana Lewis – Part 1
In the last post I covered briefly the history around graph databases. In this one am going to look at the structure. There have been a lot of blog posts written up about structure of graph tables in SQL Server. I really like this series by my friend Niko Neugebauer. The simplest way to understand… Continue reading Graph Data – Basic Structure
I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages – although I also believe it is important to understand the background/origin/ and how it was done before. In this series I will start with the history… Continue reading Graph Databases – Introduction
The session line up for PASS Summit 2019 was announced today…there are so many good sessions to go to..managing time and what we do with our limited time there is an important skill..to some extent. I’d say it is partly skill, and partly luck to get the most out of it. We can control the… Continue reading PASS Summit 2019 – Getting the most out of it
One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are good with ambitious goals – ‘I want to do data science’, ‘I want to learn Linux for SQL’, ‘I want to be an AI expert’..this and… Continue reading Pathways to Progress
Last month I was fortunate to have my first ever article published on Simple-Talk, among the best quality website for sql server articles ever. During the process of writing this article I ran into several errors related to temporal tables that I have not seen before. Some of these are documented by Microsoft, some are… Continue reading Temporal tables – list of errors with reasons
