Azure SQL Database is intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility. Using SQL database in Azure you will get the advantage of built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection. Microsoft performs all the patching and updating of the code base and manages the underlying infrastructure for you, so you can save time and resources. With high SQL Server compatibility, you can also migrate your databases to SQL Database Managed Instance without changing your apps.
In this post, I will share the steps to create an SQL database on Microsoft Azure and test the connectivity.
Create an Azure database and server.
Note:- You need a resource group for creating SQL server. If you don’t have one you can create Resource Group from there by Selecting Create new option. Also if you don’t have a Server, you can choose to create a new form the same window, here we create the server for SQL DB.
If you need a SQL Elastic Pool, Select Yes from Want to use SQL elastic Pool else select No
Elastic Pool
SQL Database Elastic Pool is a shared resource model that enables higher resource utilization efficiency, with all the databases within an elastic pool sharing predefined resources within the same pool. The workload pattern is well defined and is highly cost-effective in multitenant scenarios. An elastic pool is best for new SaaS apps, or for modernizing existing apps to SaaS.
Note:- Your Logged IP will showing there, you if you just click on Add Client IP it will be your IP. If other IPs are required you have to add there with Rule Name start IP and End IP. Azure SQL Database uses firewall rules to allow connections to your servers and databases if you want to use Azure database into the local machine.
Test the Connectivity fo Azure SQL DB from Local Machine
Note:- You can connect the DB using ADO.NET, JDBC, ODBC, PHP
If you enabled firewall configuration and trying form another IP which is not in the firewall allowed list, you may get a window like below to add the accessing IP to the firewall rule. This will come only in case such case where your server name and credentials are matching and you can CLick on Sign In option from there and allow the current IP if it is required.
Note:- Refer Microsoft Website for More detailed information on Pricing and Resource Allocation
Conclusion
In this article, we have shared some the steps of creating an SQL DB on Microsoft Azure and how to connect using SQL Management Studio. There other options to connect the DB on Azure from the client machine, especially ODBC is commonly used for the connection, we will share you another post hot to create an ODBC connection to Microsoft Azure SQL DB.
Nakivo has released its new Backup and Replication solution Nakivo v10.8, which includes support for…
Oracle Cloud VMware Solution (OCVS) provides a customer-managed, native VMware-based cloud environment hosted in Oracle…
Vinchin is a professional provider of data protection solutions for enterprises. It provides a series…
In my previous blog post, I have explained about VMware Cloud Disaster Recovery (VCDR) Onboarding and…
vRealize Network Insight helps you build an optimized, highly available, and secure network infrastructure across…
Can you believe it's here again? SysAdmin Day is back, and with it comes endless gratitude…