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. There are four models families available at the moment:   In this post, we will see ...

Data API builder for Azure SQL Databases – Public Preview

March 15, 2023 Mar 15, 2023 03/15/23
Davide Mauri
I am extremely happy and excited to announce the public preview of Data API builder for Azure SQL Databases. Data API builder is a new product that we are adding to the developer’s toolset to help every developer to be more efficient and effective, by instantly and securely turning Azure SQL Databases into a modern REST and GraphQL API. ...