Visual Studio Code

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

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

Connecting the Dots of Azure SQL CICD Part 1: Getting Started

October 24, 2022 Oct 24, 2022 10/24/22

Brian Spendolini

Azure SQL CICD Part 1: Getting Started Continuous Integration (CI) and Continuous Delivery/Deployment (CD) are a set of principles or methodologies that empower development teams to deliver code faster, more reliably, and with fewer bugs compared to traditional software development such as the waterfall model. Teams that use...

Azure SQL Devs’ Corner