Melville Thomson's Blog

Data, SQL and Windows Technologies

Browse by Tags

Related Posts
  • Blog Post: SQL Server Security issues reduced

    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?...
  • Blog Post: SQL Server 2005 Encryption

    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...
  • Blog Post: Configuring SQL Server 2005 Logins

    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...