Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Transparent Data Encryption (TDE) Rss

   Items 1 to 20 of 41    Older >>
 

Performance Surprises and Assumptions : SET NOCOUNT ON

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance  Read more...
Rating:  Rate this |   Briefcase | 4,909 reads

Enabling TDE on Databases in an AlwaysOn Scenario

Enabling Transparent Data Encryption on Databases in Always On Scenario  Read more...
By Sanjiv Doshetty 2016/02/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 2,062 reads

SMKs, DMKs, Certificates for TDE and Encrypted Backups

This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.  Read more...
By Perry Whittle 2015/12/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,922 reads

Azure SQL Database - Transparent Data Encryption

Transparent Data Encryption offers the ability to encrypt content of the database, its transaction logs, as well as backups while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Marcin Policht reviews the feature.  Read more...
By Additional Articles 2015/11/24 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,883 reads

Stairway to SQL Server Security Level 9: Transparent Data Encryption

Even an otherwise well-secured database is susceptible to attack if an attacker is able to get access to the disk files that comprise the database. Cell-level encryption can protect some of the data, but for complete protection against this kind of attack it is necessary to encrypt the files and not just the data. That is exactly what Transparent Data Encryption (TDE) does, and in this stairway level you'll learn what TDE does, how it works, and how to make use of it to protect your database files.  Read more...
By Don Kiely 2015/06/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,451 reads

TDE and In-Memory OLTP

By pramod singla 2015/02/19 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,671 reads

A Fundamental Security Mistake

Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.  Read more...
By Steve Jones 2014/11/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 407 reads

Transparent Data Encryption (TDE) in SQL Server

There are several ways to implement encryption in SQL Server; Arshad Ali focuses on Transparent Data Encryption (TDE), which was introduced in SQL Server 2008 and is available in later releases.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,640 reads

Backup Your Certificate for TDE

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...  Read more...
By Steve Jones 2013/09/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,185 reads

TDE Setup

By Steve Jones 2013/07/18 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 2,033 reads

Does TDE really work on MDF files?

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data: -- create a...  Read more...
By Steve Jones 2013/04/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,225 reads

Data Insecurity: A Perspective on Data Encryption

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.  Read more...
By Ron Johnson 2013/03/07 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 1,610 reads

Enable Transparent Data Encryption

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do,...  Read more...
By Steve Jones 2012/08/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,349 reads

Database Corruption, Transparent Data Encryption, and Trace Flag 5004

This one comes straight from the email bag.  A friend recently had a problem, they were placing TDE on a...  Read more...
By 2012/08/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,842 reads

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases  Read more...
Rating: |  Discuss |   Briefcase | 5,958 reads

TDE Setup and Administration Scripts

A comprehensive set of scripts to setup and operate TDE for a SQL Server.  Read more...
By Sean Elliott 2012/08/10 (first published: 2011/03/08) | Source: SQLServerCentral.com | Category: transparent data encryption (tde)
Rating: |  Discuss |   Briefcase | 37,267 reads

Removing TDE

Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.  Read more...
By Steve Perry 2011/11/03 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,158 reads

TDE and Backups

Rating: (not yet rated) |  Discuss |   Briefcase | 2,056 reads

TDE and Filegroups

Rating: (not yet rated) |  Discuss |   Briefcase | 2,093 reads
   Items 1 to 20 of 41    Older >>
 
Tags
encryption (16)    
security (13)    
sql server 2008 (7)    
blogs (4)    
administration (3)    
editorial (2)    
alwayson (1)    
asymmetric keys (1)    
azure (1)    
backup and restore (1)    
certificates (1)    
disaster recovery (dr) (1)    
dmk (1)    
editorial - ipod (1)    
editorial - wmv (1)    
ekm (1)    
filestream (1)    
hsm (1)    
in-memory oltp (1)    
mirroring (1)    
performance testing (1)    
replication (1)    
smk (1)    
sql server 2000 (1)    
sql server 2005 (1)    
sql server 2014 (1)    
stairway series (1)    
symmetric keys (1)