PowerShell for SQL Server Administrators

Exercise 2: Configure Database Settings

Exercise 3: Configure SQL Server Settings

Exercise 4: Configure SQL Server Policy-Based Management

After completing this module, students will be able to:

Install SQL Server

Add/Remove components to an existing instance (SSRS, SSIS, SSAS, etc.)

Configure SQL Server and Database Settings

Configure SQL Server Policy-Based Management

This module explains how to perform day-to-day administrative tasks on SQL Server Servers using PowerShell.

Module Objectives

Lesson 1: Managing Users and Roles

Lesson 2: Managing Database Performance

Lesson 3: Managing Database Availability

Lesson 4: Managing SQL Server Features

Review

Exercise 1: Managing Users and Roles

Exercise 2: Managing Database Performance

Exercise 3: Managing Database Availability

Exercise 4: Managing SQL Server Features

After completing this module, students will be able to:

Manage Users and Roles

Manage Database Performance

Manage Database Availability with Clustering & AlwaysOn Availability Groups

Manage Integration Services and Analysis Services

This module explains how to perform maintenance tasks on SQL Servers using PowerShell.

Module Objectives

Managing Backups and Restores

Maintaining Database Integrity and Performance

Monitoring and Auditing

Task Automation

Generating Reports

Review

Exercise 1: Managing Backups and Restores

Exercise 2: Maintaining Database Integrity and Performance

Exercise 3: Monitoring and Auditing

Exercise 4: Task Automation

Exercise 5: Generating Reports

After completing this module, students will be able to:

Manage SQL Server Backups and Restores

Maintain Database Integrity and Performance

Monitor and Audit changes to a SQL Server

Task Automation on SQL Server

Generate SQL Server Reports