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

Sending emails in Azure SQL Managed Instance

Azure SQL Database Managed Instance enables you to use most of the SQL Server features in fully managed cloud environment. One of the features is database mail system that enables you to send emails directly from Managed Instance. In this post we will see how to setup mail profile and send emails in Managed Instance…. Read more

Create linked server to readable secondary replica in Managed Instance Business Critical service tier

Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud that provides most of the Azure SQL Pass and SQL Server functionalities, such as linked servers and built-in free secondary read-only replicas. In this post you will see how to use linked servers to connect to readable secondary… Read more

Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance

Azure SQL Database Managed Instance is SQL Server implementation on Azure cloud that keeps all database files on Azure storage. In this post you will see how Managed Instance allocates disks in the storage layer and why is this important…. Read more

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