From the reference document: "The default group is alterable but it cannot be moved out of the default pool."

Steve,

You ask if a copy of the database encryption key is needed to restore a backup and then you answer that a copy of the server certificate used to...

Yes, we have no bananas today!

Question: ..., is the FILESTREAM data encrypted?

???Correct??? answer: Yes

Explanation: Filestream data is not encrypted when you enable TDE.

From Ref: FILESTREAM data is not encrypted even...

This is an old school answer, but consider leaving the ROOT('XYZ') out and starting with a Tag 1 that gives exactly one result. Here I have used a tally table...

I make a little more than the salary in your example, but I hit the cap for IT in our organization five years ago. I haven't seen any raises in...

Is this a joke??? I am a little bit socially challenged and I don't always correctly identify humor.

I am definitely in the "none of the above" camp.

There is a syntactical ambiguity in the question posed. Should the question be interpreted as "Exactly how many rows will...

Yeesh! Easy enough to test the code.