SQL Server Databases

SQL Server Databases :-

Databases in SQL Server are containers for data and objects, including tables, views, stored procedures, user accounts, and other management objects. A SQL Server database is always a single logical entity, backed by multiple physical files.


When client applications send requests to the database engine as T-SQL statements, SQL Server performs all file, memory, and processor utilization on the client's behalf. Clients never directly access database files, unlike in desktop database applications.

Containers	Boundaries	Backed by Files
Tables	Security Accounts	Data files
Views	Permissions	Log files
Procedures	Default Collation	Organized in filegroups
Functions
Users
Roles
Schemas

SQL Server supports two types of databases: 

• system 
• user.

master, the system configuration database.

msdb, the configuration database for the SQL Server Agent service and other system services.

model, the template for new user databases.

tempdb, used by the database engine to store temporary data such as work tables. This database is dropped and recreated each time SQL Server restarts - never store anything you need to depend on in it!

Resource, a hidden system configuration database that provides system objects to other databases.

Database administrators and developers can create user databases to hold data and objects for applications. You connect to a user database to execute your queries. You will need security credentials to log in to SQL Server and a database account with permissions to access data objects in the database.