MS-SQL Server - Reason DB

Reason DB

The overall reason to have a database is comfort.

Next thing to use is Azure for online users.

Read Documents online to understand Factors.

Slab based calculation...

https://social.msdn.microsoft.com/Forums/en-US/6ee133e5-19f7-481c-8677-1d85b6a48982/slab-calculation-in-sql?forum=transactsql

Database Maintenance to run Fornightly for CheckDB /Consistency

Patching is convenient even more.

Eating up Space / Virtual Memory

https://learn.microsoft.com/en-us/sharepoint/technical-reference/drives-used-for-sql-databases-are-running-out-of-free-space

Over and Above:- To Bring a Freak it's practice.

Initially, we can start from Backup and Restore, Azure Basics, Different Type of Joins, Managed Services, Basics of HA, All Basic commands, Performance Monitoring. 

Best Regards

T. Amit Vaid S.

"It has been more than twenty years of experience in IT."