Showing tag results for T-SQL

Following on the series of OpenAI posts I have done recently, here is a quick how-to on using DALL-E with External REST endpoint invocation in the Azure SQL Database. Using the OpenAI service in Azure, we can use the image generation REST endpoints to create new and wonderful images such as, if you remember, the cat in the data center. So ho...

On behalf of the Engineering and Product Management teams, we are happy to announce that External REST Endpoint Invocation is now GA!   What is External REST Endpoint Invocation? External REST Endpoint Invocation makes it possible for developers to call REST/GraphQL endpoints from other Azure Services from right in the Azure SQL Database....

Summer 2023 REST Endpoint Invocation Update Welcome to the Summer 2023 REST Endpoint Invocation update post! This summer, we updated the External REST Endpoints Invocation feature with a few key fixes and additions to help you use more Azure Services with your Azure SQL Database. The feature was released to public preview last year and this late...

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...

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...

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.

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.

The Azure SQL Database has two main ways to track changes with data (rows/DML) as well as table changes. One of those methods is Change Tracking with the other being Change Data Capture. Today’s post will be going into depth on Change Tracking. Change Tracking and Change Data Capture So, what’s the difference between the two? Change Data Capture ...

I've just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is quite a common question, and it is time to give it a simple, concise, and clear answer, once a...

In part 3 of our Azure SQL database change management (CICD) series we cover testing your code using tSQLt and GitHub Actions. Prerequisites Check Refer to part 1 and part 2 for the prerequisites. Fork the GitHub Project We will be using tSQLt in this post, so I have created a GitHub project made up of several SQL Da...