To Azure SQL Database from SQL Server 2008 with Henrik Staun Poulsen

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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

Presented by Henrik Staun Poulsen at SQLBits 2020

YouTube

About

SQLBits was started by a group of individuals that are passionate about the Microsoft Data Platform. There is a breadth of knowledge in the data community that will benefit everyone. We want to spread that knowledge.

We all work in the data and SQL space, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.

To Azure SQL Database from SQL Server 2008

About

Useful information