SQL Server Encryption keeps stolen data unreadable. Learn the three level encryption hierarchy, then follow a symmetric key encryption tutorial with the script.
Giving an Application Account Only What It Needs
Apply least privilege SQL Server access with separate runtime and deployment roles, narrow permissions, and tests of allowed and denied actions.
SQL SERVER – Check if Current Login is Part of Server Role Member
Clients sometimes forget to give me admin rights. IS_SRVROLEMEMBER(‘sysadmin’) checks if the current login is a Server Role Member: 1 means yes, 0 means no.
SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
A reader asked how to disable Windows Authentication in SQL Server. The short answer: it can not be disabled, and it is the most secure way to log in.






