Managing SQL Server with PowerShell: Part 1 – The Tools

preview_player
Показать описание

Discover the basics of getting started using PowerShell with SQL Server.

Connect with SolarWinds:
Рекомендации по теме
Комментарии
Автор

Thanks for your valuable time I am able to perform this steps

dbamentorparag
Автор

When I do Import-Module "sqlps" -DisableNameChecking. Base dir is not changed to sql server as shown in the video. I also tried installing sql server module but get the error

PS C:\Windows\system32> Import-Module "sqlps" -DisableNameChecking
PS C:\Windows\system32> dir
Audits
AvailabilityGroups
BackupDevices
Credentials
CryptographicProviders
Databases
Endpoints
JobServer
Languages
LinkedServers
Logins
Mail
ResourceGovernor
Roles
ServerAuditSpecifications
SystemDataTypes
SystemMessages
Triggers
UserDefinedMessages
PS C:\Windows\system32> Install-Module -Name SqlServer
: No match was found for the specified search criteria and module name 'SqlServer'.
Try Get-PSRepository to see all available registered module repositories.
At C:\Program char:21
+ ... $null = @PSBoundParameters
+
+ CategoryInfo : ObjectNotFound: [Install-Package], Ex
ception
+ FullyQualifiedErrorId : NoMatchFoundForCriteria, Microsoft.PowerShell.PackageManagement.Cmdlets.InstallPackage

PS C:\Windows\system32>

KushalSolanki
Автор

Please share the link of part 2, It's interesting.

shaktisingh