Migrating & Running SQL Server on Azure VMs

There has been a lot of necessity and push from the diverse companies to migrate to Azure.
Besides the usual excitement and promises, people have been discovering that the "Lego Blocks" are not really true in the Cloud and that you can not build exactly the configuration you are hoping for.
Some of the cloud "Building Blocks" limitations might affect you in the way you less expect and you should be aware and plan your actions in advance.

In this full day workshop 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. Securing your backups is not the least of the considerations that a company should be aware of, especially in the public cloud.

In the monitoring part we shall set up basic monitoring with the help of the usual suspects, such as Performance Counters and SQL Statements, and of course the almost inevitable Log Analytics.

We shall also set up Availability Groups and do some basic troubleshooting for common problems there.

In the end we shall look into the migrations paths into the Azure PaaS offerings, such as Azure SQL Database & Azure SQL Managed Instance.

Speakers

Tuesday 29 September 2020