SQL Database Engine Blog

This is the blog of the engineering team managing and developing the Database Engine for SQL Server and Azure SQL Database

Our new Azure SQL Database blog site is live

Follow us in our new blog site going forward:...

Author: Ajay.MSFT Date: 03/28/2019

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed...

Author: Jovan Popovic (MSFT) Date: 03/11/2019

Running Azure CosmosDB queries from SQL Server using ODBC driver

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic...

Author: Jovan Popovic (MSFT) Date: 03/11/2019

Monitor local storage usage on General Purpose Azure SQL Managed Instance

Azure SQL Managed Instance has predefined storage space that depends on the values of reserved...

Author: Jovan Popovic (MSFT) Date: 03/08/2019

Sending resource alerts on Managed Instance using db_mail

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or...

Author: Jovan Popovic (MSFT) Date: 03/06/2019

Analyzing wait statistics on Managed Instance

Wait statistics are information that might help you understand why the query duration is long and...

Author: Jovan Popovic (MSFT) Date: 03/05/2019

Reduced recompilations for workloads using temporary tables across multiple scopes

SQL Server 2019 introduces several performance optimizations which will improve performance with...

Author: Joseph Sack Date: 03/04/2019

Measuring file io performance on Managed Instance using QPI

Checking file performance and comparing performance characteristics between SQL Server database...

Author: Jovan Popovic (MSFT) Date: 03/04/2019

We are moving!

This blog is in the process of being migrated to one of the new consolidated SQL Server and Azure...

Author: Pam Lahoud Date: 03/04/2019

Azure Stream Analytics now supports Azure SQL Database as reference data input

Reference data is a dataset that is static or slow changing in nature which you can correlate with...

Author: Ajay.MSFT Date: 02/04/2019

Getting started with Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and...

Author: Jovan Popovic (MSFT) Date: 01/23/2019

Recreate dropped database on Azure SQL Managed Instance

Azure SQL Database - Managed Instance is fully-managed PaaS service that provides advanced...

Author: Jovan Popovic (MSFT) Date: 01/21/2019

Azure SQL Managed Instance Business Critical tier is Generally Available

We are happy to announce General availability of Business Critical tier in Azure SQL Managed...

Author: Jovan Popovic (MSFT) Date: 12/04/2018

Modify Azure SQL Database Managed Instance using Azure CLI

Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With...

Author: Jovan Popovic (MSFT) Date: 11/14/2018

Create Azure SQL Managed Instance using Azure CLI

Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure...

Author: Jovan Popovic (MSFT) Date: 11/14/2018

Diagnostic Data for Synchronous Statistics Update Blocking

Consider the following query execution scenario: You execute a SELECT query that triggers an...

Author: Joseph Sack Date: 11/13/2018

What Azure permissions are required to create SQL Managed Instance?

Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is...

Author: Jovan Popovic (MSFT) Date: 11/12/2018

Public preview of derived tables and views on graph tables in MATCH queries

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities for modeling...

Author: Shreya Verma Date: 11/07/2018

Introducing Scalar UDF Inlining

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt...

Author: Karthik Ramachandra [Microsoft] Date: 11/07/2018

Meet the Azure SQL Database team at PASS Summit 2018

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen,  Joachim Hammer,...

Author: Ajay.MSFT Date: 11/05/2018

SQL Server IaaS Extension Query Service for SQL Server on Azure VM

SQL Server IaaS Extension is installed by default on Azure virtual machines deployed from SQL Server...

Author: Mine Tokus Altug Date: 10/25/2018

Announcing Public Preview of Accelerated Database Recovery

Today we are excited to announce the public preview of Accelerated Database Recovery! Accelerated...

Author: Perry Skountrianos - MSFT Date: 10/16/2018

September 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our September top 10 contributors! Alberto Morillo and Visakh Murukesan maintain...

Author: Estienne Granet Date: 10/08/2018

Analysing inventory of Managed Instances using T-SQL

Sometime you would need to know how many Managed Instance you have created in Azure cloud. Although...

Author: Jovan Popovic (MSFT) Date: 10/01/2018

Public Preview of Graph Edge Constraints on SQL Server 2019

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model...

Author: Shreya Verma Date: 09/28/2018

August 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our August top 10 contributors! Alberto Morillo and Visakh Murukesan maintain...

