MSSQL Internals
Master Database
Master Database
TODO
MSDB Database
MSDB Database
TODO
Model Database
Model Database
The model database is used as the template for all databases created on an instance of SQL Server. The entire contents of the model database, including database options, are copied to the new database.(2)
Resource Database
Resource Database
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.(1)
TEMPDB Database
TEMPDB Database
TODO
Bibliography
Bibliography
https://docs.microsoft.com/en-us/sql/relational-databases/databases/system-databases
Model Database(2) https://docs.microsoft.com/en-us/sql/relational-databases/databases/model-database
Resource Database(1) https://docs.microsoft.com/en-us/sql/relational-databases/databases/resource-database