Azure SQL and SQL Server Database Task Automation

Focused View

Hallam Webber

1:01:03

11 View

1. Course Introduction.mp4

02:07

2. Database Maintenance.mp4

01:13

3. Data Maintenance and Recurring Data.mp4

01:07

4. Maintenance Plans.mp4

01:31

5. DEMO- Maintenance Wizard.mp4

03:39

6. New Maintenance Plan.mp4

03:51

7. SQL Agent Jobs.mp4

01:56

8. DEMO- Importing Data.mp4

03:03

9. Automation Across Servers.mp4

01:37

10. DEMO- SQL Multi-Server Administration.mp4

04:21

11. SQL Server Policy Management.mp4

01:32

12. DEMO- Policy Management.mp4

04:02

13. Recovery Services Vault.mp4

01:03

14. DEMO- Recovery Services Vault.mp4

04:54

15. Microsoft Azure Backup Service.mp4

00:58

16. Azure Automation Service.mp4

01:08

17. DEMO- Azure Automation Service.mp4

04:34

18. Elastic Jobs.mp4

02:16

19. DEMO- Elastic Jobs.mp4

05:50

20. Automated Tuning.mp4

03:59

21. Automated Patching.mp4

01:21

22. Course Summary.mp4

05:01

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 lesson, 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 lesson looks at on-premise and in-cloud options.

If you have any feedback relating to this lesson, feel free to contact us at [email protected].

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

Prerequisites

To get the most out of this lesson, 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.

Lesson Related SQL Scripts

https://github.com/cloudacademy/azure-sql-task-automation-dp-300

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft Azure

Hallam Webber

Instructor's Courses

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.