Creating an Azure SQL Database
Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. It gives a high performance without having to worry about any infrastructure.
Lets create an Azure SQL database using azure portal.
Lets login to your azure account (https://portal.azure.com), In Home page click on Create a resource.
Next, A New page opens, here search for SQL Database in search bar and select SQL Database from auto suggested serach list.
Next, a SQL Database page opens, click on Create button.
After that a Create SQL Database page opens.
Now, select your Azure subscription plan, then choose an existing resource group, or can create a new one.
Next provides details for database :
Specify database name, next choose an existing server name or can create new server referring a post create SQL Database server.
In Compute +Storage, click on configure database .
Once you click on Configure database, a configure page opens.
Here you can choose purchasing model as per your requirement also can find out the cost summary of the selected purchasing model.
There are two types of purchasing model that you can choose for your database.
vCore-based purchasing model
Database transaction unit (DTU)-based Purchasing Model
You can refer microsoft detailed documentation on purchasing model for better ubderstanding and choosing a best one for your requirenment.
Once you select Purchasing model, click on Apply button.
After that click on Review +Create button.
A Create SQL Database page opens, all details of the configured database will be offered to check.
If you find all details fine for you, then click on Create button.
After clicking the Create button, the Azure SQL Database has been starting to deploy and the status of the deployment process will be shown under the Notifications menu, and page screen.
Once the deployment is completed successfully, you will get a Deployment succeeded message on page screen and notifaction menu as well.
Next click on Go to Resource button.
After clicking on Go to resource button, It navigates you SQL Database page. Here you can monitor and manage the database.
To connect with SQL Database, Click on Query editor(preview).
After clicking on Query editor(preview) button, you will see a SQL Server Authentication screen.
Provide login credentails to connect with SQL Database.
In case if you get firwall error, you can fix it by configuring the firewall settings of the serve.
Just click on Set Server firewall link as shown in below screenshot.
After clicking on Set server Firewall link, It navigates you to the Firewall settings page.
Next click on the +Add client IP button, and it automatically finds the public IP and adds a new rule to the list.
After that, click on the Save button to configure this setting.
Now go back to SQL Database Page, and try to login again, and this time you will not get firewall error.
Once you logged in to SQL Database, you can see SQL Query editor, tables, view, and stored procedures.
Now you can perform SQL queries, and tasks.
Create Azure SQL Database Server
Create Azure Data Lake Storage Account
Upload Files to Azure Data Lake Storage
Create an Azure Data Lake Database
Create a Schema and Tables in Azure Data Lake Database
Load Data from Azure Data Lake Storage to Azure Data Lake Database
871 total views, 1 views today