DevOps Azure SQL Devs’ Corner

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

Davide MauriJanuary 4, 2021Jan 4, 202101/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 ShyamsundarDecember 11, 2020Dec 11, 202012/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 MauriDecember 9, 2020Dec 9, 202012/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 ShyamsundarOctober 28, 2020Oct 28, 202010/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 MauriSeptember 2, 2020Sep 2, 202009/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 MauriAugust 31, 2020Aug 31, 202008/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 QinAugust 21, 2020Aug 21, 202008/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 QinAugust 14, 2020Aug 14, 202008/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 ShyamsundarMay 20, 2020May 20, 202005/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