Microsoft announced the availability of an in-browser query tool that will provide you with an efficient way to execute queries on your Azure SQL Databases as well as on SQL Data Warehouses, without leaving the Azure Portal.
Microsoft, in its official blog, states,
“This SQL Database Query Editor is now in public preview in the Azure Portal.’
This editor will allow you to access and query your database without connecting from a client tool or configure firewall rules.
The company states,
“The various features in this new editor create a seamless experience for querying your database.”
Query Editor capabilities
Connect to your database
Before you go on to execute queries against your database, it is necessary for you to either login with your SQL Server or Azure Active Directory (AAD) credentials. However, if you are the AAD admin for this particular SQL Server, you will be able to automatically log in when you first open the Query Editor using AAD single sign-on.
Write and execute T-SQL scripts
All those who are familiar with writing queries in SSMS, Microsoft states that “you will feel right at home in the in-browser Query Editor.”
Numerous common queries can be run in this editor, such as - create new table, display table data, edit table data, create a stored procedure, or drop table. Microsoft presents you with the flexibility to execute partial queries or batch queries in this editor. And by utilizing syntax highlighting and error indicating, this editor makes writing scripts really simple.
In addition to this, you will now be able to easily load an existing query file into the Query Editor or save your current script in this editor to your local machine. This ability provides you with the convenience to save and port the queries between editors.
Manage query results
Another similarity that you will find between this Query Editor and SSMS, is the ability to resize the results pane so as to gain the desired ratio between the Editor and Results sections. You will also be able to filter results by keyword rather than scrolling through all the output.