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 objects
System databases
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...
