Opinions, tips, and news orbiting Microsoft
First published on MSDN on Dec 04, 2018
We are happy to announce General availability of Business Critical tier in Azure SQL Managed Instance – architectural model built for high-performance and IO demanding databases.
Af… Continue reading Azure SQL Managed Instance Business Critical tier is Generally Available
First published on MSDN on Nov 14, 2018
Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reser… Continue reading Modify Azure SQL Database Managed Instance using Azure CLI
First published on MSDN on Nov 14, 2018
Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure resources. In this post your will see how can you create Managed Instance using Azure CLI.
… Continue reading Create Azure SQL Managed Instance using Azure CLI
First published on MSDN on Nov 13, 2018
Consider the following query execution scenario:
You execute a SELECT query that triggers an automatic synchronous statistics update.
The synchronous statistics … Continue reading Diagnostic Data for Synchronous Statistics Update Blocking
First published on MSDN on Nov 12, 2018
Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is placed in your Azure VNet. Users who are creating instances need to have some permissions. In this … Continue reading What Azure permissions are required to create SQL Managed Instance?
First published on MSDN on Nov 07, 2018
SQL Server 2017 and Azure SQL Database introduced
native graph database capabilities
for modeling many-to-many relationships. The first implementation of SQL Graph introduced support f… Continue reading Public preview of derived tables and views on graph tables in MATCH queries
First published on MSDN on Nov 07, 2018
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 … Continue reading Introducing Scalar UDF Inlining
First published on MSDN on Oct 16, 2018
Today we are excited to announce the public preview of Accelerated Database Recovery!
Accelerated Database Recovery (ADR)
is a new SQL Server Engine feature (available in Azure S… Continue reading Announcing Public Preview of Accelerated Database Recovery