My track on moving anything from <2014 to >=2014 is to leave it in it's old compat mode for a week or so, let it build up the query store. ...

There have been changes to the CE in each version from 2014 onwards, not much mind but each compat level does have its own changes.

Below from Glenn may be of...

A CTE is essentially just a materialised view of the data set, so it points to the actual underlying objects used.

A CTE is not a temp table by any means.

Might...

You need to put it in a solution and project.

Access 2007 is not free, you still need to license it.  You can download it for free, but you need a...

In VS you need to go into the project/package properties and in the debugging option there is a 64bit runtime, change that to false

As a complete side note, why office...

As with all things licensing, you need to speak to your reseller or Microsoft, never take public word as fact

With that bit out the way how I read the licensing...

What the rational behind wanting the collations in sync?

The system databases are out of scope for the availability group so have no issues being different collations on different servers within...

As with anything licencing related, you are best speaking to your reseller and/or Microsoft directly.  Do not take any public advise as truth.

Now as Enterprise edition since SQL 2012 can...

Only thing to add is to read up on scaled out deployments ensuring you don't need things like load balancing etc.

You will also need to reduce SQL's MAX RAM allowance...

I get 27 elements of data from that particular snippet Mike.

Based on that log snippet, I believe the below should work

CREATE TABLE AWSImport
(COL1 NVARCHAR(MAX),
COL2 NVARCHAR(MAX),
COL3 NVARCHAR(MAX),
COL4 NVARCHAR(MAX),
COL5...

Spinning up another server for SSRS would require additional SQL licenses.  But if your covered until the unlimited virtualisation rights then that shouldn't be a problem, if not it can...

Then how is SSIS encrypting in transit?  Are your connections between the servers using encrypted sessions?

What about access direct to the database (not the cube) how are you protecting that...

I would slipstream the install of SP1 into the RTM media and do it in one go, saves failing over multiple times.

https://www.sqlservergeeks.com/slipstreaming-sql-server/ this is for 2008 but again concepts the...

Yes you can disable it later.  But what are you actually protecting against with trying to implement TDE?

TDE only protects your data at rest, so your only protecting against people...

TDE is only at the SQL Engine level, so you can only encrypt the actual databases at rest.

Depending how you have implemented SSIS you could enable TDE at the SSISCatalog,...