Henrik Staun Poulsen
Henrik Staun Poulsen has been working with databases for the past 30 years, from early SQL Server 7 to the the best database; Azure SQL Database.
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).