Thanks for this interesting question, Henrico. Tempdb has default value for ENCRYPTION set to OFF and this setting cannot be modified.
What the documentation doesn't say is what happens...

+1
According to MSDN, AUTO is an option for value of a featured syntax elements... 😉
Thanks Steve for this question.

Interesting question, thanks Steve, to exercise logical reasoning...😉
That a table has INSTEAD OF Trigger can be determined using OBJECTPROPERTY function with Property name 'HasInsteadOfTrigger',
e.g. in the example...

Thanks Steve for this question, yes I had a "Fun with Time", but it cost me just a little time.🙂


DECLARE @t TIME = GETDATE();
SELECT DATEDIFF(MINUTE, 0,...

Thanks Henrico for an interesting question about undocumented DBCC commands.
Clear explanation I found in this blog from Paul White. Interesting is also this Paul Randal's blog.😉

Thanks for this question. I learned something new. I appreciate the Microsoft Azure documentation. 😉

Tough and interesting question, but well specified and after some time, I happily found a good explanation
on MSDN in the...

Thanks for this funny question. An interesting trip into the history of Presidents of the United States. And I had have to brush up the POWER() math function...🙂

Description of the argument <mixed_page_allocation_option> ::= in the MSDN ALTER DATABASE is unhappily worded.
A clear explanation is in the MSDN tempdb Database, paragraph Database Options.

+1
Yes,...

Thanks for this question. It's another compelling reason why to install MS SQL 2016.😉
AES_NI support in SQL Server 2016 Glenn Berry describes in this article with other interesting...