Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to speed up Azure T-SQL queries in the new database query editor. The content of the article is of high quality, so Xiaobian shares it with you as a reference. I hope you have a certain understanding of relevant knowledge after reading this article.

Recently, Microsoft added SQL Database Query Editor to its Azure cloud services. Expert Michael Otey walks you through the new T-SQL development process step by step.

Microsoft has accelerated the pace of its Azure improvements. Not long ago, Azure SQL Database implementations lagged significantly behind on-premises versions. All that has changed, Microsoft now brings recent improvements and updates to Azure ahead of on-premises products. Even so, Azure SQL Database lags behind on-premises SQL Server in one area: T-SQL development.

In order to write and test T-SQL queries for Azure SQL Database, you need to use traditional on-premises tools such as SQL Server Management Studio or Visual Studio to open remote connections. Recently, Microsoft has changed this by introducing SQL Database Query Editor for Azure.

SQL Database Query Editor is currently in preview mode. It is a browser-based tool that users can run directly from the Azure portal, allowing you to write and run T-SQL development queries on Azure SQL databases and SQL data warehouses. You no longer need to use remote client tools to connect, and you don't need to configure network connections or firewall rules, which makes T-SQL development easier.

Start Query Editor

Azure Query Editor does not work with either Azure SQL Database or Azure SQL Data Warehouse databases. To observe the behavior of Azure Query Editor, first open the Azure Portal. Select the SQL Databases blade and navigate to the Azure SQL Database you want to use. Next, click the Tools command, and then click the Query Editor (Preview) option, as shown.

To get started with Query Editor, you need to log in to Azure SQL Database using the login button at the top of the Query Editor window. You can log in using Azure Active Directory authentication, or log in using Azure SQL Database. After logging in, you can develop T-SQL queries in Query Editor, as shown in the figure.

As Figure 2 shows, Azure Query Editor provides complete T-SQL focus syntax to aid T-SQL development. All T-SQL errors are underlined in green. It is worth noting that it does not provide IntelliSense code. Users can use Query Editor to execute any T-SQL supported statement, including creating and deleting tables, stored procedures, and other database objects, and displaying and changing table data. Although the right mouse button does not provide cut and paste functionality, you can copy, paste, and cut text in the Editor pane using the Ctrl-C, Ctrl-V, and Ctrl-X keyboard shortcuts, respectively. To execute all T-SQL statements in the Editor pane, click the Run button at the top of the Query Editor window. You can also use the mouse to highlight the group of statements you want to run and click the Run button.

Query results are displayed in the Results window, which you can see at the bottom of the Query Editor window. You can scroll the rows in the Results window with the mouse and resize the Results window by dragging up or down the bar between the Editor and Results sections. You can also filter the results by keyword by entering text in the filter next to the eye icon. All runtime messages appear in the Messages pane, automatically if the statement returns an error, or you can click the Messages link to view the status of the command.

You can use the Open Query and Save Query options at the top of the Query Editor window to open and save queries you develop. Selecting the Save query option opens the browser Save and Save As dialog box, which allows you to save the query to your local system. By default, queries are saved with the file extension.sql. Using the Open query option displays an Open Files dialog box that allows you to select local files to load into the Query Editor.

Azure SQL Database Query Editor lets you connect T-SQL development queries directly to Azure.

How to speed up Azure T-SQL queries in the new database query editor is shared here. I hope the above content can help you and learn more. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.