AT TIME ZONE in T-SQL is great for bucketing counts (like daily) while respecting historical offset changes like daylight saving.

Small gotcha: You'll need to map from IANA to Windows Time Zone IDs for Azure SQL if sending IANA time zone via a browser.

https://learn.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql

#sql