Well what if your app or API starts to be used in the US or somewhere which has...

Well if you manage any SQL2014 or below instances and you have enabled T1118, you have essentially set the value to OFF for every database on that instance.

Now that was...

Let the presentation layer handle the formatting, that should only really ever be done in T-SQL as an absolute last resort.

You also mention format dd/mm/yyyy when you actually only have...

Are the right ports open between the machines, use TELNET or PowerShell TNC to check this.

Work with your admins to put in packet traces between source and destination on the...

Well the listener is just essentially just an AD computer account so yeah you can't have a slash in the name as it needs to follow NetBIOS rules.

Not tried it...

No point reinventing the wheel.

Use powershell and dbatools sync-dbaavailabilitygroup

https://docs.dbatools.io/Sync-DbaAvailabilityGroup

First off, wow, running SQL 2005 in 2021, that’s been out of support now for over 10 years, you really really need to get a plan to get that upgraded...

Your into writing an application/powershell/ssis/c#/vb.net stuff to talk to salesforces soap apis and running some soql to csv files then pushing those into your database.

If it was me would be...

Filter sys.dm_exec_sessions where the program_name is like ‘%jobstep%’ and then take the binary value from the program name and pass that to sysjobs.

The binary value is equal to the job_id...

That is right and by design.

NT SERVICE\MSSQLSERVER actually is the AD account you assign to run the service.

So it is saying find the service account used for the service MSSQLSERVER...

And you have run the function as adhoc code on the subscribers and do you get the full result set or only partial.

Thinking maybe filters on the articles so anything...

IIRC you can only import BACPACs to a Managed Instance via SSMS.

You cannot do this via the portal for MI.

So you will need sysadmin / serveradmin etc permissions at the...

Transactional replication only replicates schema changes to the tables / procedures in play.

Functions do not get replicated when they change on the publisher.  As such you need to go and...

The quickest and easiest method is always going to be BACKUP and RESTORE.

Just note that if you have created any logins on the 2012 machine you will need something like...

I would build in a sp_send_dbmail part to the procedure which does the updates and emails out a result set based on a query.

EXEC msdb.dbo.sp_send_dbmail  
...