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

May 2018 Leaderboard of Database Systems contributors on MSDN

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

Author: Estienne Granet Date: 06/25/2018

Quick-start script: Setup Azure network environment for Azure SQL Managed Instance

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

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

Cross-instance point-in-time restore in Azure SQL Database Managed Instance

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

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

Clustered Columnstore Index: Massively Parallel Trickle Insert

A traditional scenario of loading data into CCI is a nightly load from one or more data files...

Author: Sunil Agarwal Date: 06/04/2018

Create database on Azure SQL Managed Instance using Azure.Rm PowerShell library

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

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

Change size of Azure SQL Managed Instance using PowerShell

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

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

Updating Azure SQL Managed Instance properties using ARM templates

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

Author: Jovan Popovic (MSFT) Date: 05/23/2018

April 2018 Leaderboard of Database Systems contributors on MSDN

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

Author: Joseph Sack Date: 05/16/2018

Creating Azure SQL Managed Instance using ARM templates

Azure API enables you to create Azure SQL Managed Instance using ARM templates. These are JSON...

Author: Jovan Popovic (MSFT) Date: 05/15/2018

Meet the Azure SQL Database team at Microsoft Build Conference

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

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

How Azure SQL Database makes database management easier?

Azure SQL database is a platform as a service SQL Server Database Engine hosted in Azure cloud and...

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

Azure SQL Database – scalability

Azure SQL Database is a flexible Platform as a service database that can be easily scaled to fit...

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

Azure SQL Database – the database engine that cannot die

Azure SQL Database is highly available database Platform as a Service that guarantees that your...

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

Calling Http endpoints in T-SQL using CURL extension

SQL Server Database Engine don't have built-in functions that would enable you to send information...

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

March 2018 Leaderboard of Database Systems contributors on MSDN

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

Author: Joseph Sack Date: 04/09/2018

Monitoring performance of natively compiled stored procedures - database-scoped configuration options

We just added new database-scoped configuration options that will help with monitoring performance...

Author: Jos de Bruijn [MSFT] Date: 04/04/2018

How to configure network for Azure SQL Managed Instance

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

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

Demo - Azure SQL Database Managed Instance in action

Azure SQL Database Managed Instance is new data service in Azure cloud that exposes fully-managed...

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

How to configure tempdb in Azure SQL Managed Instance(preview)

Azure SQL Database Managed Instance (public preview) is a fully-managed SQL Server instance in Azure...

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

What is Azure SQL Database Managed Instance?

Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that represents fully...

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

February 2018 Leaderboard of Database Systems contributors on MSDN

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

Author: Joseph Sack Date: 03/06/2018

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer),  Vijay Kannan...

Author: Joseph Sack Date: 02/15/2018

New Windows container images of SQL Server 2017 on Windows Server 1709!

The Windows Server Core container images of SQL Server 2017 Developer & Express based on Windows...

Author: Perry Skountrianos - MSFT Date: 02/11/2018

January 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our January 2018 top 10 contributors! Alberto Morillo and Visakh Murukesan...

Author: Joseph Sack Date: 02/09/2018

JSON in SQL Server - Use cases

JSON support in SQL Server 2016+ and Azure SQL Database enables you to combine relational and NoSQL...

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

Simplify REST API development for modern Single-page apps with SQL Server

JSON functionalities that are added in SQL Server 2016 and Azure SQL Database enable application...

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

Simplify data access using de-normalized models

Classic relational databases enable you to create highly normalized data models with schema that...

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

Working with Azure IoT data in Azure SQL Database

IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these...

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

Compatibility Level 140 is now the default for Azure SQL Database

Database compatibility level 140 is now the default for new databases created in Azure SQL Database...

Author: Joseph Sack Date: 01/10/2018

Database scoped optimizing for ad hoc workloads

SQL Server provides the “optimize for ad hoc workloads” server-scoped option that is used to reduce...

Author: Joseph Sack Date: 01/04/2018

Injecting JSON objects into existing JSON text with JSON_MODIFY function

