Enhancing Your Troubleshooting Toolset with PowerShell - SQL Server 2012 Internals and Troubleshooting - page 391

What's New in SQL Server 2012
Prior to SQL Server 2012, the SQL Server team created a PowerShell mini-shell called SQLPS. This
has changed in SQL Server 2012; SQLPS is now a standard PowerShell 2.0 host and imports the
SQLPS module. This makes life a lot easier if you are already using a standard PowerShell host
because you too can use import-module SQLPS and SQLASCMDLETS to gain all the SQL Server pro-
vider functionality within another PowerShell host.

SQL Server 2012 ships with the following 40 cmdlets:

SQLPS CMDLETS SQLASCMDLETS CMDLETS

Add-SqlAvailabilityDatabase Add-RoleMember

Add-SqlAvailabilityGroupListenerStaticIp Backup-ASDatabase

Backup-SqlDatabase Invoke-ASCmd

Convert-UrnToPath Invoke-ProcessCube

Decode-SqlName Invoke-ProcessDimension

Disable-SqlHADRService Invoke-ProcessPartition

Enable-SqlHADRService Merge-Partition

Encode-SqlName New-RestoreFolder

Invoke-PolicyEvaluation New-RestoreLocation

Invoke-Sqlcmd Remove-RoleMember

Join-SqlAvailabilityGroup Restore-ASDatabase

New-SqlAvailabilityGroup
New-SqlAvailabilityGroupListener
New-SqlAvailabilityReplica
New-SqlHADREndpoint
Remove-SqlAvailabilityDatabase
Remove-SqlAvailabilityGroup
Remove-SqlAvailabilityReplica
Restore-SqlDatabase
Resume-SqlAvailabilityDatabase
Set-SqlAvailabilityGroup
Set-SqlAvailabilityGroupListener
Set-SqlAvailabilityReplica
Set-SqlHADREndpoint
Suspend-SqlAvailabilityDatabase
Switch-SqlAvailabilityGroup
Test-SqlAvailabilityGroup
Test-SqlAvailabilityReplica
Test-SqlDatabaseReplicaState

Of these cmdlets, 22 are for managing the new High Availability features and Analysis Services,
which I'm not covering in this chapter. The other notable cmdlets from a troubleshooting and