Managing SQL Server

PowerShell 3    |    Beginner
  • 12 Videos | 1h 13m 57s
  • Earns a Badge
Likes 25 Likes 25
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

  • Playable
    1. 
    Introduction to Powershell and SQL Server
    3m 40s
    UP NEXT
  • Playable
    2. 
    Working with Services
    4m 14s
  • Locked
    3. 
    PowerShell and the SQLConnection .NET Class
    9m 39s
    FREE ACCESS
  • Locked
    4. 
    Loading the SMO Assemblies into PowerShell
    4m 9s
    FREE ACCESS
  • Locked
    5. 
    Working with SQL Server Using SMO
    3m 17s
    FREE ACCESS
  • Locked
    6. 
    Working with Databases Using SMO
    6m 40s
    FREE ACCESS
  • Locked
    7. 
    Working with Tables Using SMO
    10m 13s
    FREE ACCESS
  • Locked
    8. 
    Backing up and Restoring with SMO
    7m 14s
    FREE ACCESS
  • Locked
    9. 
    Managing SQL Server Services
    5m 22s
    FREE ACCESS
  • Locked
    10. 
    Managing Client Network Protocols with WMI
    8m 32s
    FREE ACCESS
  • Locked
    11. 
    Managing SQL Server Client Aliases with WMI
    3m 20s
    FREE ACCESS
  • Locked
    12. 
    Changing FILESTREAM Settings with WMI
    7m 37s
    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 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

BOOK Learn dbatools in a Month of Lunches: Automating SQL Server Tasks with PowerShell Commands
BOOK Learn PowerShell in a Month of Lunches: Covers Windows, Linux, and macOS, Fourth Edition
COURSE Google Associate Cloud Engineer: Configuring Google Cloud
Likes 82 Likes 82  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Database Design
Likes 109 Likes 109  
COURSE SQL Concepts & Queries
Likes 498 Likes 498  
COURSE SQL Platform & Installation Best Practices
Likes 74 Likes 74