Azure SQL Database Commands

Azure SQL Database Power Shell – TOP TEN Commands

Azure SQL Database Power Shell – TOP TEN Commands

Example 1: Create a new Azure SQL Database server
New-AzureRmSqlServer -ResourceGroupName “ResourceGroup01” -Location “Central US” -ServerName “server01” –
Example 2: Create a new Azure SQL Database
New-AzureRmSqlDatabase -ResourceGroupName “ResourceGroup01” -ServerName “Server01” -DatabaseName “Database01”
Example 3: Get all databases on a server
Get-AzureRmSqlDatabase -ResourceGroupName “resourcegroup01” -ServerName “server01”
Example 4: Get a database by name on a server
Get-AzureRmSqlDatabase -ResourceGroupName “ResourceGroup01” -ServerName “Server01” -DatabaseName “Database02”
Example 5: Create an elastic database on a specified server
New-AzureRmSqlDatabase -ResourceGroupName “ResourceGroup01” -ServerName “Server01” -DatabaseName “Database01” –
ElasticPoolName “ElasticPool01”
Example 6: Get all deleted database backups on a server
Get-AzureRMSqlDeletedDatabaseBackup -ResourceGroupName “ContosoResourceGroup” -ServerName “ContosoServer”
Example 7: Get a specified deleted database backup
Get-AzureRMSqlDeletedDatabaseBackup -ResourceGroupName “ContosoResourceGroup” -ServerName “ContosoServer” -DatabaseName
“ContosoDatabase”
Example 8: Delete a communication link
Remove-AzureRmSqlServerCommunicationLink -ResourceGroupName “ResourceGroup01” -ServerName “ContosoServer17” -LinkName
“Link01”
Example 9: Remove the auditing of an Azure SQL server
Remove-AzureRmSqlDatabaseAuditing -ResourceGroupName “ResourceGroup01” -ServerName “Server01”
Example 10: Remove a server
Remove-AzureRmSqlServer -ResourceGroupName “ResourceGroup01” -ServerName “Server01”

Azure SQL Database Power Shell – TOP TEN Commands

HOW TO EXECUTE ABOVE COMMANDS?

Step 1: Login to your Azure Account  (portal.azure.com)

Step 2: Create one or more SQL Servers and One or more SQL Databases in your Azure Account

Step 3: Log in to shell.azure.com

Step 4: Select the option : POWERSHELL from TOP >> LEFT Corner as shown below:

 

For more information and in-depth practical training on Azure SQL Database & Power Shell, register today for free demo at: http://sqlschool.com/SQL-Azure-Online-Training.html

Register today for Azure SQL Database & Power Shell Training

   +91-9666440801 (INDIA)
   +91-9542916779 (INDIA)
   +91-(0)40 64577244 (INDIA)
   +1-510-400-4845 (USA/Canada)
Reach us on our Toll Free Number:
+91 90 1434 1434  (Available : 24 x 7)
Website: http://www.sqlschool.com
Power Shell Training @ http://sqlschool.com/SQL-Azure-Online-Training.html