
VS Code is rapidly displacing notepad++ for me
Been playing with this recently and colour me impressed, saves a lot of the faff with SSMS and is perfect for quick dirty queries, almost as conveinent as doing it on the command line, and infinitly preferable to it when dealing with more than 5 columns especially if they are all varchars at default length (why do people insist on 128 or 256 chars when the column has a constraint limiting it to 3????, come on guys girls mammals, you know enough to write the constraint, not enough to fix your ddl so its readable on command line????; i digress).
One thing I REALLY like about it is the seemless git integration (i know git but its better than SVN and anything better lacks the traction to displace it), so unlike SSMS where you have leave the IDE to commit your changes, its all in hand here, plus its MUCH easier to work with SQL files, which is great when testing DB upgrades etc. SSMS i have always found to be somewhat lacking in that regard