DevOps

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.

Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines

October 28, 2020 Oct 28, 2020 10/28/20

Arvind Shyamsundar

Multi-stage pipelines in Azure DevOps offer a rich, declarative, YAML-based mechanism to implement and customize Continuous Delivery for Azure SQL.

Azure SQL Devs’ Corner

DevOps - Azure SQL Devs’ Corner

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

Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines