SQLBits 2020

To Azure SQL Database from SQL Server 2008

Tips and tricks on how to move your old SQL Servers to Azure; what to do about GetDate(), your SQL Agent jobs and all your existing tools.

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