SQL [History] Archive

The SQL History now allows you to automatically archive SQL statements that are removed from the SQL History when the number of queries exceeds the defined maximum number. This option can be turned on and off, and an archive folder can be selected by a user in File->Options:General:History. Queries from SQL History may also be selected, manually moved and saved in SQL History Archive. A tab has been added to the SQL History window which allows a user to search through the archive by keyword and date, and present search results as a table which is similar to the current SQL History tab. The last selected search parameters are persistent across multiple runs of the application. If a search takes an extended period of time, a progress monitor pops up showing the operation progress.

Diagram of how SQL History can be used for Audit Trail and SQL Query Analysis. SQL History Archives can be parsed and stored in a database for keeping a full audit trail of who did what on the database at what time. This can be valuable including for Sarbanes-Oxley compliance or any other regulatory requirements.