Posts by this author

May 17, 2023
1

Model your Supply Chain in a Graph Database | Part 1

In this article, we'll explore the fascinating intersection of supply chains and graph databases. We'll explore the intricacies of supply chains, understand their complexities, and explore the practical benefits of utilizing graph databases for modeling and optimizing these networks.

Azure SQL
May 17, 2023
1

Model your Supply Chain in a Graph Database | Part 2

In Part 2 of our series, we explore the practical aspects of enabling SQL Graph for modeling supply chains, including creating tables for nodes and edges and inserting data into them. We also introduce the MATCH keyword for querying graph data, simplifying the retrieval of information based on relationships between entities.

Azure SQL
May 17, 2023
2

Model your Supply Chain in a Graph Database | Part 3

In Part 3 of our series, we delve into the rewards that graph databases bring to supply chain modeling. We explore the clarity achieved through the MATCH keyword, enabling precise communication between technical and business teams. Validation becomes seamless as stakeholders intuitively analyze the graph, uncovering missing relationships and enrich...

Azure SQL
May 17, 2023
0
2

Model your Supply Chain in a Graph Database | Part 4

In Part 4 of our series, we explore the power of graph visualization in understanding and analyzing supply chain data. Using tools like PowerBI and the force-directed graph visual, we transform our SQL Graph data into an interactive and shareable format. The visualization allows us to easily comprehend the relationships within the supply chain, mak...

Azure SQL
Jan 21, 2021
3
0

Solving the River Crossing problem with SQL Graph

Graph theory and associated techniques are extremely powerful. Azure SQL allows native representation of graphs as node and edge tables, and provides breadth-first-search traversal for native path finding. This blog post demonstrates the ease of use, and great power of, these features by using them to solve the classic river crossing riddle!

Azure SQL
Dec 11, 2020
1
4

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

Azure SQLDevOps.NET
May 20, 2020
5
1

DevOps for Azure SQL

DevOps is a broad term with multiple technology and process options at hand. Read this post for an overview of what DevOps for Azure SQL means, and review some options for tools and processes to use.

Azure SQLDevOps