One question I have been asked is about SQL Server 2005 Logins . Logins are the Server principles which give user’s access to SQL Server. We can create Logins using the SQL Server Management Studio (SSMS) graphically or use the CREATE LOGIN statement. The syntax for a windows login CREATE LOGIN [Domain...

Steve asked me about encryption in SQL Server 2005. I have found a few areas of information that are useful. In BOL there is an article about the Encryption Hierarchy this explains quite a lot about how it is organised. I quite like it because it has a diagram which is easy to understand. SQL Server...

In Dan's Blog he talks about the Sans Top 20 Security Vulnerabilities . The main point being Microsoft SQL Server not making the top 20 but other database systems did. I looked back at previous years and we had our own section of vulnerabilities. I am wondering if that was because we were more open?...