Encrypt a column using Stored procedures So first of all I created a Symmetric key called MY_KEY in my database. If you look under security you will find the place to create the this key.

Microsoft on Monday revealed that hospitals and other IT shops should expect the next generation of its database to be available on June 1. Dubbed SQL Server 2016, the forthcoming iteration brings a ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

1/ In SQL server 2008, there is a new whole database encryption option (TDE). I suspect that using this option will make the backups incompatible with SQL 2005.

At Microsoft TechEd 2004 in San Diego, Microsoft provided further details on its upcoming database release now known as SQL Server 2005 (formerly code-named “Yukon”). The software will natively ...