Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

How to copy data from Azure SQL Managed Instance to Microsoft Fabric DW

July 5, 2023 Jul 5, 2023 07/5/23
Jovan Popovic
If you want to perform advanced analytics on your data and create stunning reports in Power BI, you should consider using Microsoft Fabric. Microsoft Fabric is a solution that combines the best data warehousing and data lake technologies to provide a scalable, secure, and cost-effective platform for data analytics. With Microsoft Fabric, you ...

Vector Similarity Search with Azure SQL database and OpenAI

June 4, 2023 Jun 4, 2023 06/4/23
Davide Mauri
Vector databases are gaining quite a lot of interest lately. Using text embeddings and vector operations makes extremely easy to find similar “things”. Things can be articles, photos, products...everything. As one can easily imagine, this ability is great to easily implement suggestions in applications. From providing suggestions on ...

Model your Supply Chain in a Graph Database | Part 2

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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.

Model your Supply Chain in a Graph Database | Part 3

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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 enriching data.

Model your Supply Chain in a Graph Database | Part 4

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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, make discoveries, and make informed decisions. With SQL Graph, we combine the familiarity of Azure SQL with the advantages of graph modeling, providing clarity and precision when communicating with stakeholders.

Implement Change Data Streams with Azure SQL Database, Change Tracking, and Azure SQL Bindings

May 15, 2023 May 15, 2023 05/15/23
Brian Spendolini
Building on my first Azure SQL Bindings blog post and taking inspiration from Drew Skwiers-Koballa's post on SQL Bindings, we are going to create a change data stream with Azure SQL Database. Now, usually, the first part of these blogs is a prerequisite section that goes over what you need to install locally to get started. From talking to ...

Change Tracking in Azure SQL Database

May 1, 2023 May 1, 2023 05/1/23
Brian Spendolini
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...

Using Ledger in Azure SQL Database

April 24, 2023 Apr 24, 2023 04/24/23
Brian Spendolini
Transactions have to be protected and you need to know when something is altered or prevent altering of records from the start. Ledger, available in Azure SQL Database and SQL Server 2022, helps to protect your database and establish trust, accuracy and integrity in your data. Ledger accomplishes this goal in a couple of ways. First, it ...

Make data more human with Azure OpenAI and Azure SQL

April 14, 2023 Apr 14, 2023 04/14/23
Valentina Alto
In January 2023, Microsoft announced the General Availability of the Azure OpenAI Service (AOAI), which allows Azure customers to access OpenAI models directly within their Azure subscription and with their own capacity. (image) There are four models families available at the moment:   (image) In this ...