Azure Data Studio

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

Data API Builder Quickstart Demo from VS Live Vegas

March 28, 2023 Mar 28, 2023 03/28/23

Brian Spendolini

I was fortunate enough to be able to present Data API builder the week of March 20th at VS Live in Las Vegas and what an incredible group of attendees at that conference. During my session, I stepped through a live demo of Data API builder showing off REST and GraphQL endpoints on various database objects. This blog post contains the steps I ...

Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt

December 5, 2022 Dec 5, 2022 12/5/22

Brian Spendolini

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

Connecting the Dots of Azure SQL CICD Part 2: Local Development

November 7, 2022 Nov 7, 2022 11/7/22

Brian Spendolini

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

Azure SQL Devs’ Corner