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 assemblies
identify and sort SQL Server services using PowerShell
establish a connection with a SQL Server database by calling a SqlConnection class
load an SMO assembly into PowerShell
create a SQL Server .NET object that connects to and iterates through a SQL Server instanceto view the different objects, methods, and properties associated with it
use the get-Member cmdlet to display the methods and properties associated with a database -
script out SQL Server tables using SMO in PowerShell
back up and restore databases from within PowerShell using SMO and SQL Server cmdlets
manage SQL Server services using cmdlets from within Microsoft's Windows PowerShell
manage client network protocols with WMI using PowerShell cmdlets in Microsoft SQL Server
view and manage aliases using WMI in PowerShell
enable FILESTREAM for a server instance using WMI in PowerShell
IN THIS COURSE
-
3m 40sUpon completion of this video, you will be able to recognize how PowerShell integrates directly with SQL Server by using preloaded modules and assemblies. FREE ACCESS
-
4m 14sFind out how to identify and sort SQL Server services using PowerShell. FREE ACCESS
-
3. PowerShell and the SQLConnection .NET Class9m 39sIn this video, you will learn how to establish a connection with a SQL Server database by using the SqlConnection class. FREE ACCESS
-
4. Loading the SMO Assemblies into PowerShell4m 9sIn this video, you will load an SMO assembly into PowerShell. FREE ACCESS
-
5. Working with SQL Server Using SMO3m 17sLearn how to create a SQL Server .NET object that connects to and iterates through a SQL Server instance to view the different objects, methods, and properties associated with it. FREE ACCESS
-
6. Working with Databases Using SMO6m 40sTo find out how to use the get-Member cmdlet to display the methods and properties associated with a database, consult PowerShell documentation or a related online forum. FREE ACCESS
-
7. Working with Tables Using SMO10m 13sLearn how to script out SQL Server tables using SMO in PowerShell. FREE ACCESS
-
8. Backing up and Restoring with SMO7m 14sLearn how to back up and restore databases from within PowerShell using SMO and SQL Server cmdlets. FREE ACCESS
-
9. Managing SQL Server Services5m 22sIn this video, learn how to manage SQL Server services using cmdlets from within Microsoft's Windows PowerShell. FREE ACCESS
-
10. Managing Client Network Protocols with WMI8m 32sIn this video, you will learn how to manage client network protocols with WMI using PowerShell cmdlets in Microsoft SQL Server. FREE ACCESS
-
11. Managing SQL Server Client Aliases with WMI3m 20sIn this video, you will learn how to view and manage aliases using PowerShell's WMI cmdlets. FREE ACCESS
-
12. Changing FILESTREAM Settings with WMI7m 37sIn this video, learn how to enable FILESTREAM for a server instance using 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.
