Tips and tricks on how to move your old SQL Servers to Azure;
What to do about
- GetDate() running in UTC,
- DayOfWeek starts on Sundays,
- the fixed database collation,
- SQL Agent is missing (how we replaced it with "Elastic Jobs")
I'll also show how we use External Tables as a replacement for Linked Servers, and if time permits, I'll show what new SQL features we're using (temporal tables).