My biggest problem is remembering the things that are done similarly everywhere: is it .length, .len, .size or .count? Or are they methods? Or globals? Why do these things have to differ even between SQL dialects
This is why I'm such a big fan of good code completion. I don't need it that much in my main language, but when I use other languages every once in a while it's much much quicker than googling these things.
Yes to that! Last semester I had to program in Java, and while having very little specific knowledge of the languague, the IDE (and some basic OOP understanding) basically enabled me to solve the tasks without any troubles.
Java is especially good for that, though. You just add a point to a variable and choose what you want (out of 1000 methods).