Azure SQL Database

Azure SQL Devs’ Corner

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

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.

Fast loading data into Azure SQL: a lesson learned.

September 14, 2020 Sep 14, 2020 09/14/20

Davide Mauri

I'm preparing a series of post and samples on how to properly load data into Azure SQL using Azure Databricks / Apache Spark that I will start to publish very soon, but I realized today that there is a pre-requisite that in many cases, especially by developers new to the data space, is overlooked: good table design. Wait! If you're not a...

Use Linked server to Synapse SQL to implement Polybase-like scenarios in Managed Instance

June 24, 2020 Jun 24, 2020 06/24/20

Jovan Popovic

Serverless Synapse SQL pool enables you to query files on Azure Data Lake Storage. Azure SQL Managed Instance can use linked servers to query data on Azure Storage using Synapse Analytics serverless SQL query endpoint. This technique linked server may be good solution for some Polybase-like scenarios.