Vishnu Gupthan

Stairway Level 2 : Restore a Backup of a TDE Database to Another Server

In Level 1 of this Stairway, we discussed how to configure TDE in a user database using a Database Master Key and Certificate. In this level, we explain the steps for backing up and securing this certificate, as well as how to restore the database on another server instance. Backup the Certificate and Private Key […]

5 (2)

2020-05-20

1,066 reads

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

Introduction Transparent Data Encryption (TDE) is one of the key security features available in SQL Server from SQL Server 2008 onwards. Using this feature, the ‘data at rest’ in the physical files for the database, are protected from unauthorized access if the files are copied, or the physical media is stolen. TDE is available with […]

5 (3)

2020-04-29

1,751 reads

Blogs

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Power BI Monthly Digest – May 2020

By

This month we will likely have two releases of the Power BI Desktop. In...

Three big reasons T-SQL still beats the GUI – a MinionWare snippet

By

We like code better than mouse clicks for three basic reasons: T-SQL lets you...

Read the latest Blogs

Forums

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Inlining Scalar UDFs

By Greg Larsen

Comments posted to this topic are about the item Inlining Scalar UDFs

Question About Microsoft Data Migration and the MAP

By imani_technology

Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers