Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

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

December 14, 2020 Dec 14, 2020 12/14/20

Drew Skwiers-Koballa

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

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.

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

December 10, 2020 Dec 10, 2020 12/10/20

Jovan Popovic

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 amounts of data placed on Azure.

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.

Autoscaling with Azure SQL Hyperscale

December 3, 2020 Dec 3, 2020 12/3/20

Davide Mauri

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

Azure SQL Devs’ Corner

December 2020 - Azure SQL Devs’ Corner