![adventureworks database download 2012 log file adventureworks database download 2012 log file](https://blog.sqlauthority.com/i/b/samples2008/samples200823.gif)
ADVENTUREWORKS DATABASE DOWNLOAD 2012 LOG FILE FREE
Image: Free SQL Server License: SQL 2019 Developer on Windows Server 2019 - Gen1 On the Create a virtual machine blade, enter the following information:Īvailability Options: No infrastructure redundancy required Select the option labeled Free SQL Server License: SQL 2019 Developer on Windows Server 2019. On the Select SQL deployment option blade, open the drop-down box under SQL virtual machines. On the Azure SQL blade, select the Create button. Task 2: Provision a SQL Server on an Azure Virtual Machine Select the search result for Azure SQL that appears in the results under Services. Locate the search bar at the top of the page. Once the review completes, select the Create button. Select the nearest Azure region to your location. On the Resource groups blade, select the Create button.Įnsure you have selected the appropriate subscription for the lab. The Resource groups blade will list all Azure resource groups within your selected subscriptions. Select Resource groups in the left navigation. The All resources page will list all Azure resources within your selected subscriptions. Launch the left navigation pane by clicking the horizontal lines next to Microsoft Azure in the top left of the portal. Review your Subscription name, subscription ID, and your role. On the Subscriptions blade, you will have one or more subscriptions. In the Azure Portal, type subscription in the search bar at the top of the screen. The main tasks for this exercise are as follows:Įxplore the Azure Portal and locate important functionality.Ĭreate a SQL Server on an Azure Virtual Machine using the Azure Portal.įrom the lab virtual machine, if you are not already in the portal, start a browser session and navigate to. Exercise 1: Provision a SQL Server on an Azure Virtual Machine You need to set up the Virtual Machine, restore the database, and query it to ensure it is available. The proof of concept will use SQL Server on an Azure Virtual Machine and a backup of the AdventureWorksDW database. You need to create a test environment for use in a proof of concept. You are a database administrator for AdventureWorks. Use SQL Server Management Studio to restore a database They should then be able to connect to the virtual machine and use SQL Server Management Studio to restore a database.
![adventureworks database download 2012 log file adventureworks database download 2012 log file](https://i.ytimg.com/vi/Z79S2AGinkU/maxresdefault.jpg)
The student will be able to interact with the Azure portal to create a SQL Server Virtual Machine. Then they will connect to the virtual machine through Remote Desktop Protocol and restore a database using SQL Server Management Studio. Students will explore the Azure Portal and use it to create an Azure VM with SQL Server 2019 installed. Lab 1 - Using the Azure Portal and SQL Server Management Studio