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

Content with tag Encryption Rss

   Items 1 to 20 of 139    Older >>

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.  Read more...
By Additional Articles 2018/08/14 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,750 reads

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?  Read more...
By Jason Ash 2018/06/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 745 reads

Data Encryption Using Always Encrypted in SQL Server

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.  Read more...
By Additional Articles 2018/03/16 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,493 reads

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding  Read more...
By Evgeny Garaev 2018/03/08 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 575 reads

How to Enable Transparent Data Encryption

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk.  Read more...
Rating:  Rate this |   Briefcase | 2,485 reads

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 | 200 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 | 865 reads

Always Encrypted Permissions

By Steve Jones 2017/09/28 | Category: always encrypted
Rating: (not yet rated) |  Discuss |   Briefcase | 792 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,339 reads

Decryption Woes

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

Protecting Encrypted Backups

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

Backup Encryption Options

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

Transparent Database Encryption on all User Databases

How to apply Transparent Database encryption? 
By PremKumar Raju 2017/05/25 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 420 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,547 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,375 reads

Database TDE

Rating: (not yet rated) |  Discuss |   Briefcase | 888 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 | 5,218 reads
   Items 1 to 20 of 139    Older >>
security (51)    
transparent data encryption (tde) (20)    
editorial (19)    
t-sql (10)    
blogs (9)    
friday poll (9)    
administration (7)    
always encrypted (7)    
certificates (7)    
sql server 2005 (6)    
database master key (dmk) (4)    
editorial - ipod (4)    
editorial - wmv (4)    
sql server 2008 (4)    
sql server 2016 (4)    
tde (4)    
asymmetric keys (3)    
backup and restore (3)    
editorial - mp3 (3)    
views (3)    
availability group (ag) (2)    
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)    
authenticators (1)    
automatic database seeding (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)