A parallel upgrade is the safest approach however I have never had a problem with upgrade in place either. I don't have SSAS though.

Are you using the Package Deployment Model or the Project Deployment Model?

Mirroring, introduced in SQL Server 2005, requires a minimum of 2 servers, Windows Clusters or not, plus a witness for automatic failover. Always On Availability Groups, introduce in SQL Server 2012,...

SQL Server has a deprecated behavior in views and subqueries in which an order by clause is illegal unless with a top () or an offset clause. In the past...

Extended properties are part of the definition of the objects they are associated with.

The account SQL server is running under needs to be a login on the server mapped to a user with adequate permissions in PostgreSQL or you must create the linked...

Care to share for other blondes out there?

Try setting up a SPN for the account under which SQL Server is running for the server you are connecting to that matches the server in your connection string. This may...

Please post table DDL and inserts with sample data.

Please post consumable sample data, create table statement with insert statements. Also check out the new String_Split() function in SQL 2016.

Can you describe the process in more detail?

INSERT Table2(Col1, ...)
SELECT
   Col1, ...
FROM Table1 t1
LEFT OUTER JOIN Table2 t2
ON
   t1.col1=t2.col1
AND    t1.col2=t2.col2
AND    t1.col3=t2.col3
AND    t1.col4=t2.col4

Auto incorrect