In this chapter, you will learn about:
• Data types such as the new large value data types and XML data types
• User-defined data types (including both T-SQL and CLR user-defined data types)
• Data quality
• Creating a database
• Schemas and naming conventions
• Database control, including change management
I will prepare and some day my chance will come.
Before we can start talking about database design, we need to explain the concepts of what there is to design—things like tables, data types, and views. Tables and data types are the basics of any database. SQL Server also has views, which allow you to view any portion of a table or combination of tables. Last, we'll ...