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).