Overview

Introduction

The Write automation scripts module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Write Automation Script to Perform Database Backup
  2. Write Automation Script to Shrink Database
  3. Write Automation Script to Remedy Index Fragmentation
  4. Write Automation Script to Check Disk Space
  5. Write Script to Automate Execution of SSIS Package

Exercise 1- Write Automation Script to Perform Database Backup

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Write automation script to perform database backup at regular interval

Exercise 2 – Write Automation Script to Shrink Database

In this exercise, you will write script to automate the task of shrinking the AdventureWorksDW2012 database at a regular interval using SQL Server Agent Service.

Exercise 3 – Write Automation Script to Remedy Index Fragmentation

In this exercise, you will write script to automate the task of reorganizing indexes on the AdventureWorksDW2012 database at a regular interval using SQL Server Agent Service.

Exercise 4 – Write Automation Script to Check Disk Space

In this exercise, you will write script to automate the task of cleaning disk space at a regular interval using SQL Server Agent Service.

Exercise 5 – Write Script to Automate Execution of SSIS Package

In this exercise, you will write script to automate the task of execution of an SSIS package using SQL Server Agent Service.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.