Is this consistently happening multiple times, or just this time?

Shrinking a log or database only removes pages that are unused by the system.

If you are taking log backups, check the sizes.  That's the level of activity that...

Use roles. In this case, I can't test, but I think you can track all activity by public. Every user is in public.

Maybe Biml can help - http://www.sqlservercentral.com/stairway/100550/

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-error-and-message-reference
Says destination not  available

Didn't mean to imply that containers don't support cloning, nor do I think I did. Containers supplied from MS are separate items, and each has separate data needs to be...

Used to use this more in the past, but rarely use it now. Had to check something for someone recently, so decided this was good knowledge.

Apologies for the explanation. That is updated.
For the  result set answer, expanded to note the answer is a multi-line result set.

Technically, @@options returns an integer. You can...

Thanks. I find XE cumbersome, but I am trying to fix that, or at least learn how to work with it better.

XE is a tracing system that can capture all activity occurring in SQL Server. This replaces SQL Trace/Profiler, which is a more heavyweight way of gathering activity. SQL Trace also...