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
Query JSON data
New JSON support in SQL server enables you to create SQL queries that use both relational and...
Author: Jovan Popovic (MSFT) Date: 11/28/2015
Log analysis with SQL Server
Logging In any application you will need to have some kind of logs where you write events, errors,...
Author: Jovan Popovic (MSFT) Date: 11/27/2015
Storing JSON in SQL Server
SQL Server offers built-in functions for processing JSON text data. In this post, we will see how...
Author: Jovan Popovic (MSFT) Date: 11/23/2015
In-Memory OLTP - what's new in SQL2016 CTP3
We have been hard at work to add features to In-Memory OLTP to make it easier to build apps and to...
Author: Jos de Bruijn [MSFT] Date: 11/12/2015
FOR JSON performance - simple experiment
How fast is FOR JSON compared to generating JSON in application layer? In SQL Server 2016 CTP2 is...
Author: Jovan Popovic (MSFT) Date: 11/10/2015
Generate serie of numbers in SQL Server 2016 using OPENJSON
How can we use OPENJSON to generate series of numbers? In this post I will talk about one unusual...
Author: Jovan Popovic (MSFT) Date: 11/03/2015
DROP IF EXISTS - new thing in SQL Server 2016
In SQL Server 2016 CTP3 objects can DIE (DROP IF EXISTS) Do you like to write following conditional...
Author: Jovan Popovic (MSFT) Date: 11/03/2015
OPENJSON - one of best ways to select rows by list of ids
Selecting table rows by id in SQL Server In this post I will talk about different way to select rows...
Author: Jovan Popovic (MSFT) Date: 11/03/2015
Samples for SQL Server 2016 CTP3
Update: New sample database for SQL Server 2016: Wide World Importers CTP3 of SQL Server 2016 was...
Author: Jos de Bruijn [MSFT] Date: 10/29/2015
Returning child rows formatted as JSON in SQL Server queries
In this post I will talk about one annoying thing – how to return a result set containing one...
Author: Jovan Popovic (MSFT) Date: 10/09/2015
Importing JSON files into SQL Server using OPENROWSET (BULK)
Importing JSON files in SQL Server Currently you can find many JSON documents stored in files....
Author: Jovan Popovic (MSFT) Date: 10/07/2015
Querying JSON documents in Sql Server 2016 and DocumentDB
SQL Server JSON query syntax compared to DocumentDB In this article I will show you similarities and...
Author: Jovan Popovic (MSFT) Date: 10/06/2015
Parsing GeoJSON format in Sql Server 2016
Parsing GeoJSON format in Sql Server 2016 GeoJSON is commonly used format for representing various...
Author: Jovan Popovic (MSFT) Date: 10/02/2015
Indexing JSON documents in Sql Server 2016
JSON indexes in SQL Server One important thing in every database is indexing. Indexes can speed-up...
Author: Jovan Popovic (MSFT) Date: 09/30/2015
OPENJSON - The easiest way to import JSON text into table
Introduction In SQL Server 2016 will be added a new table value function that can transform JSON...
Author: Jovan Popovic (MSFT) Date: 09/22/2015
Loading non-relational data formatted as JSON text
Introduction Data load is one of the most important processes in databases. However, relational...
Author: Jovan Popovic (MSFT) Date: 09/16/2015
Clustered Columnstore Index: Enforcing uniqueness constraint in table
SQL Server introduced ‘updateable’ clustered columnstore index (CCI) starting with SQL Server 2014...
Author: Sunil Agarwal Date: 09/14/2015
Passing arrays to T-SQL procedures as JSON
Introduction SQL Server do not supports complex types such as arrays or lists. If you need to send...
Author: Jovan Popovic (MSFT) Date: 09/08/2015
Combining relational and NoSQL concepts in SQL Server
Intro In this article we will see how you can combine NoSQL and relational concepts in SQL Server...
Author: Jovan Popovic (MSFT) Date: 09/01/2015
FOR JSON clause in SQL Server 2016 CTP2
One of the features that are coming in SQL Server 2016 CTP2 is JSON support. In this post I will...
Author: Jovan Popovic (MSFT) Date: 06/08/2015
Clustered Column Store Index: Bulk Loading the Data
Clustered Column Store: Bulk Load As described in the blog...
Author: Sunil Agarwal Date: 07/27/2014
Clustered Column Store Index: Concurrency with INSERT Operations
Clustered Column Store: Insert Operations As described in the blog...
Author: Sunil Agarwal Date: 07/27/2014
Clustered Column Store Index: Concurrency and Isolation Levels
Clustered Column Store and Concurrency The clustered column store index (CCI) has been designed for...
Author: Sunil Agarwal Date: 07/26/2014
Clustered Column Store: Factors that impact size of a RowGroup
Clustered Column Store: Factors that impact size of a RowGroup: A clustered column store index...
Author: Anonymous Date: 05/03/2014
AlwaysOn: Comparing Readable Secondary with the similar functionality available in DB2
In my previous blogs, I had described how Readable Secondary functionality works SQL Server 2012. As...
Author: Sunil Agarwal Date: 01/21/2012
AlwaysOn: I just enabled Readable Secondary but my query is blocked?
When you connect to Secondary Replica, but it has not been enabled for read workload, you will get...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Making latest statistics available on Readable Secondary, Read-Only database and Database Snapshot
In the previous blog...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Challenges with statistics on ReadOnly database, Database Snapshot and Secondary Replica
I am sure you all have dealt with situations when the statistics on one or more columns is either...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Impact of mapping reporting workload on Readable Secondary to Snapshot Isolation
In my previous blog...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Minimizing blocking of REDO thread when running reporting workload on Secondary Replica
In earlier blog...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Impact on the primary workload when you run reporting workload on the secondary replica
The primary goal of AlwaysOn technology is to provide High Availability for Tier-1 workloads. The...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Readable Secondary and data latency
One question that I often get asked is if there will any data latency if you are using 'Sync'...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Why there are two options to enable a secondary replica for read workload?
In the previous blog...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Setting up Readable Seconary Replica
The easiest way to create an availability group and adding replicas is to use the availability group...
Author: Sunil Agarwal Date: 12/22/2011
AlwaysOn: Value Proposition of Readable Secondary
This series of blogs is targeting AlwaysON Readable Secondary. Please refer to...
Author: Sunil Agarwal Date: 12/22/2011
SQL Server Team is hiring
Hello to you all,The SQL Server team is hiring arcoss all test, dev and PM discipline. If you or...
Author: Sunil Agarwal Date: 05/17/2011
Data Compression and Fill Factor
Recently, I was asked this question "If I have a compressed index and I rebuild it with fill factor...
Author: Sunil Agarwal Date: 05/12/2011
Concurrency Series: My application was running fine yesterday but why is it blocking today?
Please refer to...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Minimizing blocking between updaters
Please refer to...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?
Please refer to...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
I posted this in SQLCAT blog site. This post provides reference to...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Basics of Transaction Isolation Levels
Please refer to the blog...
Author: Sunil Agarwal Date: 02/20/2011
Concurrency Series: Common Concurrency Issues with Applications
As part of my role as a program manager in SQL Server Engine, one of the areas I am reponsible for...
Author: Sunil Agarwal Date: 06/04/2010
Minimal logging and MERGE statement
In my earlier blog...
Author: Sunil Agarwal Date: 06/03/2010
Backup compression and Virtual Device Interface (VDI)
People often ask if they can get native SQL Server backup compression using VDI interface. The...
Author: Sunil Agarwal Date: 02/21/2010
Performance improvement by orders of magnitude when merging partitions in SQL Server 2008R2
I am publishing this Blog on behalf of Hermann Daeubler, our SAP expert Scenario: Let’s assume we...
Author: Sunil Agarwal Date: 02/03/2010
Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency
Another improved functionality in SQL Server 2008 R2I am posting this on behalf of Juergen Thomas...
Author: Sunil Agarwal Date: 01/18/2010
Changes to sp_estimate_data_compression_savings stored procedure in SQL2008R2
When you compress an object (index or table or partition), there are two components of space savings...
Author: Sunil Agarwal Date: 09/16/2009