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

Recently, my good friend and co-worker Aaron Bertrand and I were producing a video for the upcoming PASS Summit 2015 event. (Learn more about the international SQL ...

I was looking a Red-Gate's SQL Backup program and was rather interested in the encryption options that the PRO version offered. It claims up to 256 bit encryption, but I was wondering how "secure" ...

DbEncrypt allows you to apply column-level encryption in your SQL Server database and assign view permissions to different users. Whether for obscuring credit card numbers, social security numbers, ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...

Ingrian Networks’ DataSecure network appliance provides centralized encryption for databases and applications, allowing DBAs to control who can view specific columns of private or sensitive data based ...