Скачать или смотреть Automating Azure SQL Database maintenance tasks - Sergio Govoni

Azure SQL Database hasn't got a native scheduling service comparable to SQL Agent that is present in the on-premise instances. When database solutions are implemented in Azure SQL, after the design phase of DB schema, possible solutions to perform database maintenance activities like Integrity Check, Index Rebuild etc… have to be studied. On the contrary, Backup activity already has an excellent default configuration given by Microsoft Azure platform. In this session we will learn the necessary activities to undertake in order to perform the maintenance of databases in Azure SQL; moreover, possible solutions will be explained and more convenient services will be described.

Sergio Govoni
Microsoft Data Platform MVP