July 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our July 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

Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss is a Korea based game development studio established in 2009.  Black Desert Online, a PC-massively multiplayer online role-playing game (MMORPG), is their main title in production published across the globe. On February 28, 2018, Pearl Abyss launched Black Desert Mobile on Microsoft Azure virtual machines utilizing 7,500 cores and 46 instances of Azure… Read more

Azure SQL Database team at Data Platform Summit 2018

Azure SQL Database Engineering Team (@azuresqldb) represented by (Ajay Jagannathan, and Sunil Agarwal) will be speaking at Data Platform Summit 2018 (#DPS10), Asia’s Premier Data & Analytics Conference taking place on August 9-11 in Bangalore, India. Data Platform Summit 2018 is a full 3-day conference with more than 100 breakout sessions, open talks, chalk talks… Read more

Approximate Count Distinct enters Public Preview in Azure SQL Database

Kevin Farlee Principal Program Manager, SQL Database We are pleased to announce the public preview of Approximate Count Distinct, the first of the Approximate Query Processing features.  Approximate Query Processing is a new family of features which are designed to provide aggregations across very large data sets where responsiveness is more critical than absolute precision. … Read more

Public Preview of MATCH support in MERGE DML for Graph tables in Azure SQL Database

SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model many-to-many relationships. The first implementation of SQL Graph introduced support for edges to represent relationships, nodes to represent entities and a new MATCH predicate to support graph pattern matching and traversal. We will be further expanding the graph database capabilities… Read more

Public Preview of Row Mode Memory Grant Feedback in Azure SQL Database

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. In Azure SQL Database, we are further expanding query processing capabilities with… Read more

Public Preview of Table Variable Deferred Compilation in Azure SQL Database

Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. In Azure SQL Database, we will be further expanding query processing capabilities with… Read more

Validate your Azure network environment for SQL Managed Instance

Azure SQL Managed Instance is a fully managed PaaS SQL Server Database Engine hosted in Azure cloud that is placed in Azure Virtual network, and you need to ensure that your network is properly configured. In this post your will see a PowerShell script that can validate the Azure network that you prepared for the… Read more