SQL Server Administration & Maintenance

SQW05 10 DBA Tasks for Azure SQL: What's Different from On-Prem

11/17/2021

2:00pm - 3:15pm

Level: Introductory to Intermediate

Rie Merritt

Sr. Program Manager, Data Engineering, MVP Lead & Data Community Support

Microsoft

One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you're familiar with are all there. So much is the same but some of the tasks that DBAs do are different. In this session, we'll learn the differences in Azure SQL Managed Instances and Azure SQL Databases and we'll cover ten or more of the most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs.

You will learn:

  • Identify different Azure SQL Offerings
  • Get familiar with Azure Portal
  • Common tasks that are different (backups, restores, job scheduling, maintenance, etc.)