Bharat Dwarkani Sep 02, 2019

bookmarks

Transparent Data Encryption (TDE) performs real-time I/O encryption and decryption of the data and log files, thereby, protecting data at rest. You can use TDE with Availability Groups to provide security and high availability to your databases.

Bharat Dwarkani Sep 02, 2019

bookmarks

An important option to be considered during restricting unauthorized access to data is to encrypt data so that even if somebody was able to reach to data it is not discernable by a simple query. Since critical information like credit card numbers are stored in column or two, it does not make sense to encrypt the complete database or database files.

Bharat Dwarkani Aug 27, 2019

bookmarks

Some times SQL DB_log.ldf takes up more server space in GBs to shrink and reduce the size of the log file to less than 15 MB from GB execute the below-mentioned script

Bharat Dwarkani Aug 17, 2019

bookmarks

SQL is a standard language for storing, manipulating and retrieving data in databases.