Tag Archives: sql server

SQL Backup 7

Posted on April 24, 2012 by way0utwest

What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s SQL Backup Pro, have been able to handle the things most DBAs care about for some time: compression and encryption. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Backup 7

SQL Injection Tools

Posted on April 18, 2012 by way0utwest

I wouldn’t recommend you use any of the tools in this article for attacking anyone, but they could help you to understand the vulnerabilities in your own application. The tools cover a variety of possible ways that injection attacks can … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Creating a User without a Login – Contained Databases

Posted on April 16, 2012 by way0utwest

In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to enable this, and this post will look at one of the advantages of contained databases: users without logins. Contained Users … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Key Storage

Posted on April 13, 2012 by way0utwest

One of the issues with encryption, perhaps the biggest issue, is the management of the keys that protect the encrypted data. I have been an advocate of keeping the backup of the keys far away from the backup of the … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Key Storage