powershell玩转SQL SERVER所有版本的方法（powershell sed）奔走相告

文章摘要

这篇文章介绍了SQL Server的模块SQLPS中的一系列命令及其功能，主要用于管理和配置SQL Server的存储组、数据库、客户端、网络配置、存储性能优化和智能管理员。命令包括添加、删除、配置、恢复等功能，用于管理SQL Server的可用性组、防火墙规则、备份、转换编码名称、启用/禁用SQL Always On等功能。这些命令帮助用户有效控制和优化SQL Server的运行环境和性能。

get-command * -module sqlps
Decode-SqlName
Encode-SqlName
SQLSERVER:
Add-SqlAvailabilityDatabase
Add-SqlAvailabilityGroupListenerStaticIp
Add-SqlFirewallRule
Backup-SqlDatabase
ConvertFrom-EncodedSqlName
ConvertTo-EncodedSqlName
Convert-UrnToPath
Disable-SqlAlwaysOn
Enable-SqlAlwaysOn
Get-SqlCredential
Get-SqlDatabase
Get-SqlInstance
Get-SqlSmartAdmin
Invoke-PolicyEvaluation
Invoke-Sqlcmd
Join-SqlAvailabilityGroup
New-SqlAvailabilityGroup
New-SqlAvailabilityGroupListener
New-SqlAvailabilityReplica
New-SqlBackupEncryptionOption
New-SqlCredential
New-SqlHADREndpoint
Remove-SqlAvailabilityDatabase
Remove-SqlAvailabilityGroup
Remove-SqlAvailabilityReplica
Remove-SqlCredential
Remove-SqlFirewallRule
Restore-SqlDatabase
Resume-SqlAvailabilityDatabase
Save-SqlMigrationReport
Set-SqlAuthenticationMode
Set-SqlAvailabilityGroup
Set-SqlAvailabilityGroupListener
Set-SqlAvailabilityReplica
Set-SqlCredential
Set-SqlHADREndpoint
Set-SqlNetworkConfiguration
Set-SqlSmartAdmin
Start-SqlInstance
Stop-SqlInstance
Suspend-SqlAvailabilityDatabase
Switch-SqlAvailabilityGroup
Test-SqlAvailabilityGroup
Test-SqlAvailabilityReplica
Test-SqlDatabaseReplicaState
Test-SqlSmartAdmin