[ DevCourseWeb ] CloudAcademy - Azure SQL and SQL Server Database Task Automation

[ DevCourseWeb.com ] Azure SQL and SQL Server Database Task Automation

Download More Courses Visit and Support Us -->> https://DevCourseWeb.com



MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English | Duration: 22 Lectures (1h 1m) | Size: 1.72 GB
Description
Whether you’re running SQL Server on-premise, in a VM, on a managed instance, or using Azure SQL, there is maintenance to be performed and other tasks that need to be executed on a regular basis. 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.

Learning Objectives
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

Intended Audience
Data engineers
Database engineers
IT professionals or anyone looking to learn about automating tasks in Azure SQL and SQL server

Use Winrar to Extract. And use a shorter path when extracting, such as C: drive

ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)

Download More Courses Visit and Support Us -->> https://DevCourseWeb.com

Get More Tutorials and Support Us -->> https://AppWikia.com

We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...