We're building a new database server to replace an old system. The rules say that the database must be encrypted and we've done so, historically, with a product that encrpyted the whole database.

Column-level (or “cell-level”) encryption was introduced with SQL Server 2005. We can encrypt individual columns that are sensitive in nature. The trade-off here is that we need to change our database ...