File comparison in SSMS
When I’m working with git, I like to compare files at the commit level. You have version X displayed in the left window, version Y in the right window, and any differences in the two versions are shown in color - extra changes are shown in green, and missing changes are shown in red. On one of my last projects I needed to compare changes in a .sql script that was not available in SSDT, but only in SSMS. That’s when I said to myself, gosh, how could I use a version of file change comparison as we know it from git… I don’t even know how but by chance I came across this article https://raresql.com/2023/04/04/sql-server-how-to-compare-files-in-sql-server-management-studio-ssms/ where this functionality is described and available directly in SSMS!

Plus, I found out that SSMS has something called command window, awesome stuff :-)