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

About sqlschool

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is one of fastest growing organization delivering Realtime Training and Realtime Projects exclusively on Microsoft SQL Server. Our Training services include SQL DBA Online Training, MSBI Online Training, SQL DBA Classroom Training, MSBI Classroom Training and Realtime Projects. SQL School, established in February, 2008 is now, one of the best institute offering Trainings on SQL Server, SQL Database Administration (DBA) and Business Intelligence (BI) technologies. We have been working with numerous consultancies in India, US, UK and Australia. We undertake Online Trainings and Corporate Trainings on SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 (DENALI) versions. We make sure that all our sessions are very much interactive and well structured. We encourage every participant to come up with his / her own queries during & after the training sessions. We prefer practical approach rather than theoretical information to master the technical depth of the technology. We provide excellent Lab Handouts for practice, Realtime Case Studies and Projects on SQL Server Administration (SQL DBA) and Microsoft Business Intelligence (MS BI) Training courses. Free LIVE DEMOs would be provided prior to training registration. Specific DAY to DAY Course Plan will also be shared prior to training registration to ensure transparency of our Training services.