DevOps

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

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

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

Planning new scenarios and use cases for Azure SQL Database local development experience!

May 24, 2022 May 24, 2022 05/24/22

Silvano Coriani

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

Welcome to the new Azure SQL Database local development experience!

May 24, 2022 May 24, 2022 05/24/22

Silvano Coriani

The “inner loop” in software development workflows is the process of writing, building, debugging and testing code, usually on a local workstation or development environment, before sharing it with someone else. In contrast, the “outer loop” kicks off as soon as that code is checked in a source control system from where CI/CD pipelines...

LAUNCH: Build serverless, full stack applications in Azure

May 25, 2021 May 25, 2021 05/25/21

Anna Hoffman

Whether you’re new or seasoned to cloud, development, and SQL, building and architecting applications in the cloud has become a required skill for many roles. Today, we’re excited to announce a new learning path to help developers of all skill levels learn how to create applications quickly and effectively with Azure.

Modern development: creating a REST API, via CI/CD and back

January 4, 2021 Jan 4, 2021 01/4/21

Davide Mauri

Video and sample code to create a end-to-end REST solution with Azure SQL, from zero to the CI/CD pipeline, with Unit Testing too!

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

December 11, 2020 Dec 11, 2020 12/11/20

Arvind Shyamsundar

Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database

December 9, 2020 Dec 9, 2020 12/9/20

Davide Mauri

Importing a SQL Server backup into an Azure SQL Database is not a trivial task. Here's how to automate the process of converting a .bak to .bacpac file using Docker Containers, Powershell and some automation.

Azure SQL Devs’ Corner

DevOps - Azure SQL Devs’ Corner

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

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

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

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

Planning new scenarios and use cases for Azure SQL Database local development experience!

Welcome to the new Azure SQL Database local development experience!

LAUNCH: Build serverless, full stack applications in Azure

Modern development: creating a REST API, via CI/CD and back

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database