SQL Server Encryption Archives - Page 4 of 4 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script

April 28, 2009

SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hackers’ attacks. Hackers might be able to penetrate the database or tables, but owing to encryption they would not be able to understand the data or make use of it. Nowadays, it has become imperative to encrypt crucial security-related data while storing in the database as well as during transmission across a network between the client and the server.

SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions

July 1, 2007

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Server Encryption, SQL Stored Procedure

This article is written to answer following two questions I have received in last one week. Questions 1) How to hide code of my Stored Procedure that no one can see it? 2) Our DBA has left the job and one of the function which retrieves important information is encrypted,…