Hands-On Lab: Managing Azure SQL Database with PowerShell

Level 300

Published 2017-02-02

Length 1 hour

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 and setup an Azure Automation job to scale the database up at the beginning of the day and scaled it back down at the end of the day to optimize costs.

Lab Guide

Hands-On Lab: Managing Azure SQL Database with PowerShell