As always: it depends !

With a SQLServer clustered instance, the pain point may be the shared storage.
A single SAN is such a liability ( and still...

This is a way where you can copy data to your AzureSQLDB ( provided you've already implemented the schema ) using Powershell
Write-Datatable can be found here

no. They released it Oct 2 2017

chances are you didn't get a result because tblOrders may exist in multiple schema !

Best practise: always schema-qualify your objects !
   Select ...
from...

First of all: the concepts: https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning

Did you have a look at : https://www.mssqltips.com/sqlservertip/3494/azure-sql-database--table-partitioning/ ?

I haven't tested this on a Azure...

Time to learn Powershell !

To keep it simple, just add an extra variable (e.g. $ResultFileName )

#Create the report and save it to...

Today I received 2 new false notifications:

A user you are following, "Sue_H", has posted new content

A user you are following, "SQLDCH", has posted new content:

did you check the ( FREE ) Powershell solution dbatools provides which can copy the logins ? ( and a bunch of other SQLServer relatied management features ! )

I dislike linked servers (because of its unstable behaviour by nature )

Why aren't you considering a (scheduled or evan ad-hoc launch) SSIS  package ?

As far as I know, I haven't subscribed to the topics ( the mail states I follow the users. topics emails state "topic" )

Today I received 2 mails...

apparently it is getting worse 😉