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
Public Preview of Compatibility Level 140 for Azure SQL Database
Today we are announcing the official public preview of compatibility level 140 in Azure SQL...
Author: Joseph Sack Date: 07/07/2017
“What are you waiting for?” – Introducing wait stats support in Query Store
Troubleshooting waits previously. Nobody likes to wait. SQL database is multithreaded system that...
Author: Andrejs anant-MSFT Date: 07/03/2017
Azure SQL databases in logical servers, elastic pools, and managed instances
Azure SQL Database is a Database as a Platform service designed for applications that will use...
Author: Jovan Popovic (MSFT) Date: 06/13/2017
What is plan regression in SQL Server?
Plan regression happens when SQL Server starts using the sub-optimal SQL plan to execute some T-SQL...
Author: Jovan Popovic (MSFT) Date: 06/09/2017
Use WITH clause in OPENJSON to improve parsing performance
OPENJSON function has a WITH clause where you can specify what fields should be extracted from input...
Author: Jovan Popovic (MSFT) Date: 05/29/2017
Automatic plan correction in SQL Server 2017
Automatic plan correction is a new automatic tuning feature in SQL Server 2017 that identifies SQL...
Author: Jovan Popovic (MSFT) Date: 05/17/2017
Automatic index management in Azure SQL database
Azure SQL Database has a built-in intelligence mechanism that can automatically tune and improve...
Author: Jovan Popovic (MSFT) Date: 05/16/2017
"You Shall Not Regress!!!" - How SQL Server 2017 prevents plan regressions?
SQL plan regression is a case when a T-SQL query that executed fine becomes much slower or uses more...
Author: Jovan Popovic (MSFT) Date: 04/25/2017
How to find query plan choice regressions with SQL Server 2017 CTP2
SQL Server 2017 in CTP2.0 version automatically identifies potential performance regressions in SQL...
Author: Jovan Popovic (MSFT) Date: 04/24/2017
Introducing Interleaved Execution for Multi-Statement Table Valued Functions
For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a...
Author: Joseph Sack Date: 04/19/2017
Introducing Batch Mode Adaptive Joins
For SQL Server 2017 and Azure SQL Database, the Microsoft Query Processing team is introducing a new...
Author: Joseph Sack Date: 04/19/2017
Comparing performance of data access libraries using StackExchange/Dapper benchmark
One of the most important questions that you need to answer in your projects is what data access...
Author: Jovan Popovic (MSFT) Date: 03/14/2017
Loading files from Azure Blob Storage into Azure SQL Database
Azure SQL Database enables you to directly load files stored on Azure Blob Storage using the BULK...
Author: Jovan Popovic (MSFT) Date: 02/23/2017
SQL Server 2016 Developer Edition in Windows Containers
We are excited to announce the public availability of SQL Server 2016 SP1 Developer Edition in...
Author: Perry Skountrianos - MSFT Date: 02/21/2017
Parsing 4GB JSON with SQL Server
SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular...
Author: Jovan Popovic (MSFT) Date: 02/14/2017
Import and analyze IIS Log files using SQL Server
IIS generates logs where are recorded many information about HTTP requests such as what Url was...
Author: Jovan Popovic (MSFT) Date: 02/10/2017
Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES
CLUSTERED COLUMNSTORE INDEXES (CCI) provide extreme data compression. In Azure SQL Database and SQL...
Author: Jovan Popovic (MSFT) Date: 02/09/2017
Exporting tables from SQL Server in json line-delimited format using BCP.exe
Line-delimited JSON is one common format used to exchange data between systems and for streaming...
Author: Jovan Popovic (MSFT) Date: 02/09/2017
JSON data in clustered column store indexes
Clustered column store indexes (CCI) in SQL Server vNext and Azure SQL Database support LOB types...
Author: Jovan Popovic (MSFT) Date: 02/09/2017
Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates
SQL product team has made significant improvements in columnstore index functionality,...
Author: Sunil Agarwal Date: 01/11/2017
SQL Server R Services - Why we built it
This is the first post in a series of blog posts about SQL Server R Services. We want to take you...
Author: Umachandar Jayachandran - MS Date: 01/10/2017
Columnstore Index Performance: Batch Mode Execution
Just posted the following blog as part of SQL Tiger team blog. I will continue with this series with...
Author: Sunil Agarwal Date: 01/03/2017
Columnstore Index Performance: Rowgroup Elimination
Author: Sunil Agarwal Date: 01/02/2017
Columnstore Index Perfomance: Column Elimination
https://blogs.msdn.microsoft.com/sql_server_team/columnstore-index-performance-column-elimination/...
Author: Sunil Agarwal Date: 01/02/2017
Transaction Commit latency acceleration using Storage Class Memory in Windows Server 2016/SQL Server 2016 SP1
SQL Server 2016 SP1 adds a significant new performance feature, the ability to accelerate...
Author: Kevin Farlee [MSFT] Date: 12/02/2016
Introducing Batch Mode Adaptive Memory Grant Feedback
SQL Server uses memory to store in-transit rows for hash join and sort operations. When a query...
Author: Joseph Sack Date: 11/29/2016
Columnstore Index: Standard and Express editions with SQL Server 2016 SP1
I am sure you all have heard the exciting news that SQL Server 2016 SP1 supports Common Programming...
Author: Sunil Agarwal Date: 11/19/2016
In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1
We just announced the release of Service Pack 1 for SQL Server 2016. With SP1 we made a push to...
Author: Jos de Bruijn [MSFT] Date: 11/17/2016
CREATE OR ALTER - another great language enhancement in SQL Server 2016 SP1
We are happy to announce that SQL Server 2016 SP1 and SQL Server v.Next have new T-SQL language...
Author: Jovan Popovic (MSFT) Date: 11/17/2016
Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics?
Please refer to this blog under MSSQL Tiger Team blog site...
Author: Sunil Agarwal Date: 11/07/2016
In-Memory OLTP: Is your database just in memory or actually optimized for memory?
Please refer to my blog under MSSQL Tiger Team blogs...
Author: Sunil Agarwal Date: 11/07/2016
Columnstore Index: Which Columnstore Index is right for my workload?
Please refer to the following link for the blog that I posted under MSSQL Tiger Team...
Author: Sunil Agarwal Date: 11/07/2016
Columnstore index: Why do we refer to it as In-Memory Analytics?
Fyi: I posted this blog under MSSQL Tiger Team blog site...
Author: Sunil Agarwal Date: 11/07/2016
SQL Server 2016 Express Edition in Windows containers
We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows...
Author: Perry Skountrianos - MSFT Date: 10/13/2016
Columnstore Index- Should I partition my columnstore Index?
Table partitioning is a perfect way to manage large tables especially in the context DataWarehouse...
Author: Sunil Agarwal Date: 10/04/2016
Columnstore Index: In-Memory Analytics (i.e. columnstore index) Videos from Ignite 2016
I presented two talks on columnstore index during Microsoft Ignite Conference 2016 in Atlanta, GA....
Author: Sunil Agarwal Date: 10/04/2016
In-Memory OLTP Videos: What it is and When/How to use it
In-Memory OLTP is the premier technology for optimizing the performance of transaction processing in...
Author: Jos de Bruijn [MSFT] Date: 10/03/2016
SQL Server 2016 - It Just Runs Faster: Always On Availability Groups Turbocharged
When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to...
Author: Bob Ward (Microsoft) Date: 09/26/2016
Implementing Product Catalogs in SQL Server and Azure SQL database
Product catalog is one of the key scenarios in NoSQL systems. In product catalog scenario, you need...
Author: Jovan Popovic (MSFT) Date: 09/07/2016
JSON is Generally available in Azure Sql Database!
JSON functionalities are now generally available in Azure Sql Database! All functions that are...
Author: Jovan Popovic (MSFT) Date: 09/05/2016
Columnstore Index: Parallel load into clustered columnstore index from staging table
SQL Server has supported parallel data load into a table using BCP, Bulk Insert and SSIS. The...
Author: Sunil Agarwal Date: 07/19/2016
Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index
SQL Server 2016 provides two flavors of columnstore index; clustered (CCI) and nonclustered (NCCI)...
Author: Sunil Agarwal Date: 07/18/2016
Columnstore Index: Differences between Columnstore Index vs BTree index
In earlier blog why columnstore index, we had discussed what is a columnstore index and why do we...
Author: Sunil Agarwal Date: 07/17/2016
Increased Memory Size for In-Memory OLTP in SQL Server 2016
We are happy to announce that SQL Server 2016 removes the size limitation on user data in...
Author: Jos de Bruijn [MSFT] Date: 06/23/2016
IoT Smart Grid code sample
This code sample simulates an IoT Smart Grid scenario where multiple IoT power meters are constantly...
Author: Perry Skountrianos - MSFT Date: 06/15/2016
Announcing availability of SQL Server 2014 Express Docker image
We are excited to announce the public availability of the sql server 2014 express Docker image for...
Author: Perry Skountrianos - MSFT Date: 06/12/2016
IoT code sample - loading messages from Event Hub into Azure SQL Database
Paolo Salvatori created an example that simulates an Internet of Things (IoT) scenario where...
Author: Jovan Popovic (MSFT) Date: 06/10/2016
Appending JSON arrays using JSON_MODIFY function
Sql Server 2016 and Azure Sql Database enables you to easily modify JSON object and arrays....
Author: Jovan Popovic (MSFT) Date: 06/10/2016
Handling inheritance with JSON
JSON in SQL Server 2016 and Azure SQL Database enables you to handle custom fields and...
Author: Jovan Popovic (MSFT) Date: 06/10/2016
Encapsulate JSON parsing with inline table value functions
If you are storing JSON fields in SQL Server 2016 or Azure SQL Database, you would probably need to...
Author: Jovan Popovic (MSFT) Date: 06/10/2016