search
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linkmssqltips.com

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.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linkmssqltips.com

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.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Aug 27, 2019
bookmarks

linkmedium.com

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

share
favorite_border0 visibility18
favorite_border0 visibility18 share
bookmarks
profile img

Bharat Dwarkani

Aug 17, 2019
bookmarks

linkw3schools.com

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

share
favorite_border0 visibility9
favorite_border0 visibility9 share
bookmarks
add