SQL Server PowerShell

https://learn.microsoft.com/en-us/powershell/module/sqlserver/?view=sqlserver-ps

Admin

SQL Server PowerShell provides cmdlets and providers for managing and automating various aspects of...

Tokens:653

Snippets:6

Trust Score:10

Update:2 months ago

Show doc for...

Tokens:

Raw

### SqlServer PowerShell Cmdlets

Source: https://learn.microsoft.com/en-us/powershell/module/sqlserver/?view=sqlserver-ps

A collection of PowerShell cmdlets for managing SQL Server environments, including Analysis Services operations, availability group configuration, and security assessments.

```APIDOC
## SqlServer PowerShell Cmdlets

### Overview
The SqlServer module provides a comprehensive set of cmdlets for managing SQL Server instances. Below are the primary operations available:

- **Invoke-ASCmd**: Executes XMLA, TMSL, DAX, MDX, or DMX scripts against Analysis Services.
- **Invoke-PolicyEvaluation**: Evaluates SQL Server policy-based management policies.
- **Invoke-ProcessASDatabase**: Processes an Analysis Services database.
- **Invoke-ProcessCube**: Processes a specific cube.
- **Invoke-ProcessDimension**: Processes a specific dimension.
- **Invoke-ProcessPartition**: Processes a specific partition.
- **Invoke-ProcessTable**: Processes a specific table.
- **Invoke-SqlAssessment**: Runs SQL Server best practice assessment checks.
- **Invoke-Sqlcmd**: Executes SQLCMD-supported scripts.
- **Invoke-SqlColumnMasterKeyRotation**: Initiates column master key rotation.
- **Invoke-SqlNotebook**: Executes SQL Notebook (.ipynb) files.
- **Invoke-SqlVulnerabilityAssessmentScan**: Runs a vulnerability assessment scan.
- **Join-SqlAvailabilityGroup**: Joins a replica to an availability group.
- **Merge-Partition**: Merges partitions.
- **New-RestoreFolder/Location**: Manages restore paths.
- **New-SqlAvailabilityGroup/Listener/Replica**: Manages availability group infrastructure.
- **New-SqlAzureKeyVaultColumnMasterKeySettings**: Configures Azure Key Vault master keys.
- **New-SqlBackupEncryptionOption**: Configures backup encryption.
- **New-SqlColumnEncryptionKey/MasterKey**: Manages column encryption keys.
- **Read-SqlTableData/ViewData/XEvent**: Reads data from tables, views, or XEvent sessions.
- **Remove-RoleMember/SqlAvailabilityGroup/Replica/ColumnEncryptionKey/MasterKey**: Removes various SQL Server objects.
```

Tokens:

Raw