Azure Managed Instance

Azure Managed Instance as per my understanding is a new essence of Azure SQL database. It is more compatible to On-Premise SQL Server than Azure SQL database. It provides network isolation addressing some common security concerns with Azure SQL database. Managed Instance allows minimal database and application changes while moving from On-Premise to Azure. It provides automatic patching, backups, high availability same as PaaS offerings.

I have started testing the managed Instance and will list down the capabilities below as I go,

1) My first Azure Managed instance.
2) Connecting to Azure Managed instance from a virtual machine.
3) Checking SQL Server errorlog in Azure managed Instance. 
4) Trace Flags enabled in Azure Managed Instance
5) Is Trace Flag 1117 enabled in Azure Managed Instance?
6) Physical_database_name column in sys.databases
7) Restore a database backup to an Azure Managed Instance

Limitations

1) Getdate() function
2) Sp_configure on Managed instance

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Advertisements

2 thoughts on “Azure Managed Instance

  1. Pingback: My first Azure Managed instance | JBs Wiki
  2. Pingback: Connecting to Azure Managed instance from a virtual machine | JBs Wiki

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s