Author: Estienne Granet Date: 09/25/2018

Storage Configuration Guidelines for SQL Server on Azure VM

SQL Server on Azure Virtual Machines service offers the full control of VM and SQL Server and...

Author: Mine Tokus Altug Date: 09/25/2018

Introducing Batch Mode on Rowstore

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt...

Author: Kevin Farlee [MSFT] Date: 09/24/2018

The easiest way to create Azure VM that can access your Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure...

Author: Jovan Popovic (MSFT) Date: 09/21/2018

Persisting job history in Azure SQL Managed Instance

Azure SQL Managed Instance is a fully managed SQL Server hosted in Azure cloud. Although it supports...

Author: Jovan Popovic (MSFT) Date: 09/20/2018

Meet the Azure SQL Database team at Microsoft Ignite Conference

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen, Joachim Hammer,...

Author: Ajay.MSFT Date: 09/17/2018

What is built-in intelligence in Azure SQL Database?

Azure SQL Database is a fully managed latest stable version of SQL Server Database Engine hosted in...

Author: Jovan Popovic (MSFT) Date: 09/12/2018

Working with Azure SQL Managed Instance using Azure CLI

Azure Command Line Interface (CLI) is a command line library that enables you to quickly and easily...

Author: Jovan Popovic (MSFT) Date: 09/03/2018

Sending emails in Azure SQL Managed Instance

Azure SQL Database Managed Instance enables you to use most of the SQL Server features in fully...

Author: Jovan Popovic (MSFT) Date: 08/31/2018

Create linked server to readable secondary replica in Managed Instance Business Critical service tier

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure...

Author: Jovan Popovic (MSFT) Date: 08/27/2018

Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance

Azure SQL Database Managed Instance is SQL Server implementation on Azure cloud that keeps all...

Author: Jovan Popovic (MSFT) Date: 08/20/2018

Database ownership chaining in Azure SQL Managed Instance

Azure SQL Managed Instance enables you to run cross-database queries the same way you do it in SQL...

Author: Jovan Popovic (MSFT) Date: 08/17/2018

July 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our July top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their...

Author: Estienne Granet Date: 08/10/2018

Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss is a Korea based game development studio established in 2009.  Black Desert Online, a...

Author: Joseph Sack Date: 07/23/2018

Azure SQL Database team at Data Platform Summit 2018

Azure SQL Database Engineering Team (@azuresqldb) represented by (Ajay Jagannathan, and Sunil...

Author: Ajay.MSFT Date: 07/22/2018

Approximate Count Distinct enters Public Preview in Azure SQL Database

Kevin Farlee Principal Program Manager, SQL Database We are pleased to announce the public preview...

Author: Kevin Farlee [MSFT] Date: 07/16/2018

Public Preview of MATCH support in MERGE DML for Graph tables in Azure SQL Database

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model...

Author: Shreya Verma Date: 07/16/2018

Public Preview of Row Mode Memory Grant Feedback in Azure SQL Database

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt...

Author: Joseph Sack Date: 07/16/2018

Public Preview of Table Variable Deferred Compilation in Azure SQL Database

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt...

Author: Joseph Sack Date: 07/16/2018

Validate your Azure network environment for SQL Managed Instance

Azure SQL Managed Instance is a fully managed PaaS SQL Server Database Engine hosted in Azure cloud...

Author: Jovan Popovic (MSFT) Date: 07/12/2018

Using custom types as arrays in T-SQL

One of the missing language features in T-SQL language is array support. In some cases you can use...

Author: Jovan Popovic (MSFT) Date: 07/06/2018

June 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our June top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their...

Author: Estienne Granet Date: 07/05/2018

Deploy Azure SQL Managed Instance network environment using ARM

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. You would...

Author: Jovan Popovic (MSFT) Date: 07/02/2018

Point-in-time restore of a database on Azure SQL Managed Instance using AzureRm.Sql PowerShell library

Azure SQL Database Managed Instance is PaaS version of SQL Server hosted in Azure cloud. Managed...

Author: Jovan Popovic (MSFT) Date: 06/28/2018

Quick-start script: Create Azure SQL Managed Instance using PowerShell library

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure...

Author: Jovan Popovic (MSFT) Date: 06/27/2018

Next>