Know the answers to the common questions regarding Deep Security Manager (DSM) and native encryption like TDE.
Does DSM support native encryption, such as SQL TDE, for the database?
TDE performs real-time I/O encryption and decryption of the data and log files. It does not provide encryption across communication channels. Basically, TDE only protects the data on the disk itself. Therefore, there is nothing on the DSM side that would be affected.
For more information, refer to this Microsoft article: Transparent Data Encryption (TDE).
What is the recommendation for database security?
The SSL is a security protection already. We can also configure the firewall on SQL server so that only DSM and other necessary computers would be allowed to connect to it.
Check out this Microsoft article for other suggestions: Configure a Windows Firewall for Database Engine Access.