Here we are at the last part for this series. To recap, in the first 2.5 parts of this series (part 1, part 2, part 2.5) I focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In the …
The first 2.5 parts of this series (part 1, part 2, part 2.5) focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In this part, we shift over to R and imbed the SQL Server cursor script …
Quick post tonight. While working on some examples to test out the cursor I posted in Part 2, I realized that I had only coded the cursor to retrieve information for the dbo schema. So here I present the revised cursor which pulls from any schema. If a table is part of the dbo schema …
This is part two of a series about diagramming SQL Server graph databases in R. In the first part, I covered setting up a simple graph database in SQL Server, with just a handful of tables to use as a test bed for this series. The database had one edge (enrolledIn). I have revised the …
Welcome to the first of several articles covering generating diagrams in R of Microsoft SQL Server graph databases. A little theoretical background is in order before diving into the mechanics. In relational databases, tables typically connect or join based on a unique value in one table to another table where the same value may appear …
Short tip this time around. If you are running SQL Server on Linux and connect to it from a Windows system with Management Studio (SSMS), the SQL Agent will be off. If you right click the Agent in SSMS try to get the properties of it, you will receive a lengthy error with this included: …