Unable to comment as that would be up to how your VMware guys have setup the infrastructure, how your network admins setup the network and how you are doing business continuity...

If you have a copy of the database you removed compression from somewhere, yes you can query the metadata to find out the compression settings that are in that copy.

Do you know what level of compression you where using before you removed it?  Row or Page?

Where you using the same levels for all indexes and the table...

If the disk can migrate between all the nodes in the cluster and the nodes are all in separate data centers then your OK as you will always achieve quorum.

Backup Restore
Snapshot Replication
ETL/SSIS
Copy Database Wizard
Red-Gate SQL Clone

Main question is are you going to be governed by GDPR, if so you will need to work...

As per your other post on that procedure, use sp_send_dbmail to trigger a mail alert based on a query from that table which satisfies your requirements from the output table.

Yes the same as you would transfer any logins between servers participating in a high available setup, as you need to copy the SID's as the databases are read only...

For the Monday save, yes, all you need to do is look at DATENAME for the weekday and if its Monday, just before you do the drop ##Results, do a...

Licensing for Non-Production Use

SQL Server 2016 Developer Edition provides a fully featured version of SQL Server software—including all of the...

Is it just a simple case of adding a blank string to your export?


SELECT col1, col2, col3,'        ' as white_space FROM table1


How is the...

Not that clued up on Azure as I work on government projects which we cant use the cloud, but does the following link help at all https://docs.microsoft.com/en-us/azure/sql-database/sql-database-copy