What are the data types of

od.amended_quantity, od.quantity, od.price, p.content?

one of them I guess is going to be a string type and not numeric type resulting in an operand conversion issue.

you will...

Column order is 100000000000% important in indexing.

Those two indexes you have mentioned would not be considered as duplicates due to the column order.

https://www.sqlskills.com/blogs/kimberly/how-can-you-tell-if-an-index-is-really-a-duplicate/

If you had

Col1,Col2,Col3 include Col5

And another

Col1,Col2,Col3,Col5

Then you could...

Two options.

Upgrade to SQL2017 or SQL2019

Create your own SSL certificate trusted by a CA and put that in place instead.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15

You don’t need to enforce encrypted connections but you need to...

Side by side migrations all the way.  Never do in place upgrade, if they fail then your rollback is hours not minutes.

As for upgrade paths, due to support lifecycles you...

You’re into writing your own queries really.

So it’s starting with a good data dictionary.  What tables have what columns and what data in those columns needs to be masked.

Then your...

They will run queries against the instance every X s/m/h as per the configuration.

However I wouldn’t be writing my own monitoring solution, if I was financially constrained then I would...

No, if you create a new file group you must put objects on the file group for it to be used.

EG

CREATE TABLE MyNewTable(

….

) ON [MyNewFileGroup]

The proportional fill algorithm requires the...

It looks like your missing a closing bracket on each line.

VALUES

(NULL, NULL, NULL, NULL, CAST(N'2021-12-27T09:41:19.000' AS DateTime),

So your closing the cast to date time, but not the row )

VALUES

(NULL, NULL,...

What else can you do on the one that backs up rather than the one which doesn’t?

My guess is the SQL IaaS extension is registered in full on the one...

If you don’t want to code it yourself you’re going to have to use a 3rd party task like cozyroc (https://www.cozyroc.com/ssis/sftp-task) but be prepared to pay a pretty penny.

Otherwise you...

Random encryption is just that, each value is encrypted using a random value.

The optimiser would have to “try” to decrypt the values at run time row by row, resulting in...

You need to put yourself a clustered index on the table.  Shrinking heaps is very trick why put yourself through the pain.

Alternatively pull out all the data left, truncate, repopulate.

If...

So you will want to use modulus %

so months/12 to get the years then months%12 to get the remainder then you can format it how you like.

What command did you run to shrink, please post the exact TSQL.

Also note the largest index in the database and double it.  Never shrink so that free space is less...

Please post error messages for what is not working.

More than likely you have not given permissions to the service account to the location needed.