SQL Server 2016 Just Runs Faster - Encryption

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

You work in a shop that puts business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual for companies that use the SQL Server layer to perform

Happy New Year 2016

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.

Database Master Keys

Granular or Cell Level Encryption in SQL Server

Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).

Using Encrypted Backups in SQL Server 2014

This article details encrypted backups and how they are implemented in SQL Server 2014.

Administering Database Master Keys in SQL Server

A short piece that gives you the basics of how to administer the database master keys that form the basis for encryption inside of your databases.

Double Keys

Decryption Keys