search

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Bharat Dwarkani shared on Dec 15, 2019
image
youtube.com
bookmarks
share
favorite_border0 visibility1
favorite_border0 visibility1 share 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 shared on Sep 02, 2019
image
mssqltips.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share 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 shared on Sep 02, 2019
image
mssqltips.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share 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 shared on Aug 27, 2019
image
medium.com
bookmarks
share
favorite_border0 visibility18
favorite_border0 visibility18 share bookmarks

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

Bharat Dwarkani shared on Aug 17, 2019
image
w3schools.com
bookmarks
share
favorite_border0 visibility11
favorite_border0 visibility11 share bookmarks
add