Working with SQL PowerShell

PowerShell 3
  • 11 Videos | 1h 1m 52s
  • Earns a Badge
Likes 14 Likes 14
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

  • Playable
    1. 
    Monitoring Errors from the SQL Server Error Log
    3m 37s
    UP NEXT
  • Playable
    2. 
    Advanced Monitoring Errors from the SQL Error Log
    3m 58s
  • Locked
    3. 
    Obtaining Instance Information on Multiple Instances
    5m 22s
  • Locked
    4. 
    Enabling PS Remoting on SQL Instance
    3m 47s
  • Locked
    5. 
    Error Handling
    5m 39s
  • Locked
    6. 
    Restoring All Databases from Most Recent Backup
    5m 50s
  • Locked
    7. 
    Finding Disk Space for SQL Files
    8m 5s
  • Locked
    8. 
    Displaying Results in Grid View
    6m 19s
  • Locked
    9. 
    sqlps Utility
    5m 58s
  • Locked
    10. 
    Creating SQL Audits
    5m 15s
  • Locked
    11. 
    SQLSERVER Drive and Invoke Sqlcmd cmdlets
    4m 3s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 226 Likes 226  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 10 Likes 10  
Likes 15 Likes 15