Interview Questions
1. What is SQLPS module and what are its usages?
By importing the SQLPS module into a Windows PowerShell 2.0 environment, we can work with SQL Server from Powersehll. The module loads and registers the SQL Server snap-ins and manageability assemblies.
After importing the sqlps module into Windows PowerShell, we can then:
• Interactively run Windows PowerShell commands.
• Run Windows PowerShell script files.
• Run SQL Server cmdlets.
• Use the SQL Server provider paths to navigate through the hierarchy of SQL Server objects.
• Use the SQL Server manageability object models (such as Microsoft.SqlServer.Management.Smo) to manage SQL
Server objects.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment