You migrate your on-premises SQL Database to the cloud, taking advantage of the PaaS offering of Azure SQL Database because SQL Managed Instance seems a bit too much for what you require. You heard the promise of spinning up databases on-demand, scaling up resources during high peaks, and scaling down when unused. You also want to ensure you perform integrity checks, index defragmentation, and statistics updates when necessary. But you opted for an offering with no SQL Agent, so how do you automate your jobs?

Do you have time to do this manually each time? No. Different options are available to automate these long-running, manual, error-prone, and frequently repeated tasks to increase efficiency.
In this session, which is full of demos, I will show you six ways to automate these tasks. Some of these solutions use your own infrastructure or Azure services that you can access from the Azure portal experience.
At the end of this session, you will have a good understanding of how to automate Azure SQL Database Maintenance tasks, including replacing SQL Agent functionality with multiple options.

Prerequisites:
Familiarity with Azure SQL Database (PaaS). Understand what SQL Server Agent does for on-premises SQL Servers.

Goals:
1. You will learn six options to automate maintenance tasks against Azure SQL Server (PaaS).
2. Once you familiarize yourself with the different options, you can compare them and decide which suits your environment.