I appreciate you looking into it. I was aware of the master key's role in terms of encrypting database-resident objects like credentials. Does the master key play a role in...

For those who find this article and are confused since your query does not use a hint, the warning is also seen every time you query the DMV sys.dm_db_column_store_row_group_physical_stats because...

Good to know. Thanks for posting.

I could not agree more. People get caught up in what functionality a tool offers but it’s the nonfunctional aspects that can make or break the overall value it can...

Hi T, have you looked at the pattern offered in the Microsoft docs on logon triggers? https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-2017

Specifically pay attention to the EXECUTE AS clause. I think approaching your trigger...

Fair enough, Lynn. I edited my post to say "and preserve column order." I knew that was possible but it did not occur to me to offer that up. 

July 27, 2018 at 11:32 pm

#1999343

@Nigel, I noticed that too but they probably arrived here through a search engine which means others will too...which means I am compelled to provide some additional info.

Steve Thompson-454462 - Wednesday, May 9, 2018 8:18 AM+x

Orlando Colamatteo - Tuesday, May 8, 2018 9:10 PM

May 9, 2018 at 10:15 pm

#1989985

Here’s a quote for you, Sergiy:

Amazon delivers a new feature to production every 10.6 seconds with 1000 Scrum teams. That's why they have all the money. —Jeff Sutherland

Would you consider...