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)
- 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.
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.
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.
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).