March 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our March top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):… Read more

Demo – Azure SQL Database Managed Instance in action

Azure SQL Database Managed Instance is new data service in Azure cloud that exposes fully-managed SQL Server Instance that is hosted in Azure cloud and placed in customer VNET. Here you can see some of the key new features that are available in Managed Instance…. Read more

February 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our February top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the points hierarchy (in decreasing order of points):  … Read more

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 database as self-contained service. Databases can be grouped together to simplify management options or share the resources. There are different options that can be used to bound databases in the groups, which will be explained in this post…. Read more

JSON data in clustered column store indexes

Clustered column store indexes (CCI) in SQL Server vNext and Azure SQL Database support LOB types like NVARCHAR(MAX), which allows you to store string with any size, including JSON documents with any size. With CCI you can get 3x compression and query speedup compared to regular tables without any application or query rewrites. In this… Read more

Query Optimizer Additions in SQL Server 2016

In SQL Server 2016 we have introduced a number of new Query Optimizer improvements. This article summarizes some them and explains you can leverage the benefits of the new enhancements. Expect deep dive follow up articles for some of the enhancements. Here is the short list: Compatibility Level Guarantees Query Optimizer Improvements under Trace Flag… Read more

Increased nonclustered index key size with SQL Server 2016

SQL Server 2016 and Azure SQL Database have increased the maximum size for index keys with nonclustered indexes. The new maximum key size for nonclustered indexes is 1700 bytes. The maximum key size for clustered indexes remains 900 bytes. Consider, for example, the following script which creates a table with a 1700 byte variable-length character column,… Read more

JSON is available in Azure SQL Database

JSON functionalities that are added in SQL Server 2016 are also available in Azure SQL Database see Public preview: JSON in Azure SQL Database. All functionalities that you can use in SQL Server 2016 RC (i.e. FOR JSON, OPENJSON, built-in functions) are also available in Azure SQL Database, including JSON_MODIFY function that is added in RC… Read more

A Technical Case Study: High Speed IoT Data Ingestion Using In-Memory OLTP in Azure

In this post we look at a customer case study of an Internet of Things (IoT) scenario, where large amount of device data is ingested into an Azure SQL Database. Because the data lives in a SQL database, it can be conveniently accessed and analyzed through SQL queries. In-Memory OLTP was used to achieve significant… Read more