Azure SQL Database Managed Instance Archives

The Query Store – SQL Server

23rd July 2019
Arun Sirpal
Blog, Data Management, SQL Server

The Query Store was introduced back in SQL Server 2016 and with the incoming release of SQL Server 2019, it remains a very important feature to know and understand to utilise in performance tuning exercises. Not only is this feature available with on-premises SQL Server but it is a key tool to use when troubleshooting performance issues in Azure SQL Database.

9th November 2018
Arun Sirpal
Azure Development Platform, Blog, SQL Server

The purpose of this article is to discuss what Azure SQL Database Managed Instance is. This will then lay a foundation to explore the capabilities of this deployment model. We will discuss some advantages it can bring to your infrastructure with a cross comparison against on-premises SQL Server. Finally, we look at some important networking configuration that you will need to be aware of when evaluating it.