SQL Server Administration & Maintenance

SQT06 Fast Focus: 5 DBA Tasks for Azure SQL - What's Different from On-Prem

11/16/2021

2:00pm - 2:20pm

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 5 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:

  • How to deploy an Azure SQL database
  • How backups & restores are different in Azure
  • How Automatic Updates are different in Azure