In this course, we will look at the options available to you in these various environments for automating maintenance and regularly repeated tasks.

SQL Server has a long history of task automation through SQL Server agent, not only will we see how to use it but also how it's been adapted to carry out maintenance tasks, and how similar functionality has made it into Azure services. From mundane single-database scheduled backups through to task and performance automation across multiple servers, this course looks at on-premise and in-cloud options.

Maintain your databases and data through the use of maintenance plans and the SQL Server Maintenance Wizard

Use SQL Agent Jobs to automate maintenance tasks

Automate maintenance across multiple SQL servers

Set up rules to enforce policies

Back up your SQL Server instances using Azure Recovery Services Vault

Learn about the Azure Automation Service and how it can be used

Use Elastic Jobs to schedule tasks within the context of databases

Manage database performance with Automated Tuning

Manage database updates with Automated Patching

Data eeers

Database eeers

IT professionals or anyone looking to learn about automating tasks in Azure SQL and SQL server

To get the most out of this course, you should have experience with SQL Server Management Studio, be familiar with reading and writing SQL, and have an understanding of basic database architecture and administration tasks, like indexes and backups.



DOWNLOAD
uploadgig


rapidgator


nitroflare