Public Preview of Graph Edge Constraints on SQL Server 2019

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 nodes to represent entities, edges to represent relationships and a new MATCH predicate to support graph pattern matching and traversal. We will be further expanding the graph database capabilities… Read more

August 2018 Leaderboard of Database Systems contributors on MSDN

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

Storage Configuration Guidelines for SQL Server on Azure VM

SQL Server on Azure Virtual Machines service offers the full control of VM and SQL Server and enables the simplest cloud migration path for SQL Server workloads. SQL IaaS Extension is installed on each SQL VM created through Azure Market Place by default. SQL IaaS Extension offers managed backup, automated security patching, connectivity configuration, AKV… Read more

Introducing Batch Mode on Rowstore

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

The easiest way to create Azure VM that can access your Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure cloud, placed in your private Azure VNet. In order to access your Managed Instance, you need to create VM in your VNet where you will access the instance using SSMS. Azure portal makes this process much easier…. Read more

Persisting job history in Azure SQL Managed Instance

Azure SQL Managed Instance is a fully managed SQL Server hosted in Azure cloud. Although it supports many SQL Server features, there are some constraints compared to SQL Server that you manage. One of the constraint that might be an issue is the fact that SQL Agent keeps a limited history of job executions that… Read more

Meet the Azure SQL Database team at Microsoft Ignite Conference

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen,  Joachim Hammer, Drazen Sumic, Ajay Jagannathan, Kevin Farlee, Xiaochen Wu, Jakub Szymaszek, Mladen Andzic, Srdan Bozovic, Dhruv Malik, Alain Dormehl will be in full force speaking at several sessions at the Microsoft Ignite (#MSIgnite) conference (Microsoft’s ultimate annual technology event). The conference will take place… Read more

What is built-in intelligence in Azure SQL Database?

Azure SQL Database is a fully managed latest stable version of SQL Server Database Engine hosted in Azure cloud that has several built-in features that protect and manage your data. These features may autonomously perform various maintenance tasks instead of you, so we call them built-in intelligence…. Read more

Working with Azure SQL Managed Instance using Azure CLI

Azure Command Line Interface (CLI) is a command line library that enables you to quickly and easily work with your Azure SQL Managed Instances. In this post, you will see some basic CLI commands that can be used with Managed Instance…. Read more