SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Encryption Rss

   Items 1 to 20 of 133    Older >>
 

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases. For tempdb database, you need to restart the SQL Server Instance to complete the process. Note: It is advisable to take transaction log backup before this activity is performed.  Read more...
Rating: |  Discuss |   Briefcase | 134 reads

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 806 reads

Always Encrypted Permissions

By Steve Jones 2017/09/28 | Category: always encrypted
Rating: (not yet rated) |  Discuss |   Briefcase | 773 reads

Using Database Master Keys in SQL Server

Learn the basics of Database Master Keys and how you can use them in SQL Server.  Read more...
By Steve Jones 2017/08/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 1,169 reads

Decryption Woes

By Steve Jones 2017/08/01 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 913 reads

Protecting Encrypted Backups

By Steve Jones 2017/06/23 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 778 reads

Backup Encryption Options

By Steve Jones 2017/06/05 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 903 reads

Transparent Database Encryption on all User Databases

How to apply Transparent Database encryption?  Read more...
By PremKumar Raju 2017/05/25 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 377 reads

Encrypting SQL Server: Dynamic Data Masking

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.  Read more...
By Additional Articles 2017/05/16 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 3,282 reads

SQL Server Encryption: Always Encrypted

Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.  Read more...
By Additional Articles 2017/04/10 | Source: SimpleTalk | Category: always encrypted
Rating: (not yet rated)  Rate this |   Briefcase | 4,116 reads

Database TDE

Rating: (not yet rated) |  Discuss |   Briefcase | 880 reads

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.  Read more...
By Additional Articles 2017/02/27 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 4,965 reads

TDE Decryption Timer Script

Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.  Read more...
By Edward Pochinski 2017/01/24 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 330 reads

The data encryptors

By Steve Jones 2016/12/22 | Category: always encrypted
Rating: (not yet rated) |  Discuss |   Briefcase | 861 reads

HASHBYTES limits

By Steve Jones 2016/12/21 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 881 reads

Always Encrypted Certificates

By Steve Jones 2016/12/13 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 876 reads

Encryption Keys Matter

Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.  Read more...
By Steve Jones 2016/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 65 reads

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  Read more...
By Additional Articles 2016/07/18 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,401 reads
   Items 1 to 20 of 133    Older >>
 
Tags
security (49)    
editorial (19)    
transparent data encryption (tde) (18)    
t-sql (10)    
blogs (9)    
friday poll (9)    
administration (6)    
always encrypted (6)    
certificates (6)    
sql server 2005 (6)    
database master key (dmk) (4)    
editorial - ipod (4)    
editorial - wmv (4)    
sql server 2008 (4)    
sql server 2016 (4)    
asymmetric keys (3)    
backup and restore (3)    
editorial - mp3 (3)    
views (3)    
backup (2)    
disaster recovery (dr) (2)    
dynamic data masking (2)    
encryptbypassphrase() (2)    
hashbytes() (2)    
hashing (2)    
sql server express (2)    
ssl (2)    
stored procedures (2)    
symmetric keys (2)    
tde (2)    
authenticators (1)    
availability group (ag) (1)    
c# (1)    
cryptography (1)    
database design (1)    
database encryption (1)    
database weekly (1)    
deadlock graph (1)    
decryption (1)    
disk encryption (1)    
dmk (1)    
dmv's (1)    
ekm (1)    
endpoints (1)    
hsm (1)    
md5 (1)    
md5 function password encrypt sql 2005 (1)    
metadata (1)    
object_id (1)    
passwords (1)    
performance (1)    
row-level security (rls) (1)    
secure programming (1)    
service broker (1)    
smk (1)    
sql server 2000 (1)    
symmetric key (1)    
with encryption (1)