Microsoft Azure SQL Database Hands-on
After you have signed in to your account follow the simple steps to create your Azure SQL database.
Step 1: Navigate to Azure Portal.
Step 2: Once, in the Azure Portal click on + ‘Create a resource’ option from the upper left corner and search for Azure SQL.
Step 3: Select create in the resulting Azure SQL page.
Step 4: Review all the Azure SQL options that are available, and then in the SQL databases title, ensure a single database is selected and select create.
Step 5: A created SQL database page will be popped up. Fill in the necessary information as follows:
- Subscription: Select your Azure subscription in which you wish to create the resource.
- Resource group: Choose the resource group where you wish to create the resource or create a new one by clicking on create new option and entering the name of your choice.
- Database name: Enter the name you wish to give to the database.
- Server: Select create new option and create a new server with a unique name in any location. Use SQL authentication and specify your name as the server admin login and a suitably complex password (for security)
- Want to use SQL elastic pool? : Choose whether you wish to use SQL elastic pool or not.
- Compute + Storage: Choose or leave unchanged.
- Backup storage redundancy: Choose locally-redundant backup storage.
Step 6: Next click on ‘Next’: Networking and on the Networking page you can configure the networking settings. For now, in the Network connectivity section select Public endpoint. Then select Yes for both options in the Firewall rules section to allow access to the database server from Azure services and our current client IP address.
Step 7: Next select ‘Next’: Security option to configure the security for the database. For now, set the Enable Microsoft Defender for SQL option to Not now.
Step 8: Next select NextCreate: Additional Settings option to configure some additional settings for the database. For now, set the use existing data option to Sample.
Step 9: Finally, select Review + Create and review the different configurations of the database.
Step 10: If everything is fine select Create to create an Azure SQL database.
Step 11: Wait for deployment to complete and go to the resource that was deployed.
Microsoft Azure SQL Database | Complete Tutorial
Azure SQL Database is a relational database (RDBMS) service provided by Microsoft Azure that is widely used by developers when creating new applications in the cloud. It is managed completely by Microsoft and is a highly scalable platform-as-a-service (PaaS) designed especially for cloud applications. Here, we create a managed database server in the cloud and use the server to deploy our database. The server is a logical construct that acts as the central administration point for pooled databases or multiple logins, auditing rules, threat detection policy, and failover groups.
Table of Content
- Microsoft Azure SQL Database
- What is Microsoft Azure SQL Database?
- Azure SQL vs. SQL Server
- Why Azure SQL Database?
- SQL Azure Architecture
- Azure SQL Database Features
- Azure SQL Database Tiers
- Azure SQL Database Services
- Microsoft Azure SQL Database Hands-on
- Querying using Azure SQL Database
- Pricing Of Azure SQL Database
- Deleting Databases in AzureSQL
- Conclusion
- Azure SQL Database – FAQs
Contact Us