This sounds like a homework / interview question.

What answers did you give?

The only other thing would be to see if the app has any web services/api’s you could programmatically hit and pass in the data that way

So I take it one of the instances is listening in port 1433 so when you use SERVERNAME it connects.

The other will be on another either static or dynamic port...

Ok so the encryption piece is written in the app then, so unless you can reverse engineer the application then your out of luck and will need to write your...

Is it an in house written app or 3rd party?

Can you ask the developers how the app encrypts the data?

Does it use always encrypted by any chance?

Anything returned from sys.column_encryption_keys...

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

What is the problem your trying to solve?

If you want data to be different in the table you need to either wait for 1 person to finish then delete the...

Firstly test connectivity, use powershell TNC to check the port is open

“TNC IP.To.Other.Server -port 1433”

Then I would look at DBATools and their ready made Invoke-DbaQuery, ConvertTo-DbaDataTable, Write-DbaDataTable functions to do...

Downgrade to visual studio 2019.

The marketplace projects don’t work with VS2022 yet.

Verify all the permissions for the service account have been set correctly as per the below article.

Had one exactly the same where someone changed the service account via services.msc instead...

Based on that sample data very easy although I am going to guess not all your data is like that and you will have various different niches which need to...

Grant revoke deny timestamps are not stored anywhere.

If you need that level of information you will need to look at DDL triggers or SQL Audit. But that will only give...

Statement at the moment is that product group are looking into the vulnerability.

The most up to date information can be found at

https://msrc-blog.microsoft.com/2021/12/11/microsofts-response-to-cve-2021-44228-apache-log4j2

Please note the vulnerability was found in v2 to...

DATENAME

https://docs.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql?view=sql-server-ver15

SELECT DATENAME(mm,’2021-12-12’)

Unfortunately if something is holding the file open there is nothing that can really be done except terminating that process, so you would need to kill the nxlog reader in...