Jetbrains, all round. Datagrip is way faster and easier than SSMS for day to day queries, Clion does a great job in almost anything compiled, PyCharm makes it easier to manage large Python code bases over standard, the list goes on. Their software is expensive, but so so good.
Oh yeah, definitely this. If it doesn’t break down in water, it won’t break down in the pipes.