MS-SQL Server - Structure by Database Diagram

Structure by Database Diagram.

https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/create-a-new-database-diagram-visual-database-tools?view=sql-server-ver16

Underscore while LIKE

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver16

Inner & Adaptive Joins

https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16

Login and Users

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver16

Tail Log Backup

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-ver16

Rotate Column Master Keys

The rotation of a column master key is the process of replacing an existing column master key with a new column master key.

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/rotate-always-encrypted-keys-using-ssms?view=sql-server-ver16

Best Regards

T. Amit Vaid S.