In this Azure tutorial, we will discuss How to create an Azure SQL database.
Table of Contents
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.
Step 3: Click on the + Add button on the Azure SQL window.
Step-4: On the select SQL deployment option window, click on the Create button from the SQL managed instances section.
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.
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.
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.
Step-8: On the tags tab, you can keep the default option as it is. Click on the Next: Review + Create > button.
Step-9: Finally, click on the Create button.
As you can see now, the deployment has succeeded.
Now to verify if the Azure SQL-managed instance has been created, you can open your resource group
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.
- From the Overview tab, locate the Host property and copy it you can use it to quickly connect to the Azure 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
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
- Azure SQL Managed Instance Monitoring
- The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded
- How To Change User ID and Password For Azure SQL Server Database
- Azure SQL Database Vs. SQL Server
- How To Upload SQL Database To Azure
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 !!!