Azure Data Studio is Microsofts cross-platform (it works on MacOS and Linux unlike SSMS) database IDE. Despite it’s name you can connect to on-premise DBs too just like SSMS.
Microsofts What is Azure Data Studio page has a good overview of the different functionality available in ADS and also outlines why you might choose ADS over SSMS but here I’m just going to show some quick examples of the charting capabilities available. These give you a nice simple way to visualize data direct in the IDE.
Clicking the chart icon on the RHS gives us a number of options for charting the results as seen below. The specific options available depend on what type of chart you select.
There are ten chart types supported, but not all will be relevant to all result sets. You get more power in excel or dedicated charting solutions but if your query is simple the charting in ADS can be very helpful. I find myself using it a lot in combination with group by statements.
A few examples of charts based on the above sales location data are below. In order, the charts are Bar, Doughnut, Line and Horizontal Bar.
Despite its lack of visual feedback you can upload files directly into your Azure App Service via the Azure portal. This can be done via the Kudo Console or in the new App Service Editor (preview).
To open the Kudo Console navigate to YOUR APP SERVICE -> Development Tools -> Advanced Tools or bookmark https://yourappservice.scm.azurewebsites.net/DebugConsole. And then just drag and drop the files you want uploaded onto the relevant folder.
To open App Service Editor navigate to YOUR APP SERVICE -> Development Tools -> App Service Editor (Preview) or bookmark https://yourappservice.scm.azurewebsites.net/dev. You can upload files by dragging them onto the Explore pane on the LHS.
Two methods of getting FTP details for an Azure App Service are below.
Download FTP details via ‘Get publish profile’
Navigate to your App Service and click ‘Get publish profile’ along the top navigation bar. This will download a .PublishSettings file which will contain all your FTP details including host, username and password.
View FTP details via Deployment Center
You can also view your details via Deployment Center which is under the Deployment link on the LHS. Select FTP and click Dashboard at the bottom and Azure will show a popup with your FTP details.
If you’ve got an Azure CDN endpoint hooked into an Azure Storage account you may get an error stating ‘The specified resource does not exist‘ when you try to access a file through the CDN URL endpoint.
If your sure the file exists in your storage account container most likely you’ve not set the access permissions on your storage container to allow anonymous blob access. Blobs that are shared via Azure CDN must support anonymous access. Turning it on is easy.
1 – Navigate to your Azure Storage account and then ‘Containers’ and select the relevant container and click ‘Change access level’
2 – Select ‘Blob (anonymous read access for blobs only)’