In this lab we will practice In this lab we will practice Deploying Azure SQL Database

}}

You have two option to complete this lab

1. Use your own azure subscription, you can sign up for trial here

2. Use Microsoft Learn sandbox. Check more details here

Login to Microsoft Account Signup if you did not have Microsoft Account.

Click here to activate SandBox

Sign into you Microsoft Account

}} It might ask you to verify you are not a robot but solving a puzzle.

}} Click on review permissions

}} Read permissions and click Accept

}} If you already did signin into you Microsoft Account you will get below message.

Click on activate sanbox.

}} After processing it will show below message.

}} You are all set go to next step.

Open a new tab in browser and open https://portal.azure.com

Sign in with Microsoft account you used in previous step.

If you get below message click on X to close it

Else go to next step

}}

In the top search bar, enter Azure SQL and wait for results so you can review what appears.

There are a lot of items and categories here, but basically this menu gives you filters for what you can search on. Let's break them down:

• Services: If you select this, you can see your existing resources (that is, already deployed) all together. For example, if you selected Azure SQL, you would see all of your SQL virtual machines, databases, logical servers, managed instances, and pools.
• Resources: This searches based on existing resource names. For example, if you searched for "adventureworks," any resources with "adventureworks" in the name would be returned here.
• Marketplace: This allows you to deploy new resources from Azure Marketplace.
• Documentation: This searches docs.microsoft.com for relevant documentation.
• Resource groups: This allows you to search based on resource group name.

Select Azure SQL under Marketplace. This step will bring you to the Azure SQL create experience.

In SQL databases, select Single database > Create.

On the Basics tab, enter the following information:

Select Next: Networking.

For Connectivity method, select Public endpoint. Select Yes for both Allow Azure services and resources to access this server and Add current client IP address.

For Connection policy, select Default.

Select Next: Security.

When you deploy Azure SQL Database in the portal, you're prompted about whether you want to Enable Microsoft Defender for SQL in a free trial. Select Start free trial.

After the free trial, it's billed according to the Microsoft Defender for Cloud Standard Tier pricing. After you enable it, you get functionality related to identifying/mitigating potential database vulnerabilities and threat detection.

Leave remaining defaults and select Next: Additional settings.

On the Additional settings tab, for Azure SQL Database you have the option to select the AdventureWorksLT database as the sample in the Azure portal. For this exercise, for Use existing data, select Sample.

Select Review + create. Here, you can review your deployment selections and the Azure Marketplace terms. Review all the options to ensure that all of your selections match the exercise instructions, and then select Create to deploy the service.

You're redirected to a pane where you can monitor the status of your deployment. You can also go to your resource group and select Deployments to open this same pane. It gives you the various deployments, their status, and more information. This deployment typically takes less than five minutes to deploy.

When your deployment is complete, select Go to resource.

Review the Overview pane for the SQL database in the Azure portal and confirm that the status is Online.

Check instructions to download and install SQL Server Management Studio (SSMS) here

First, we need the logical server name. On the Overview pane for your database, locate the Server name information. This will be the fully qualified domain name (FQDN) of your logical server, for example, aw-server0406.database.windows.net. Hover your mouse at the end of the name and select Copy to clipboard.

Let's connect to your Azure SQL Database logical server. On your local device, open SSMS if it's not open already, and create a new connection. Select Connect > Database Engine.

For Server name, paste the name of your Azure SQL Database logical server.

Change the authentication to SQL Server Authentication. Then enter the corresponding server admin login and password (the one you provided during deployment in the previous exercise).

Select Remember password, and then select Connect.

Expanding the databases and system databases should result in a view similar to the following.

Spend a few minutes exploring the differences, at first glance, between the Azure SQL Database logical server and SQL Server. You won't deploy a managed instance as part of this exercise, but the following image shows how a managed instance would appear in SSMS.

Summary

In this exercise, you saw how to deploy and connect to Azure SQL Database.

Clean up

The sandbox automatically cleans up your resources when you’re finished with this module.

When you’re working in your own subscription, it’s a good idea at the end of a project to identify whether you still need the resources you created. Resources left running can cost you money.

You can delete resources individually or delete the resource group to delete the entire set of resources.

Summary

In this exercise, you saw how to deploy and connect to Azure SQL Database.

Clean up

The sandbox automatically cleans up your resources when you’re finished with this module.

When you’re working in your own subscription, it’s a good idea at the end of a project to identify whether you still need the resources you created. Resources left running can cost you money.

You can delete resources individually or delete the resource group to delete the entire set of resources.