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