Working with SQL PowerShell

PowerShell 3    |    Beginner
  • 11 videos | 57m 52s
  • Earns a Badge
Rating 4.1 of 20 users Rating 4.1 of 20 users (20)
The PowerShell environment can help you in the management of SQL Server. Learn how to use SQL PowerShell to monitor and handle errors, restore databases from backups, and create SQL audits.

WHAT YOU WILL LEARN

  • Pipe sql server error log messages through powershell
    Use advanced cmdlets to work with and read the error log in powershell
    Obtain information on multiple instances of a server using cmdlets in powershell
    Enable powershell remoting
    Handle errors using microsoft powershell
    Restore all databases in an instance of sql using microsoft powershell
  • Analyze disk space in a disk or file group using powershell
    Display results in grid view in powershell
    Recognize the differences in inputting assemblies in windows powershell and sql powershell
    Create sql audits using powershell
    Configure the options of the invoke sqlcmd cmdlet in powershell

IN THIS COURSE

  • 3m 37s
    Learn how to pipe SQL Server Error Log messages through PowerShell. FREE ACCESS
  • 3m 58s
    In this video, find out how to use advanced cmdlets to work with and read the error log in PowerShell. FREE ACCESS
  • Locked
    3.  Obtaining Instance Information on Multiple Instances
    5m 22s
    In this video, you will learn how to obtain information on multiple instances of a server using PowerShell cmdlets. FREE ACCESS
  • Locked
    4.  Enabling PS Remoting on SQL Instance
    3m 47s
    In this video, you will enable PowerShell remoting. FREE ACCESS
  • Locked
    5.  Error Handling
    5m 39s
    In this video, you will learn how to handle errors using Microsoft PowerShell. FREE ACCESS
  • Locked
    6.  Restoring All Databases from Most Recent Backup
    5m 50s
    In this video, learn how to restore all databases in an instance of SQL using Microsoft PowerShell. FREE ACCESS
  • Locked
    7.  Finding Disk Space for SQL Files
    8m 5s
    In this video, you will learn how to analyze disk space in a disk or file group using PowerShell. FREE ACCESS
  • Locked
    8.  Displaying Results in Grid View
    6m 19s
    During this video, you will learn how to display results in a grid view in PowerShell. FREE ACCESS
  • Locked
    9.  sqlps Utility
    5m 58s
    Upon completion of this video, you will be able to recognize the differences in inputting assemblies in Windows PowerShell and SQL PowerShell. FREE ACCESS
  • Locked
    10.  Creating SQL Audits
    5m 15s
    During this video, you will learn how to create SQL audits using PowerShell. FREE ACCESS
  • Locked
    11.  SQLSERVER Drive and Invoke Sqlcmd cmdlets
    4m 3s
    In this video, learn how to configure the options of the Invoke-Sqlcmd cmdlet in PowerShell. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey Working with Microsoft Azure SQL
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Audiobook Practical Automation with PowerShell

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SSIS Package Execution & Script Tasks
Rating 4.7 of 14 users Rating 4.7 of 14 users (14)
Course AWS Certified Solutions Architect Associate Bootcamp: Session 3 Replay
Rating 4.5 of 39 users Rating 4.5 of 39 users (39)
Course Syntax, Help, & Conditionals
Rating 4.5 of 778 users Rating 4.5 of 778 users (778)