JSON_MODIFY function that is available in SQL Server 2016+ enables you to modify existing text...

Author: Jovan Popovic (MSFT) Date: 12/22/2017

Transitive closure clustering with CLR and JSON

Transitive closure is a graph algorithm that tries to follow paths in graph edges and tries to find...

Author: Jovan Popovic (MSFT) Date: 12/20/2017

Storing JSON documents in SQL Database

SQL Server and Azure SQL Database have native JSON functions that enable you to parse JSON documents...

Author: Jovan Popovic (MSFT) Date: 12/19/2017

Building SQL REST API back-end for Angular apps

JSON support in SQL Server/Azure SQL is designed to make integration between the relational database...

Author: Jovan Popovic (MSFT) Date: 12/18/2017

ASP.NET Session State with SQL Server In-Memory OLTP

ASP.NET session state enables you to store and retrieve values for a user as the user navigates the...

Author: Perry Skountrianos - MSFT Date: 11/28/2017

JSON vs CLR UDT - performance comparison

Ability to create custom user defined types in CLR and use them in SQL Server is introduced in SQL...

Author: Jovan Popovic (MSFT) Date: 11/15/2017

In-Memory OLTP Indexes - Part 2: Performance Troubleshooting Guide.

Introduction In the previous blog post In-Memory OLTP Indexes – Part 1: Recommendations, we gave you...

Author: kunalkaroth Date: 11/14/2017

JSON parsing is faster than Spatial equivalent

One of the most common assumption when people talk about JSON in SQL Server is that it is slow...

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

JSON parsing 10x faster than XML parsing

Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON...

Author: Jovan Popovic (MSFT) Date: 11/13/2017

Azure SQL Database: Ingesting 1.4 million sustained rows per second with In-Memory OLTP & Columnstore Index

As Internet of Things (IoT) devices and sensors are becoming more ubiquitous in consumer, business...

Author: Perry Skountrianos - MSFT Date: 11/08/2017

In-Memory OLTP Indexes - Part 1: Recommendations.

In-Memory OLTP Indexes In-Memory OLTP technology, available in Azure SQL Database and SQL Server,...

Author: kunalkaroth Date: 11/02/2017

In-Memory OLTP Updated Overview and Case Studies

We just published updated slide decks about In-Memory OLTP. In-Memory OLTP overview: this is an...

Author: Jos de Bruijn [MSFT] Date: 11/02/2017

Sentiment analysis with Python in SQL Server Machine Learning Services

One very popular machine learning scenario is text analysis. In this blog post, we will show you two...

Author: Nellie Gustafsson Date: 11/01/2017

Configure Azure Storage for SQL Database backups

SQL Server 2012+ and Azure SQL Managed Instance support native BACKUP commands that can backup a...

Author: Jovan Popovic (MSFT) Date: 10/17/2017

Native database backup in Azure SQL Managed Instance

Azure SQL Managed Instance is a new fully managed PaaS offering in Azure cloud that will be publicly...

Author: Jovan Popovic (MSFT) Date: 10/16/2017

SQL Server 2017 available for download

Final version of SQL Server 2017 is available for download. New version of SQL Server has a lot of...

Author: Jovan Popovic (MSFT) Date: 10/02/2017

Announcing general availability of Native Scoring using PREDICT function in Azure SQL Database

Today we are announcing the general availability of the native PREDICT Transact-SQL function in...

Author: Umachandar Jayachandran - MS Date: 09/25/2017

Default compatibility level 140 for Azure SQL databases

As of this writing, the default compatibility level for new databases created in Azure SQL Database...

Author: Joseph Sack Date: 08/24/2017

Demo: Identify and fix plan change regression in SQL Server 2017 RC1

Plan change regression happens when SQL Database changes a plan for some T-SQL query, and the new...

Author: Jovan Popovic (MSFT) Date: 07/20/2017

Monitoring automatic tuning actions using XEvents

SQL Server 2017 can automatically tune your queries by identifying and fixing SQL plan change...

Author: Jovan Popovic (MSFT) Date: 07/18/2017

<Previous Next>