Azure Database Display in Service Portal

Service Portal users can now view their deployed Azure SQL databases.

In the example below, the following three types of possible Azure SQL databases are shown in the My Resources section of the Dashboard:

  • Azure SQL Databases (a single server with possibly multiple databases)
  • Azure Managed Instances (a single server with one database)
  • Azure SQL VMs (a VM with SQL Server installed)

My Resources - Databases

Notes:  

  • The Azure SQL VM "SQLVM" appears twice below — once as a database and once as the VM that manages the database. Azure SQL Databases and Azure Managed Instances only appear as database elements because they aren't associated with a VM.
  • This example also shows an AWS RDS database "Se-database-1-instance-1". Service Portal users could already view and manage AWS RDS databases in previous releases.

Users can also view their deployed databases on the Applications page.

Applications - Databases

View detailed database information

In the Service Portal, users can click any listed Azure SQL database to go to its summary page and view more information for it.

Manage databases

Service Portal users can now perform administrative actions for Azure SQL databases.

Users can run the administrative actions from either the Applications page or from a selected Azure SQL database's summary page. The actions can be accessed from the menus at the top of the Service Portal page.

DB admin actions

This ability to perform administrative actions functionality matches that already available for AWS RDS databases.

Providing users with administrative actions allows them to efficiently manage their deployed databases. For example, Service Portal users may be able to run command workflows on their Azure SQL databases (see Running and Scheduling Commands) or request service changes for them (see Submitting Change Requests).