Managing SQL Server
PowerShell 3
| Beginner
- 12 Videos | 1h 13m 57s
- Earns a Badge
The PowerShell environment installed with SQL Server is a primary method of configuration and management. Discover how to begin managing SQL Server with PowerShell, SQL Management Objects, and Windows Management Instrumentation.
WHAT YOU WILL LEARN
-
recognize how PowerShell integrates directly within SQL Server by using preloaded modules and assembliesidentify and sort SQL Server services using PowerShellestablish a connection with a SQL Server database by calling a SqlConnection classload an SMO assembly into PowerShellcreate a SQL Server .NET object that connects to and iterates through a SQL Server instanceto view the different objects, methods, and properties associated with ituse the get-Member cmdlet to display the methods and properties associated with a database
-
script out SQL Server tables using SMO in PowerShellback up and restore databases from within PowerShell using SMO and SQL Server cmdletsmanage SQL Server services using cmdlets from within Microsoft's Windows PowerShellmanage client network protocols with WMI using PowerShell cmdlets in Microsoft SQL Serverview and manage aliases using WMI in PowerShellenable FILESTREAM for a server instance using WMI in PowerShell
IN THIS COURSE
-
1.Introduction to Powershell and SQL Server3m 40sUP NEXT
-
2.Working with Services4m 14s
-
3.PowerShell and the SQLConnection .NET Class9m 39s
-
4.Loading the SMO Assemblies into PowerShell4m 9s
-
5.Working with SQL Server Using SMO3m 17s
-
6.Working with Databases Using SMO6m 40s
-
7.Working with Tables Using SMO10m 13s
-
8.Backing up and Restoring with SMO7m 14s
-
9.Managing SQL Server Services5m 22s
-
10.Managing Client Network Protocols with WMI8m 32s
-
11.Managing SQL Server Client Aliases with WMI3m 20s
-
12.Changing FILESTREAM Settings with WMI7m 37s
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.