Migrating & Running SQL Server on Azure VMs
DBA, Architect, Consultant
In this session we shall review the practical considerations and possible paths to migrate, run, optimize and monitor your database workloads in Azure Virtual Machines.
You shall learn how to create infrastructure in a basic as well as in the efficient (aka repeatable & reconfigurable) way for your SQL Server in Azure VMs.
In the migration part we shall consider from the formal offline paths of Backup and Restore and explore the available online paths such as Log Shipping and Transactional Replication and even expanding the AG Cluster to add a replica.
In the running part we shall consider common procedures, such as Azure Infrastructure optimisations (including disk caching), backups to Azure Blob Storage for SQL 2014 & SQL 2016+, Resource Governance, etc.
In the securing part the typical network infrastructure considerations shall be brought on the table, such as Firewall & NSGs configurations.
Basic knowledge of the Azure Data Platform