Learn tips for administering SQL Server securely.A Windows user has a security context, which means that something controls access to objects. In the case of an older networking schema such as LAN ...

Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to something on that type of network, they either ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.

In that case, SQL Server will not maintain the password but instead trusts Windows for the security. In a Windows network, you only need one login to gain access to the server and then you control ...