Securing your database from Cyber Attack is most important. Database Security involves a different type of mechanisms to protect the database against Intentional or accidental threats.
Microsoft SQL Server provides various security models including integration with Windows Authentication to provide robust security platform for managing your organization's information. Security can be managed across all database objects including tables, views, stored procedures and at a very granular level. Database encryption is now available as well to secure SQL Server database at rest.
Please see the attached document to read more about Transparent Data Encryption, Backup Encryption, SSL Encryption, Best practices to secure your SQL server and more.
Authored By - Narendra Kumar Srivastava
TCS Cyber Security Practice