Working with SQL PowerShell
PowerShell 3
| Beginner
- 11 Videos | 57m 52s
- Earns a Badge
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 PowerShelluse advanced cmdlets to work with and read the error log in PowerShellobtain information on multiple instances of a server using cmdlets in PowerShellenable PowerShell remotinghandle errors using Microsoft PowerShellrestore all databases in an instance of SQL using Microsoft PowerShell
-
analyze disk space in a disk or file group using PowerShelldisplay results in grid view in PowerShellrecognize the differences in inputting assemblies in Windows PowerShell and SQL PowerShellcreate SQL audits using PowerShellconfigure the options of the Invoke Sqlcmd cmdlet in PowerShell
IN THIS COURSE
-
1.Monitoring Errors from the SQL Server Error Log3m 37sUP NEXT
-
2.Advanced Monitoring Errors from the SQL Error Log3m 58s
-
3.Obtaining Instance Information on Multiple Instances5m 22s
-
4.Enabling PS Remoting on SQL Instance3m 47s
-
5.Error Handling5m 39s
-
6.Restoring All Databases from Most Recent Backup5m 50s
-
7.Finding Disk Space for SQL Files8m 5s
-
8.Displaying Results in Grid View6m 19s
-
9.sqlps Utility5m 58s
-
10.Creating SQL Audits5m 15s
-
11.SQLSERVER Drive and Invoke Sqlcmd cmdlets4m 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.