Question : I feel confident I understand what’s involved at the db level: If dropping, I’d need to create users […]
Using multiple Active Directory accounts to connect to SQL Server
Question : I have web applications (Classic ASP and .NET) that connect to SQL Server using SQL authentication. Each one […]
SQL Server : Is it necessary to disable SA user for security issues?
Question : We have a website that will published in national grade with millions of users with Microsoft Sql Server […]
SQL Server 2012 restrict CmdExec to sysadmin server role
Question : I’m trying to restricting CmdExec rights to sysadmin server role in SQL Server 2012. I’ve googled but just […]
Is the data exchange on connection from client to server sent as plain text over the wire?
Question : I have a new SQL Server 2019 on-premises instance. Assuming the client is the SQL Server Management Studio […]
How to implement an effective ACL/auth in a relational db?
Question : We are looking at implementing an ACL that fulfills the following requirements: Most users have access to an […]