1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Azure SQL and SQL Server Database Task Automation

Azure SQL and SQL Server Database Task Automation

Contents

keyboard_tab
Introduction
1
SQL Agent Jobs
Azure Automation Service
Elastic Jobs
18
Automated Tuning
Automated Patching
Summary

The course is part of this learning path

play-arrow
Course Introduction
Overview
DifficultyIntermediate
Duration1h 1m
Students60

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.

If you have any feedback relating to this course, feel free to contact us at support@cloudacademy.com.

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 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.

 

Course Related SQL Scripts

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

Transcript

Hi and welcome to this Azure SQL and SQL server database task automation course. In this course, we will be looking at how to automate various tasks and functions within Azure SQL and SQL server, whether that is running on-premise or on a virtual machine in the cloud. Due to the differences between these two environments and the number of different tasks that can be automated, we have a range of options to choose from.

We will be looking at traditional SQL Server jobs and maintenance plans through to Azure automated services and elastic jobs. I would describe this as an intermediate level course suited to those who have had experience with SQL Server Management Studio, are comfortable with reading and writing SQL, and have an understanding of basic database architecture and administration tasks, like indexes and backups.

My name is Hallam Webber and I will be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out to us at support@cloudacademy.com with any questions or comments.

Let's get started.

So why automate? While Azure SQL and the cloud environment, in general, take care of most of the tedious and repetitive tasks, if you have had any experience with managing on-premise SQL Server you will realize there are a lot of tasks that need to be performed regularly that aren't necessarily automated out-of-the-box. I see these tasks as falling into three broad categories.

Firstly, maintenance which encompasses regular database administration tasks that involve the well-being of the server and databases irrespective of the data contained within them. Secondly, performing regular data maintenance, and finally, recurring non-administrative tasks related to the contained data.

About the Author
Students8529
Courses13
Learning paths1

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.