SQL SERVER DETAILED INSTALLATION (SQL SERVER 2016 or SQL SERVER 2017)
A SET OF FIVE SYSTEM DATABASES ARE AUTO CREATED
MASTER – USED TO STORE SERVER PROPERTIES AND LOCATION OF OTHER DATABASES, CONNECTIONS.
MODEL – USED AS A TEMPLATE FOR NEW DATABASES WE CREATE IN FUTURE.
MSDB – USED BY SQL DBAs FOR JOBS, ALERTS, EMAILS, REPAIRS, TROUBLESHOOTING
TEMPDB – USED BY DEVELOPERS AND TESTERS FOR TEMPORARY CALCULATIONS, TEMP STORAGE
RESOURCE – HIDDEN, READ ONLY DATABASE. USED FOR CONTROLLING ABOVE DATABASES.
INSTANCE – IT IS A SUCCESSFUL INSTALLATION OF SQL SERVER.
SERVICE (MAIN GATE) – COMMUNICATION PATH BETWEEN SQL SERVER AND WINDOWS OS.
ACCOUNTS (WATCHMEN SERVICE) – WIDNOWS USER OR GROUP RESPONSIBLE TO MANAGE THE SERVICE.
AUTHENTICATION (MAIN DOOR) – COMMUNICATION PATH BETWEEN SQL SERVER AND END USERS.
LOGIN (SECURITY) – WINDOWS USER OR GROUP OR ANY OTHER OS USER USED TO CONNECT, OPERATE ON THE SERVER.
COLLATION – A PROPERTY USED TO SPECIFY LANGUAGE AND CHARACTER SETTINGS FOR DATA STORAGE.
EX: USER NAME : CASE INSENSITIVE PASSWORD: CASE SENSITIVE
FILESTREAM – A PROPERTY USED TO STORE BIG DATA FILES & CLOUD DATA. ALSO USED FOR “MEMORY TABLES”.