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 ...
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...
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 ...
(image)
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 ...
Azure SQL Database is a fully managed platform as a service (PaaS) relational database service. With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to...
Join us for part two of our Azure SQL database change management (CICD) series. This post covers local development environments with Visual Studio Code.
Prerequisites Check
For Database Projects to deploy correctly, we need to have the .NET Core SDK installed.
You can get it here with a direct link for windows x64 here.
You can also ...
At Microsoft Build 2022 we've announced the new Azure SQL Database local development experience to the world. The combination of Visual Studio Code and Azure Data Studio extensions in addition to the new Azure SQL Database emulator for local and offline database development are aimed to significantly improve developers' experience and boost ...
We are excited to announce the general availability (GA) of change data capture (CDC) in Azure SQL Database.
What is Change data capture (CDC)?
CDC provides historical change information for a user table by capturing both the fact that Data Manipulation Language (DML) changes (insert / update / delete) were made and the changed data. ...
This article showcases how to take advantage of a highly distributed framework provided by spark engine, to load data into a Clustered Columnstore Index of a relational database like SQL Server or Azure SQL Database, by carefully partitioning the data before insertion.
Serverless Synapse SQL pool in Azure Synapse Analytics is a T-SQL query engine that enables you to read the files placed on Azure storage. You can easily integrate your Azure SQL engine with Synapse SQL to delegate big data analytics and analyze large amounts of data placed on Azure.