HomeWinBuzzer NewsMicrosoft Announces Public Preview of SQL Database Query Editor in Azure Portal

Microsoft Announces Public Preview of SQL Database Query Editor in Azure Portal

Microsoft's new SQL Database Query Editor tools lets users manage, write and execute queries without the need for firewall rules or a client tool connection. It allows for popular queries such as the creation of new tables and stored procedures.


has released a robust in-browser query tool for the Azure portal. The SQL Database Query Editor lets users execute queries straight from the portal without having to connect a client tool or create firewall rules.

SQL Database Query Editor Features

The editor comes with several features that program manager Ninar Nuemah believes will “create a seamless experience.” Here's a quick rundown of the functionality:

Connect to your database: Before executing queries against your database, you must login with either your SQL server or Azure Active Directory (AAD) credentials. If you are the AAD admin for this SQL server, you will be automatically logged in when you first open the Query Editor using AAD single sign-on.

Write and execute T-SQL scripts: Many 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. You have 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 a breeze. Additionally, you can easily load an existing query file into the Query Editor or save your current script in this editor to your local machine.

Manage query results: Resize the Results pane to get the desired ratio between the Editor and Results sections. You can also filter results by keyword rather than having to scroll through all the output.”

The Query Editor tools in SQL Database
The Query Editor tools in SQL Database

The new query editor can be found in both SQL database and SQL Data Warehouse. The feature is available as “Query Editor (preview)” under the “Tools” menu. You can find more information on the Azure blog.

Ryan Maskell
Ryan Maskellhttps://ryanmaskell.co.uk
Ryan has had a passion for gaming and technology since early childhood. Fusing the skills from his Creative Writing and Publishing degree with profound technical knowledge, he enjoys covering news about Microsoft. As an avid writer, he is also working on his debut novel.

Recent News