In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.
Question: How I Know If I am DBOWNER or Not in SQL Server?
I like to say that I am SQL Server Performance Tuning expert but often during the conversation, I end up discussing security as well. Recently I was asked about my preference for Windows Authentication or System Admin Account (SA) during one of the recent Comprehensive Database Performance Health Check.