I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

Most SQL Server databases have a number of users viewing and accessing data, which makes security a major concern for the administrator. The smart administrator will take full advantage of SQL ...

You can supply a second parameter for the Database user name, but if you leave it, the server will default to the same name as the SQL Server login, which is usually the best way to go.

Sentrigo discovered a new security hole in SQL Server, but so far Microsoft isn't paying attention. Let me show you why they should ...

Additionally, Microsoft will subject SQL Server 2005 to the federal government’s Common Criteria certification from the National Security Agency.

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots ...

Let’s discuss the Advanced Data Security set of features designed to assess, detect, categorize, and analyze your SQL Server data and threat environment. An important consid­eration if you’re an Azure ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task ...

With end of support looming for Windows Server 2008 and SQL Server 2008, Microsoft has a new option for those users to keep getting security updates: By moving workloads to Azure.