SQL Server 2019 introduces several performance optimizations which will improve performance with...

https://docs.microsoft.com/archive/blogs/sqlserverstorageengine/reduced-recompilations-for-workloads-using-temporary-tables-across-multiple-scopes

Checking file performance and comparing performance characteristics between SQL Server database...

https://docs.microsoft.com/archive/blogs/sqlserverstorageengine/measuring-file-io-performance-on-managed-instance-qpi

This blog is in the process of being migrated to one of the new consolidated SQL Server and Azure...

https://docs.microsoft.com/archive/blogs/sqlserverstorageengine/we-are-moving

Reference data is a dataset that is static or slow changing in nature which you can correlate with real-time data streams to augment the data. Azure Stream Analytics leverages versioning of reference data to augment streaming data by the reference data that was valid at the time the event was generated. One of the most... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2019/02/04/azure-stream-analytics-now-supports-azure-sql-database-as-reference-data-input/

Reference data is a dataset that is static or slow changing in nature which you can correlate with...

https://docs.microsoft.com/archive/blogs/sqlserverstorageengine/azure-stream-analytics-now-supports-azure-sql-database-as-reference-data-input

Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and placed in you own VNet with private IP address. In this post, I will shortly explain how to configure and create Managed Instance including network environment, migrate your databases and manage databases after migration. I will explain the following... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2019/01/23/getting-started-with-azure-sql-managed-instance/

Azure SQL Database  Managed Instance is fully-managed PaaS service that provides advanced disaster-recovery capabilities. Even if you accidentally drop the database or someone drops your database as part of security attack, Managed Instance will enable you to easily recover the dropped database. Azure SQL Managed Instance performs automatic backups of you database every 5-10... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2019/01/21/recreate-dropped-database-on-azure-sql-managed-instance/

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. After 5 months of public preview period Azure SQL Managed Instance Business Critical Service tier is generally available. Azure SQL Managed Instance Business Critical tier is built for high performance databases... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/12/04/azure-sql-managed-instance-business-critical-tier-is-generally-available/

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 reserved size of the instance. You can use Azure CLI to easily manage size of the instance and automate this process. The Azure CLI is Microsoft’s... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/14/modify-azure-sql-database-managed-instance-using-azure-cli/

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. The Azure CLI is Microsofts cross-platform command-line experience for managing Azure resources. You can use it in your browser with... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/14/create-azure-sql-managed-instance-using-azure-cli/

Consider the following query execution scenario: You execute a SELECT query that triggers an automatic synchronous statistics update. The synchronous statistics update begins execution and your query waits (is essentially blocked) until the fresh statistics are generated. The query compilation and execution does not resume until the synchronous statistics update operation completes. During this time,... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/13/diagnostic-data-for-synchronous-statistics-update-blocking/

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 post you will see the minimal permissions required to create managed instance. If you are owner of your Azure subscription, you... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/12/what-azure-permissions-are-required-to-create-sql-managed-instance/

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 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 with several new... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/07/public-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries/

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 SQL Server 2019 preview, we are further expanding query processing capabilities... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/07/introducing-scalar-udf-inlining/

Azure SQL Database Engineering team (@azuresqldb) represented by Lindsey Allen,  Joachim Hammer, Ajay Jagannathan, Joe Sack, Borko Novakovic, Mine Tokus, Kevin Farlee, Xiaochen Wu, Alice Kupcik, Jakub Szymaszek, Shreya Verma, Perry Skountrianos, Alain Dormehl, Mirek Sztajno will be in full force speaking at several sessions at the PASS Summit 2018 conference (the Largest Technical Conference... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/05/meet-the-azure-sql-database-team-at-pass-summit-2018/

SQL Server IaaS Extension is installed by default on Azure virtual machines deployed from SQL Server based images on Azure Market Place. SQL Server IaaS extension manages SQL Server configurations on the VM including SQL server connectivity, storage configuration, automated backup, automated security patching and AKV integration. SQL IaaS Extension automates all these administrative tasks... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/25/sql-server-iaas-extension-query-service-for-sql-server-on-azure-vm/

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 SQL, Azure SQL Data Warehouse, and in the upcoming version of SQL Server on-premises) that greatly improves database availability, especially in the presence of long running transactions, by... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/16/accelerated-database-recovery/

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

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/08/september-2018-leaderboard-of-database-systems-contributors-on-msdn/

Sometime you would need to know how many Managed Instance you have created in Azure cloud. Although you can find all information about the Azure SQL Managed Instances in Azure portal or API (ARM, PowerShell, Azure CLI), sometime it is hard to list all instances and search them using some criteria. In this post you... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/01/analysing-inventory-of-managed-instances-using-t-sql/

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

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/09/28/public-preview-of-graph-edge-constraints-on-sql-server-2019/