Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.

Comparing Space Usage for Different Compression Types

by Michael Salzmann

SQLServerCentral.com

Compression

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.

Getting Started with Azure SQL Data Warehouse - Part 2

by Additional Articles

Database Journal

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.

Continuous Delivery and the Development DBA

by Pedro Lopez

SQLServerCentral.com

continuous delivery

How to do database development with trunk based development and Continuous Delivery

Launching Products

by Steve Jones

SQLServerCentral.com

Editorial

The release of new software is always exciting.

Follow-up #1 on leading wildcard seeks

by Additional Articles

SQLPerformance.com

Wildcard

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

Core Database Source Control Concepts

by Additional Articles

SimpleTalk

source control

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.