I just downloaded the latest release of Azure Data Studio. A new extension came with it that I really like, Query History. According to the documentation, the Query History extension does this: “Adds a Query History panel for viewing and running past executed queries”.
This installation of this extension is pretty simple and does not require a restart of Azure Data Studio. However, if you disable or uninstall the extension, you will need to restart ADS.
If you look at the View menu, you will notice that there is not a menu item for “Query History”.
This will change once the extension is installed. You will find the Query History item just under Output.
Once you install the extension, you will now begin to see query history. If you run a query, you will see the history as seen below. If you to not see this at the bottom of the screen, go to the menu item mentioned above.
When you run a query, it takes a very short period of time for it to appear in the history. In the above image, I ran three queries, two of which were the same query. This window is not part of the query window. Since it is a separate window, it will collect queries from all tabs that are open. Each row in the history will return three things, the query, the server and database uses as well as the times stamp of when the query was ran. The server can be seen in the green box below. Sometimes a forth item is included in the list of items returned, the icon that is at the far left of each row.
Now that we have history, let’s take a moment to see what we can do. First of all, if you float your cursor over one of the queries, you will see a pop up. This pop up will display the query.
You will see a lot more options if you right click on one of the queries.
All the options are pretty straight forward and really don’t need a great deal of explanation. The bottom option, Pause Query History Capture I can see being useful if you are running query that you don’t want to be part of the history or just running too many queries at the moment.
Since these options are pretty straight forward, let’s take a look at a few questions.
What happens to the history when Azure Data Studio is closed?
The history is no longer available
What if I execute a batch, will each query in the batch be a separate line?
All the queries for the batch will be on the same line. The query in the green box is actually two select statements.
To the left of the query, I see a green check mark. What are other icons I might see?
There is currently only one other icon you might see. The red X when there is an error.
When there is a error, you will see a small number next to the “Problem” tab. When you clock to this tab, you can now see details on what the error was.
What’s the difference between “Run Query” and “Open Query”?
Open query will do just that. Open the query so you can review the TSQL. Run query will simply run the query and you will see any results if there are any.
Over all I really like this extension and can really see the practical use of it. Just remember, this extension does not stored the queries beyond the Azure Data Studio session.
Thanks for visiting my blog!!!