Deploy SQL Server in a virtual machine

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
SQL Database
SQL Server

Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options. Investigate options for migrating existing workloads.

Learning objectives

After completing this module, you will be able to:

  • Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
  • Learn the available options for provisioning and deployment
  • Examine methods for migration to Azure SQL Server virtual machine
  • Deploy SQL Server into an Azure Virtual Machine

Prerequisites

  • Familiarity with on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks.
  • Familiarity with network configuration, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies.
  • Ability to create a on-premises SQL Server database, including the configuration of data files and log files.
  • Experience creating and configuring resources using the Azure portal.