How to create SQL managed instance in azure

How to create SQL managed instance in azure

In this Azure tutorial, we will discuss How to create an Azure SQL database.

How to create SQL managed instance in Azure

Let’s discuss here, how to create a database in Azure SQL-managed instance. Follow the below steps to create the database.

Step-1: Login to the Azure portal (https://portal.azure.com/)

Step 2: Search for the Azure SQL and select the Azure SQL option.

How to create SQL managed instance in azure

Step 3: Click on the + Add button on the Azure SQL window.

Create SQL managed instance in azure

Step-4: On the select SQL deployment option window, click on the Create button from the SQL managed instances section.

How do I create an Azure SQL managed instance

Step-5: Now the Create Azure SQL Database Managed Instance window will open. Fill out the mandatory information required on the Basics tab.

  • Subscription: Choose your correct subscription.
  • Resource group: You can choose your existing resource group or can create a new one by clicking on the Create new link.
  • Managed Instance name: Provide a name for the managed instance.
  • Region: Select the region you belong to.
  • Compute + storage: Select the default one or you can configure a new one by clicking on the Configure Manage Instance link as per your business need.
  • Managed Instance admin login: Provide a username for the login.
  • Password: Provide a password as per the password policy
  • Confirm Password: Confirm the same Password.

Now click on the Next: Networking > button to go to the Networking tab.

Why do I create an Azure SQL managed instance
Key features and benefits of Azure SQL Database managed instance

Step-6: On the Networking tab, Fill in the optional options as per the business need.

  • Virtual network: Select a valid virtual network either or you can  Create a new virtual network or the default one.
  • Connection type: You can choose a proxy(Default) option or a redirect connection type.
  • Public endpoint (data): Select the Enable option here.

Click on the Next: Additional settings > button to navigate to the Additional settings tab.

create an azure sql database managed instance in the azure portal
Azure SQL manage instance shutdown

Step-7: On the Additional Settings tab, Fill in the optional options as per the business need.

  • Collation: Select the collation that you want to use for your managed instance. You can click on the Find a collation to choose a new one or else you can keep the default one as well.
  • Time zone: Select the time zone you belong to.
  • Use as failover secondary: Choose Yes for this option.

Now click on the Next: Tags button to go to the Tags tab.

create SQL managed instance in azure how to create

Step-8: On the tags tab, you can keep the default option as it is. Click on the Next: Review + Create > button.

create SQL managed instance in azure portal

Step-9: Finally, click on the Create button.

How to create SQL managed instance in azure

As you can see now, the deployment has succeeded.

create SQL managed instance in azure

Now to verify if the Azure SQL-managed instance has been created, you can open your resource group

azure sql managed instance limitations

Retrieve connection details to SQL Managed Instance

We can retrieve the Host name and FQDN to connect to the SQL-managed instance

  • From the resource group window, select your managed instance.
Retrieve connection details to SQL Managed Instance
  • From the Overview tab, locate the Host property and copy it you can use it to quickly connect to the Azure SQL-managed instance.
How to retrieve connection details to SQL Managed Instance

FAQs

What is Azure SQL Database managed instance?

Azure SQL Managed Instance is a cloud database service that combines the best features of Azure SQL Database and the SQL Server database engine.

What are Azure SQL-managed instance limitations

There are a few limitations in terms of file size

  • The maximum number of database files per instance is up to 280, unless the instance storage size or Azure Premium limit has been reached in case of general purpose.
  • The maximum number of database files per instance is 32,767 files per database unless the instance storage size limit has been reached in case of business-critical.
  • The maximum data file size is (max 2 TB – 8 TB) in case of general purpose.
  • In the case of business-critical, the maximum data file size is (up to 1 TB – 4 TB).
  • Max log file size is limited to 2 TB in case of general-purpose and business-critical.
  • The maximum number of databases per instance is 100 in both the case of general-purpose and business-critical scenarios.

This is a platform as a service and it is 100% compatible with the latest SQL Server database engine.

This service gives you a way to migrate databases from on-premises environments to the cloud with lower risk. 

This service allows the existing SQL Server customers to migrate their on-premises applications to the cloud with very less application and database changes

What is azure SQL database managed instance

Azure SQL Managed Instance is designed for customers who are looking to migrate a large number of applications from an on-premises to a cloud environment.

What are the Key features and benefits of Azure SQL Database managed instance

  • It is a platform as a service with fully loaded Paas features.
  • Provides an isolated environment with VNET integration, single-tenant service, and high-security features like Private IP address, Azure AD authentication, Single sign-on support, SQL auditing, Advanced threat protection, etc.
  • It is an excellent business model for business users.
  • Provides automated backups, and automatic software patching feature.
  • It provides all the latest database engine features.
  • Provides built-in instance and database monitoring and metrics features.

You may like following Azure tutorials

Conclusion

In this Azure tutorial, We discussed

  • How to create SQL managed instance in Azure
  • what is Azure SQL Database managed instance
  • Key features and benefits of Azure SQL Database managed instance
  • Retrieve connection details to SQL Managed Instance
  • Azure SQL managed instance limitations
  • Azure SQL Managed Instance Monitoring

Hope you have enjoyed this article !!!