This article is contributed. See the original author and article here.
Databases > SQL Database
- Work with a freelancer
- View a summary of your resources on a map and in various charts
- Portal search improvements
Let’s look at each of these updates in greater detail.
Databases > SQL Database
Open your SQL database in Azure Data Studio
The Azure portal now includes a one-click connection to Azure Data Studio from any Azure SQL Database. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, SQL Notebooks, and an integrated terminal. Simply open the Azure portal, navigate to any SQL Database, and click “Connect with Azure Data Studio”. The experience includes a link to download Azure Data Studio if you do not already have it. The connection info is passed to Azure Data Studio and the connection will automatically go through with AAD or will require just a password to complete the connection.
- Sign in to Azure portal
- Click “All Services”
- Search and select “Azure SQL”
- Find and select any SQL database
- Click “Connect with…”, then click “Azure Data Studio”
6. Click to download or launch Azure Data Studio
7. Connect to your database and try out Azure Data Studio!
Work with a freelancer
It’s now easier than ever to connect and start working with a freelancer who can help you complete your short-term, on-demand Azure projects. Microsoft and Upwork are partnering to provide you with easy access to freelancers with current Azure certifications.
In the upper right corner of the Azure portal, click on the question mark. You’ll see the freelancer information pop up below.
View a summary of your resources on a map and in other charts
On certain resource list views, you can now see a summary count of your resources. This feature allows you to visually represent your resources on a chart, summarizing over location, resource group, subscription, and resource type. A powerful use case of this would be to visually represent your resources on a map.
a. Go to a list of resources. Check if it has a “List view” dropdown at the top right of the list. If so, you can proceed with the demo. Otherwise, use the “All resource” list as an example.
b. In the dropdown, select “Summary view” where you will see a summary count of your resources. You can choose to summarize by location, resources group, subscription, and type, if applicable, from the menu on the left.
c. You can use the filters to scope your results.
d. In this view, you can change the visualization to a map, bar chart, donut chart, or list. (Note that maps are available for location only).
e. If you have more than 10 items in a bar or donut chart, there will be a dropdown to choose your summary preference (see screenshot). If you want to see more than 10 items, change the visualization to “list” as described in step d.
f. If you like this view, you can save it using the “Manage view” dropdown for easy access.
g. If you want to drill down into one of the summary items, click into the item and you will see a list of the resources in that category.
Portal search improvements
We have made several improvements to the portal’s search capabilities.
- You can now use the portal’s global search bar to search for resources by IP address. The search will find all resources that have the specified IP address anywhere within their resource properties.
- You can now search for Azure invoices by typing in an invoice id.
- We have improved the search functionality on all pages that have a menu on the left. Previously, a term had to be spelled correctly in order to produce results, but now, slight misspellings are accepted, and any existing results will be shown.
Step 1 – Log into the portal
Step 2 – Paste an IP address or an invoice ID into the global search bar.
Sample search by IP address:
Sample search by Invoice ID:
The Microsoft Intune team has been hard at work on updates as well. You can find the full list of updates to Intune on the What’s new in Microsoft Intune page, including changes that affect your experience using Intune.
Azure portal “how to” video series
Have you checked out our Azure portal “how to” video series yet? The videos highlight specific aspects of the portal so you can be more efficient and productive while deploying your cloud workloads from the portal. Check out our most recently published videos:
The Azure portal has a large team of engineers that wants to hear from you, so please keep providing us your feedback in the comments section below or on Twitter @AzurePortal.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.