As much as anything this can be a (albeit odd) parameter sniffing issue. Your compiled plan on the old primary is likely happy and full of good things for your...

Here you are telling the AG to failover if it's the primary. Failover should be initiated from the...

That is the precision level for datetime. If you want a lower level of precision use datetime2.

DATETIME2(0) would give you precision to the second.

Try downloading again. I got SQLScripts_1.1.0.278.exe when downloaded.

I would use CHARINDEX to look for the start and end of the section you need, and then use the substring function around that.

DECLARE @string VARCHAR(256) = 'CN=John Smith,OU=Production,OU=IT,OU=Santa Fe,OU=Region...

If you are talking about in a FCI, then no. If the log size has not grown then the same file will be used on failover.

Read https://www.sqlskills.com/blogs/jonathan/does-the-tempdb-log-file-get-zero-initialized-at-startup/...

Correct, no quorum, no cluster, no AG.

It's all about carefully selecting what nodes do, and do not have votes within your cluster to ensure that you maintain the maximum uptime...

That's the way that WSFC is designed and functions. There must always be a quorum of votes.

Ultimately, should you desire, you could configure the node weight of each node...

The worst case isn't whether a node is down or not, that's not what causes split brain scenarios. Rather the issue is when both nodes are up, and able to...

Well if you don't have quorum then your AG will be down. It requires quorum to function (otherwise how would it know which was the primary). In your situation you...

Could be the return code that the application is sending. Look to see what's being returned, and what the step is handling as successful step output.

You are going to want to join sys.database_principals to sys.server_principals and sys.database_permissions and sys.database_roles in order to gather that information in every database you have.

It's pretty trivial to write...

Service Broker would allow for this, however you would not be able to use temp tables.

And none of this will work when the table schema changes and the new column gets a higher ordinal position.

I don't know why you would manually register the SPN. Why not grant the ability to SELF for Read/Write servicePrincipalName to the service account in AD?