DevOps Azure SQL Devs’ Corner

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

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

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

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

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

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

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

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

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

Practical Azure SQL Database for Modern Developers

Davide Mauri September 2, 2020 Sep 2, 2020 09/2/20

Practical Azure SQL Database for Modern Developers: a book to learn how to take advantage of the all the breakthrough technologies available in Azure SQL like columnstore, in-memory lock-free tables, row-level-security, graph and geospatial support to create modern, scalable and secure applications.

Azure SQL & .bacpac the easy way

Davide Mauri August 31, 2020 Aug 31, 2020 08/31/20

Restoring an Azure SQL database in one - well three - simple scripts: one with Powershell, one with AZ CLI + Bash and one using the ubiquitous SqlPackage

Developing in the cloud with SQL Server Big Data Clusters: Run and Monitor Apps

Melony Qin August 21, 2020 Aug 21, 2020 08/21/20

As the last part of the series of working with big data analytics solutions in Kubernetes, we learned about how to work with cloud-native applications with BDC. Operating and testing are also essential parts as an enterprise-grade solution. This article will walk you through how to run and monitoring apps to SQL Server Big Data Clusters (...

Developing in the cloud with SQL Server Big Data Clusters: Develop and Deploy Apps

Melony Qin August 14, 2020 Aug 14, 2020 08/14/20

Kubernetes is designed to support an open platform to support a diverse variety of containerized workloads including both stateless and stateful and data-processing workloads. Technically any application can be containerized, it can be up and running in Kubernetes. As a cloud-native platform, Kubernetes is available to deploy cloud-native ...

DevOps for Azure SQL

Arvind Shyamsundar May 20, 2020 May 20, 2020 05/20/20

DevOps is a broad term with multiple technology and process options at hand. Read this post for an overview of what DevOps for Azure SQL means, and review some options for tools and processes to use.

Azure SQL Devs’ Corner