This lab walks we will walk through the steps to deploy SQL server and create SQL database containing sample data.
Duration: 60 minutes
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability.
PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure.
SQL Database can be the right choice for a variety of modern cloud applications because it enables you to process both relational data and non-relational structures, such as graphs, JSON, spatial, and XML.
Launching Lab Environment
Create a Azure SQL Database
Create a server-level IP firewall rule
Connect to the database
Create tables in the database