There is NO official support for using instance names with the listener.

Will it work with an instance name as part of the connection string, most probably.

Will a patch / new...

Typically you would just connect to the listener not listener\instance.

As you can span different named instances as replicas when you failover, you would break the connection string.

There is also no...

Within the job there is an option to use the 32bit runtime.

If you have installed ACE 32bit driver on the server where SSIS package is running, that’s what you’ll need...

Network firewall blocking the traffic.  Speak to the network admins and ensure the needed ports are open between the subnets and SQL.

The parameters used to cache the plan are stored, but each execution is not.

The cached plan parameters are easily extracted from the plan cache.

If you want every execution parameters you...

It will monitor everything at the database scope if you select the database object including information_schema.

You can verify this by creating the audit for your login and verify the audit...

It just depends what level of support you want from Microsoft.

Yeah 2017 is good for another 5 years in extended support, but it is best endeavours and if it’s a...

As another point to note.

Why SQL2017?  This is soon dropping into extended support (October 2022) after which any product bugs will not be fixed unless absolutely critical.

If it was me...

You need to test everything in the new compatibility level before you attempt to migrate.

The cardinality estimator was changes in 2014 / compat > 120 in a huge way.  Somethings...

You must specify a object name and a principal name when using the object class of database.

eg

Audit Action Type = Select

Object Class = Database

Object Schema = “blank”

Object Name = AdventureWorks

Object...

You would have to dynamically build the SQL for this and execute on a database by database basis.

There is nothing server scoped which will monitor those database actions for you.

You...

Encryption can be done in many places.

Its not quite clear where you are wanting the encryption to be from your original statement.

TDE encrypts the files so no one can go...

The domain trusts have been set up with selective authentication.

You need to work with your domain admins and security teams to ensure you can do what you need to do,...

The backup file is more than likely goosed.

Can you post the message it failed with like operating system error 13 or something , will be in the 2016 error log.

Rule...

You need to use the inbuilt function below wrapping your job step command in the function.

https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-hadr-is-primary-replica-transact-sql?view=sql-server-ver15