Traditionally converting dates between time zones and accurately handling daylight savings time has been a huge pain. SQL Server 2016's AT TIME ZONE feature makes this a little easier.
Related blog post with code snippets:
https://bertwagner.com/2018/03/27/at-...
Twitter:
/ bertwagner
Facebook:
/ sqlwithbert