cài đặt rất SQL Server đi kèm với một số hệ thống cấu hình sẵn và cơ sở dữ liệu mẫu. Trong phần này, bạn sẽ tìm hiểu về chúng, mục đích của họ, và những gì bạn có thể làm gì với chúng. Tôi sẽ giải thích các nguyên tắc cơ bản thiết kế cơ sở dữ liệu cũng như quy tắc bình thường để giúp bạn bắt đầu với thiết kế cơ sở dữ liệu. | SESSION 6 SQL Server Databases Session Checklist Understanding the SQL Server system databases Exploring the SQL Server sample databases Learning the basics of relational-database design 30 Min. To Go Every SQL Server installation comes with several preconfigured system and sample databases. In this session you will learn about them their purpose and what you can do with them. I will explain the database-design fundamentals as well as rules of normalization to help you get started with database design. Understanding the SQL Server System Databases Every newborn SQL Server database system initially contains only six databases Master TempDB Model MSDB Pubs and Northwind. The first four of these are databases Pubs and Northwind are sample databases provided to help you master relational-database concepts. I describe these two in the next section. Saturday Morning 62 Although it is possible you should never try to modify any system database directly through the use of Transact-SQL statements as this may and often will render your RDBMS unusable. Consider any system database especially Master a sanctum sanctorum and treat it accordingly. The Master database The Master database contains information about your whole SQL Server system login accounts configuration settings and a record of every custom database and its location that you might have created. It also contains initialization information that SQL Server uses on startup system stored procedures precompiled chunks of Transact-SQL programs that perform various administrative tasks extended stored procedures external compiled programs callable from within SQL Server and more. System stored procedures are discussed further in Session 11 and Session 23. Always maintain a current backup of your Master database. Create a new backup as covered in Session 18 every time you change system settings such as collation order default language and so on . The TempDB database TempDB holds all temporary tables for intermediate .
