Let's face it, most of us store dates in UTC and rely on the front end application to handle local time. Now you've been asked to produce a report across customers in different time zones. Starting SQL 2016, Microsoft introduced the option AT TIME ZONE, which produces a Date Time Offset return. A Date Time … Continue reading UTC to Timezone using At Time Zone option.
Using JSON for Lookup Tables
When creating lookup or reference tables during database design we often run into the problem that the data contained by these tables varies within environments. This can cause problems in the application layer, especially if ENUMS are created based on this table. One of the methods of keeping these tables aligned in a Database Project … Continue reading Using JSON for Lookup Tables