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

June 2018 Leaderboard of Database Systems contributors on MSDN

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

Deploy Azure SQL Managed Instance network environment using ARM

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. You would need to prepare Azure environment where SQL Managed Instance will be hosted before you create your Managed Instances. In this post you will see how to deploy configured Azure environment using ARM template…. Read more

Point-in-time restore of a database on Azure SQL Managed Instance using AzureRm.Sql PowerShell library

Azure SQL Database Managed Instance is PaaS version of SQL Server hosted in Azure cloud. Managed Instance enables you to create a database as a copy of the existing database at some point in time using PowerShell. In this post you will see sample script that performs point in time restore of database…. Read more

Quick-start script: Create Azure SQL Managed Instance using Azure.Rm PowerShell library

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud. In this post you can find a simple PowerShell script that you can use to quickly create a new Managed Instance…. Read more