This one is a very simple and quick tip.
When working in SQL Server Management Studio (SSMS), I often need to open File Explorer in the folder where the script file is stored. Turns out there is an easy way to do that.
There are two interesting options when you right-click the tab at the top of a query window:
Note that you can open the containing folder for the script. You can also copy the path to the script into the clipboard.