Yes, you can join it to sys.dm_tran_session_transactions on transaction_id and from there you have lots of option for joining sys.dm_tran_session_transactions to other DMVs via the session_id column. Once you join...

What typically works best is to apply the same deployments to UAT as you do to Prod. This means that if a deployment to UAT fails, the deployment needs to...

Don't drop the distribution database manually. Use the GUI interface to "Disable publishing and distribution" or use the system stored procedure sp_dropdistributor.

You can run DTA from the command line (bat file). Look in Books Online for Database Engine Tuning Advisor [SQL Server], command prompt

What relevant error messages appear in the error log? Look in the log on both partners.

I suspect that there is too much network latency between China and the US and...

No. Database Engine Tuning Advisor tunes the database engine. SSIS is a different engine.

What error do you get? Can you script out the role and user and display the SQL for it?

Do you mean saved queries? Access doesn't have views.

No issues. That's how I do it.

In order to recover specific files or filegroups that are lost, you first have to"

1. Back up the tail of the log

2. Restore the files or filegroups that are missing...

Since the syntax error due to the comma wasn't one of the choices, I assumed the comma was a typo and answered the question as if it wasn't there. Got...

I'm in ... someone has to come in last. 😀

Having files in the same filegroup on different drives is fine. Yes, if a file is offline, then the whole filegroup is offline. However, only partitions in that filegroup will...

Yes. Good luck.

Doing that is unsupproted and undocumented You could try, but I don't think anyone has done so before. Restore msdb with a different name and insert the missing reacords into...