Azure SQL Devs’ Corner

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.

Microsoft.Data.SqlClient 2.0.0 is now available

June 19, 2020 Jun 19, 2020 06/19/20

Davide Mauri

Microsoft.Data.SqlClient version 2.0.0 has been released, with several interesting features. Make sure you check it out if you are a .NET developer and you are using Azure SQL or SQL Server in your solutions. Microsoft.Data.SqlClient is the new, open source, official data access library that replaces System.Data.SqlClient

Go Azure SQL!

June 16, 2020 Jun 16, 2020 06/16/20

Silvano Coriani

Go is a very popular programming language for developing microservices, Web APIs and other server-side applications, and Azure SQL can definitely be an option where to persist data for these applications in a scalable, reliable and modern way leveraging Microsoft SQL Server Driver for Go and ORM packages like Gorm. Give it a try!

JSON in your Azure SQL Database? Let’s benchmark some options!

June 10, 2020 Jun 10, 2020 06/10/20

Silvano Coriani

Introduction Storing and retrieving data from JSON fragments is a common need in many application scenarios, like IoT solutions or microservice-based architectures. You can persist these fragments can be in a variety of data stores, from blob or file shares, to relational and non-relational databases, and there’s a long standing debate in...

Improve JDBC application reliability with Azure SQL and connection pooling

June 4, 2020 Jun 4, 2020 06/4/20

Silvano Coriani

A growing number of Azure SQL Database customers are developing new applications in Java using a JDBC driver from Microsoft or a 3rd party. These drivers are providing quite extensive support and covering most of database service capabilities and performance expectations but there are a couple of areas that deserve some attention.

Optimize Azure SQL Upsert scenarios

May 28, 2020 May 28, 2020 05/28/20

Silvano Coriani

Customers often need to move a dataset from a source system into a new destination, inserting rows that doesn't exist in a target table and update those that already exists. With this technique, we've been able to reduce the time needed to upsert a dataset of 2M rows against a target table with 30M rows from 20 hours to 20 minutes. 

DevOps for Azure SQL

May 20, 2020 May 20, 2020 05/20/20

Arvind Shyamsundar

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.

Join us: Azure SQL at Microsoft Build 2020

May 15, 2020 May 15, 2020 05/15/20

Davide Mauri

Don't miss Microsoft Build 2020, this year delivered 100% online and 100% free. Make sure to attend to Azure SQL and SQL Server sessions, to see with your own eyes what you can do with all the features that we packed in these two amazing post-relational databases!

10 reasons to use Azure SQL in your next project

April 25, 2020 Apr 25, 2020 04/25/20

Davide Mauri

There are many database technologies available on Azure that you can choose from. Why would you use Azure SQL? Let me show you why, using just 10 simple points: from JSON support to ColumnStore, through Geospatial and Temporal queries, Non-Blocking transaction, Encryption and Row-Level Security and the amazing Intelligent Query Optimizer.