Partager via


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

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

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

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

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

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

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

Date: 03/04/2019

Measuring file io performance on Managed Instance using QPI

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

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

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

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

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

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

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

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

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

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

Date: 11/12/2018

Introducing Scalar UDF Inlining

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

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

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

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

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

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

Date: 10/01/2018

August 2018 Leaderboard of Database Systems contributors on MSDN

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

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

Date: 09/25/2018

Introducing Batch Mode on Rowstore

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

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

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

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

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

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

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

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

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

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

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

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

Date: 07/23/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...

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

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

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

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

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

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

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

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

Date: 06/27/2018

Next>