Databases > SQL Database
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.