Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Get-AzureSqlDatabaseServerQuota

Get-AzureSqlDatabaseServerQuota

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Returns the quota information for a specified Azure SQL Database Server.

Syntax

Get-AzureSqlDatabaseServerQuota [-ConnectionContext] [-QuotaName] [<CommonParameters>]

Get-AzureSqlDatabaseServerQuota [-ServerName] [-QuotaName] [<CommonParameters>]

Detailed Description

The user specifies the server by supplying a connection context or the server name. If a quota name is not specified, then all the quota information for the server is returned.

Parameters

-ConnectionContext <IServerDataServiceContext>

The connection context to the specified SQL Database Server.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

true (ByValue, ByPropertyName)

Accept wildcard characters?

false

-QuotaName <String>

The name of the quota value to be retrieved. If a quota name is not specified, then all the quota information for the server is returned.

Aliases

None

Required?

false

Position

1

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

-ServerName <String>

The name of the SQL Database Server.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

Input Type


Return Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.ServerQuota[]

Notes

Authentication: This cmdlet can use either SQL Server authentication or certificate-based authentication. For examples of setting up authentication, see the Get-Help topic for the New-AzureSqlDatabaseServerContext cmdlet.

Examples

-------------------------- EXAMPLE 1 --------------------------

This example returns the quota, "Premium_Databases", from the Azure SQL Database Server specified by the connection $ctx.

PS C:\> C:\PS>$quotaPremium = GetAzureSqlDatabaseServerQuota $ctx QuotaName "Premium_Databases"

-------------------------- EXAMPLE 2 --------------------------

This example returns a list of all quota values from the Azure SQL Database Server specified by the connection $ctx.

PS C:\> C:\PS>$quotaList = GetAzureSqlDatabaseServerQuota $ctx

New-AzureSqlDatabaseServerContext