Select Page
QS_SSMS_Reports_m.jpg.png

Using Query Store with least privileges instead of db_owner to archive Separation of Duties

When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning. The Query Store is a component that can be activated per database and ... continue reading
Screenshot of the Windows Admin Center - Azure Hybrid Center

Run Windows Server and SQL Server workloads seamlessly across your hybrid environments

In recent weeks, we’ve been talking about the many reasons why Windows Server and SQL Server customers choose Azure. Security is a major concern when moving to the cloud, and Azure gives you the tools and resources you need to ... continue reading
Azure Cloud Shell Tips for SysAdmins: Part II - Using the Cloud Shell tools to Migrate

Azure Cloud Shell Tips for SysAdmins: Part II – Using the Cloud Shell tools to Migrate

As an Azure Advocate, one of the things I spend my time doing is learning the easiest ways for beginners to use Microsoft Azure. Today I want to share with you a few ways to utilize some tools that are ... continue reading

Persisting SQL Agent job history in Managed Instance

First published on MSDN on Sep 20, 2018 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 ... continue reading
FourCores on MSDN.png

Check out what’s new in June 2019 version of Azure SQL Database managed instance

In June 2019 Azure SQL Database offered a major refreshed release of Azure SQL Database managed instance (SQL MI), adding a rich set of innovations, complementing the Generally Available version of this product. These enhancements result in SQL MI becoming ... continue reading
Azure SQL Managed Instance Business Critical tier is Generally Available

Azure SQL Managed Instance Business Critical tier is Generally Available

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. After 5 months of public preview ... continue reading

Modify Azure SQL Database Managed Instance using Azure CLI

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 reserved size of ... continue reading

Analysing inventory of Managed Instances using T-SQL

First published on MSDN on Oct 01, 2018 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 ... continue reading
The easiest way to create Azure VM that can access your Azure SQL Managed Instance

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

First published on MSDN on Sep 21, 2018 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 ... continue reading

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

First published on MSDN on Aug 20, 2018 Azure SQL Database Managed Instance General Purpose (GP) is SQL Server implementation on Azure cloud that keeps all database files on Azure storage. In this post you will learn how Managed Instance ... continue reading