Windows Azure Pack SQL Server

Windows PowerShell® is a task-based command-line shell and scripting language designed especially for system administration. This reference topic for the information technology (IT) professional provides assistance in utilizing the Windows PowerShell cmdlets to script and automate tasks.

This section contains the help topics for the Windows Azure Pack for Windows Server SQL Server cmdlets.

Name Description

Add-MgmtSvcSqlHostingServer

Adds a SQL Server hosting server to Windows Azure Pack.

Add-MgmtSvcSqlResourcePoolTemplate

Adds a SQL resource pool template.

Add-MgmtSvcSqlServerGroup

Adds a SQL Server group to Windows Azure Pack.

Get-MgmtSvcSqlDatabase

Gets a SQL Server database.

Get-MgmtSvcSqlHostingServer

Gets a SQL Server hosting server.

Get-MgmtSvcSqlHostingServerByGroup

Gets hosting servers by SQL Server group.

Get-MgmtSvcSqlHostingServerMetric

Gets capacity metrics for a SQL Server hosting server.

Get-MgmtSvcSqlHostingServerConsistency

Detects inconsistencies between a SQL Server resource provider and what is currently hosted.

Get-MgmtSvcSqlResourcePoolByGroup

Gets resource pools created within a server group.

Get-MgmtSvcSqlResourcePoolByServer

Gets resource pools created on a hosting server.

Get-MgmtSvcSqlResourcePoolByTemplate

Gets resource pools created by using a template.

Get-MgmtSvcSqlResourcePoolTemplate

Gets resource pool templates in Windows Azure Pack.

Get-MgmtSvcSqlServerGroup

Gets a SQL Server group.

New-MgmtSvcSqlResourcePoolTemplate

Creates a SQL resource pool template.

Remove-MgmtSvcSqlHostingServer

Removes a hosting server from Windows Azure Pack.

Remove-MgmtSvcSqlResourcePoolTemplate

Removes a resource pool template from Windows Azure Pack.

Remove-MgmtSvcSqlServerGroup

Removes a SQL Server group from Windows Azure Pack.

Set-MgmtSvcSqlHostingServer

Updates a SQL Server hosting server.

Set-MgmtSvcSqlResourcePoolTemplate

Modifies values of a resource pool template.

Test-MgmtSvcSqlHostingServer

Verifies a SQL Server hosting server can be created.

Note

To list all the cmdlets that are available, type Get-Command –Module WAPSQLServer.

For more information about, or for the syntax of, any of the cmdlets, use the Get-Help <cmdlet name> cmdlet, where <cmdlet name> is the name of the cmdlet that you want to research. For more detailed information, you can run any of the following cmdlets:

Get-Help <cmdlet name> -Detailed
Get-Help <cmdlet name> -Examples
Get-Help <cmdlet name> -Full