Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
Managing Azure SQL Database with PowerShell
Lab
Intermediate
1 h 40 m
2019-02-15
Lab Overview
In this lab, you will use PowerShell to manage Azure SQL Database. You will create a logical Azure SQL Server via PowerShell. You will then manage the firewall to allow remote connectivity to allow for client access. You will restore a database from an existing BACPAC file. Finally, you will use PowerShell to scale the database performance and pricing tier.
Exercises
In this exercise, you will create a storage account to be used for the remaining exercises in this lab.
In this exercise, you will create a logical SQL Server that you will use to host an Azure SQL Database.
In this exercise, we will restore the AdventureWorksLT database from a BACPAC file.

One of the most powerful features of Azure is its elasticity and the cost efficiencies it provides. The ability to scale an Azure service up during periods of high use and scale down during periods of low use is one of the hallmarks of the Azure cloud architecture.

In this exercise you will scale your Azure SQL Database to a higher service/performance tier using PowerShell and Azure Automation.

Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.