Powershell class for SQL Server DBA
Course Contents

Day 1

Powershell Basics

  1. What is Powershell
  2. History and versions of powershell
  3. How Powershell helps SQL Server DBA
  4. Basic Powershell commands

Day 2

Powershell with SQL Server

  1. Mini-shell
  2. SQLPS
  3. SQL Server snap-in

Day 3

Scripting Basics.

Day 4

  1. Output
  2. Email
  3. Current Configuration setting

Day 5

Changing Instance setting

SQL Server Hardening using Powershell

Day 6

Server Inventory

  1. SQL Server Inventory
  2. Service Pack Maintenance
  3. Services and Service Accounts

Day 7

Server Basic Monitoring

  1. CPU/Memory /Network/Disk Space Alerting
  2. Service Monitoring and Alerting
  3. Event viewer & Error Logs

Day 8

Basic SQL Server Administration.

  1. Adding a ndf file
  2. Backup
  3. Restore

Day 9

Querying SQL Server with Powershell

  1. Index Maintenance
  2. Agent Services(failed jobs monitoring)
  3. BCP

Day 10

Event Viewer and Error log

  1. Automation Event Viewer
  2. Errorlog

Day 11

Powershell for Windows Clustering

Clustering log and handling errors

Day 12

Powershell for Cloud.

 

Day 13

Powershell for Mirroring

Powershell for Replication

Day 14

Migration using Powershell

Day 15

SQL Server Health Check using PowerShell

Function and Modules