Working with SQL PowerShell
PowerShell 3
| Beginner
- 11 Videos | 1h 1m 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 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
-
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.
