If a creator of a Shield Guardian gives the control amulet to the Shield Guardian, what would happen?

There was an idea pitched at one of my play sessions earlier this week that has been gnawing at me. Suppose a wizard creates a shield guardian and gives the golem the telepathic command to take off the amulet and live a life of its own; what would happen?

Would the Shield Guardian become a sort of pseudo-warforged, following the original command? Would it just be stuck, standing there?

What would happen if a wizard calls a familiar in the Ethereal Plane and then returns to the Material Plane?

What would happen if a wizard summons a familiar (using find familiar) in the Border Ethereal, and then the wizard returns to the Material Plane (interrupting or ending the magical effects of etherealness)?

Would the familiar disappear due to the distance from the caster, since they are now on different planes?
Does the Ethereal Plane overlap with the Material Plane (Border Ethereal) such that distances are preserved and the familiar remains in the Border Ethereal while the caster is in the Material Plane?

The Ethereal Plane
Its shores, called the Border Ethereal, overlap the Material Plane and the Inner Planes, so that every location on those planes has a corresponding location on the Ethereal Plane. (PHB, p. 301)

Does this make possible the ability of having one’s familiar become an ethereal traveler?

Do multiple hits of Repelling Blast happen simultaneously or in succession?

A 5th level Warlock casts Repelling Blast, firing 2 beams at the same target. The first one hits, pushing the target back 10 feet. Does the second attack roll come before or after the target is pushed away?

Two scenarios (both came up in play):

  1. The opponent is a ghost who is 5 feet away from a wall. The first blast pushes the ghost through the wall. If the second attack is before the repulsion, both beams hit. If it is after, the wall would block the second beam.
  2. The opponent is an ordinary creature that is 5 feet away from the caster. The first roll was taken with disadvantage. If the second attack is before the repulsion, then that attack is also with disadvantage. If it is after, then the caster is no longer within 5 feet of an enemy, so the second attack is not at disadvantage.

This question is inspired by this other question.

What would happen if you opened a Bag of Holding underwater?

I’m in a naval campaign where some of the game could take place underwater, and I could reasonably acquire a Bag of Holding soon, so it would be nice to know before I try to grab an item underwater and jettison all of my gear into the Astral plane. Would it fill with water until the bag was filled to capacity and scatter all the contents inside as well?

Also assuming you didn’t break the Bag of Holding by overfilling it to capacity, would putting water inside it get other objects inside wet, potentially ruining them?

If a player who is flying is made to stop when does the falling damage happen? [duplicate]

If a player is flying in DnD and then for some reason is made to stop flying.

For instance a Druid in beast form if an eagle takes enough damage to drop eagle form, or a wizard flying due to an enchantment has that enchantment ended by an enemy or trap.

Are they considered to hit the ground immediately in the instance it happens or do they get an turn to try and do something about it? Is it dependant on how high they are, or where they come in initiative order?

Why does TempDB spill happen even though statistics are correct?

I read a great article published by Brent Ozar and came up with some questions related to memory grant. I am unable to address my questions in the comment section of his article, so I thought to get any help from here.

  1. Question: How much data is spilled into disk? 400 MB or 60 MB(7643KB*8)?

in the article he states:

And no matter how many times I update statistics, I’ll still get a ~400MB spill to disk.

I am kinda confused here(

enter image description here enter image description here

  1. Question: If everything is okay with estimates, stats are up to date, box has sufficient memory, and no queries were running at that time, then why does spill to disk happen?

look at the estimated number of rows versus the actual number of rows. They’re identical. The stats are fine.

I’m not using a small server, either: my virtual machine has 32GB RAM, and I’ve allocated 28GB of that to SQL Server. There are no other queries running at the same time – it’s just one lonely query, spilling to disk…

enter image description here

Is there any encryption mechanism where i can ensure that the decryption can only happen within my data center?

I have a requirement where i need to store confidential data in an encrypted format in the url, i understand POST with body is better approach but it is not an option for me. I am thinking of using a pass phrase based AES 128 bit encryption for encrypting the query string parameter. The concern i have is that the url could get cached in different parts of the internet and if the pass phrase is exposed somehow then it could be used to decrypt these values.