How to Rename SQL Azure database

Option 1 :

   1. You can also connect with SQL Server Management Studio and rename it in Object Explorer. 

    2. Do this by clicking on the database name (as the rename option from the dropdown will be greyed out)

Option 2 :

  1.  Connect with SQL Server Management Studio to your Azure database server

  2. Right-click on the master database and select 'New Query'. 

  3. In the New Query window that will open type 

ALTER DATABASE [dbname] MODIFY NAME = [newdbname].

Cheers,

Venkatesan Prabu .J

Microsoft Azure Cosmosdb vs Azure Table Storage by Microsoft MVP

Hi Readers,

   Below table provides you a clear picture on different data storages.




Cheers,
Venkatesan Prabu .J

How to reset password in Azure database

Prerequisite of this article : SQL Server and SQL Database needs to be created in the Azure database.

Requirement : Need to change the SQL Database password which is already created.

Below is the step by step procedure to reset your Azure password

Go to azure portal: https://portal.azure.com

1. Click browse (to view all resources) in the Microsoft Azure Portal
2. Select SQL databases
3. Choose a database that's in the server you want to change the credentials.
4. Select the server name url for that selected database. This should open up the server configuration blade.
5. Reset password is the second button from left.

Final Touch

1. On the Reset Password dialogue, specify a new password and then confirm the new password.
2. To complete the operation, click the Check mark button at bottom right. You will be returned to the Server Dashboard for the server.

Cheers,

Venkatesan Prabu .J