Ask HN: Resources for getting back up to speed on SQL

I have accepted a new role that uses MSSQL, I have been using NoSQL at work for the past 4 years but have previously use SQL.

Does anyone have any suggestions on the best resources to use to get me back up to speed, ideally books?

Thanks