Then click the Add private endpoint link under Private EndpointsĬomplete the Create private endpoint flyout as follows: On the Networking screen, for Connectivity method, click the Private endpoint radio button Review settings and then click Next: Networking If you see the option Backup storage redundancy, keep the default value: Geo-redundant backup storage. Note: Make note of this server name, and your login information. On the Configure screen, for Service tier dropdown, select Basic.On the Create SQL Database page, make sure Want to use Elastic Pool is set to NoĬompute + Storage: Click Configure database Password: password: New server sidebar should look similar to the one below. Location: Select the Region nearest to you (same as in Exercise 1) Server name: dp300-lab- (server name must be globally unique) In the New Server sidebar, complete the form as follows: Resource Group: DP-300-Lab02 (the RG created in Exercise 1) Search for “SQL databases” in the search box at the top, then click SQL Databases from the list of optionsĬomplete the Create SQL Database Basics screen with the following inputs and then click Next: Networking In the Edit subnet flyout on the right, expand the Services drop-down, and tick Microsoft.SqlĬlick the Review + Create button, review the settings for the new virtual network, and then click CreateĮxercise 2: Deploy an Azure SQL Database Task 1: Deploy an Azure SQL Databaseįrom the Azure Portal, click on + Create a Resource at the top of the left side navigation bar.(Note that the Subnet address range you see might be different.) On the IP Addresses page, leave the defaults for the IPv4 address space.Ĭlick on the default subnet. Region: Select the same region where the Resource Group was created (the region nearest to your location)Ĭonfigure the virtual network’s IP range for the Azure SQL database endpoint Resource Group: Select the DP-300-Lab02 Resource Group Subscription: Select the lab subscription On the Basics tab, complete the following information: In the left navigation pane, click Virtual NetworksĬlick + Create to open the Create Virtual Network page. Review your existing Resource Groups and then click on the Create button to create a new Resource Group.Ĭomplete the Create a Resource Group wizard with the required information to create the RG.Įnsure Subscription is set to the desired subscriptionĮnter DP-300-Lab02 for the name of the Resource Groupįor the purposes of this lab, select the Region nearest to your physical location Start a browser, and open the Azure Portal at, logging in with the appropriate credentialsįrom the Home screen, click on the Resource Groups button Exercise 1: Configure Basic Resources Task 1: Create a Resource Group Azure Data Studio will be used to evaluate the use of a SQL Notebook for data querying and results retention.įinally, an Azure Database for PostgreSQL will be deployed to support additional data system needs. Lab ObjectivesĬonnect to Azure SQL Database with Azure Data StudioĪs a database administrator for AdventureWorks, you will set up a new SQL Database, including a Virtual Network Endpoint to increase and simplify the security of the deployment. Finally, an Azure Database for PostgreSQL will be created. Connectivity to the SQL Database will be validated using Azure Data Studio from the lab VM. The student will configure basic resources needed to deploy an Azure SQL Database with a Virtual Network Endpoint.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |