In the following lines, we will present the basic structure of SQL Server objects, from the server to the database level. This book does not have the scope to cover all the elements of which we are going to speak, but it will give you enough information to cover all the basics.
SQL server has a concept of system and user databases. User databases are created for specific types of business process: HR, online shop, eHealth, and so on. It's up to the user (developers and DBAs) to define all the parameters. Here, you are in charge (more about it Chapter 4, Database in the Sandbox).
On the other hand, system databases are created during the installation procedure without almost any user influence. It is a repository of all SQL Server internals and it continues its process of updating its content, such as:
- Configuration data
- Users information
- Database objects
- Query execution statistics
- Troubleshooting
- Data statistics
- And many more
SQL Server simply can't work without...