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!

Seasons of Serverless Challenge 3: Azure TypeScript Functions and Azure SQL Database serverless

Drew Skwiers-KoballaDecember 14, 2020Dec 14, 202012/14/20

Throughout the next seven weeks we'll be sharing a solution to the week's Seasons of Serverless challenge that integrates Azure SQL Database serverless with Azure serverless compute. Learn how to develop an Azure Function that leverages Azure SQL database serverless and TypeScript with Challenge 3 of the Seasons of Serverless challenge.

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.

Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables

Jovan PopovicDecember 10, 2020Dec 10, 202012/10/20

Serverless Synapse SQL pool in Azure Synapse Analytics is a T-SQL query engine that enables you to read the files placed on Azure storage. You can easily integrate your Azure SQL engine with Synapse SQL to delegate big data analytics and analyze large amount of data placed on Azure.

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.

Autoscaling with Azure SQL Hyperscale

Davide MauriDecember 3, 2020Dec 3, 202012/3/20

Azure SQL Hyperscale is the latest architectural evolution of Azure SQL, which has been natively designed to take advantage of the cloud. One of the main key features of this new architecture is the complete separation of Compute Nodes and Storage Nodes. This allows for the independent scale of each service, making Hyperscale more flexible and...

Seasons of Serverless Challenge 1: Azure Functions and Azure SQL Database serverless

Drew Skwiers-KoballaNovember 30, 2020Nov 30, 202011/30/20

Throughout the next seven weeks we'll be sharing a solution to the week's Seasons of Serverless challenge that integrates Azure SQL Database serverless with Azure serverless compute. Learn how to develop an Azure Function that leverages Azure SQL database serverless with Challenge 1 of the Seasons of Serverless challenge.

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.

Testing performance of Azure SQL Database as a key-value store

Dimitri FurmanOctober 20, 2020Oct 20, 202010/20/20

Executive summary Our testing shows that Azure SQL Database can be used as a highly scalable low latency key-value store. Starting with a cost-efficient 4-core General Purpose database, we see an order of magnitude increase in workload throughput as we increase dataset size by 100x and scale across the spectrum of database SKUs to a Business ...

Serverless Streaming At Scale with Azure SQL

Davide MauriOctober 19, 2020Oct 19, 202010/19/20

Just before Ignite, a very interesting case study done with RXR has been released, where they showcased their IoT solution to bring safety in buildings during COVID times. It uses Azure SQL to store warm data, allowing it to be served and consumed to all downstream users, from analytical applications to mobile clients, dashboards, API, and...