Managing Azure SQL Database with PowerShell
1 h 40 m
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.

Related Learning Path(s):
Azure SQL Database and SQL DW
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?
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.

Learn More