The SSMS plugin SSMSBoost has a feature that I think might be in DataGrip, but I'm not sure. SSMSBoost keeps track of all queries executed in SSMS, including:
- Original SQL Statement(s)
- Connection Details
- Result: success, failed, canceled
- Start Date and Execution Time
- Messages, e.g. NULL values is eliminated...
- Error Messages
- Count of Records Returned, but not the actual results
I think the SQL Log in DataGrip appears to have all these features, but I can't find much information about it:
- How long is the log file kept?
- Is a new file created once it reaches a certain size?
- Can the location be changed to a network drive?
- Are there any queries that are not logged?
Lastly, what is the difference between the SQL Log, console history, and Local History? I don't see why there are three different histories.