Errata

Incorrect RAID operation type
On page 34, the second sentence from the top reads:



"RAID 1 and RAID 10, for example, each generate one additional read operation for each write operation."



It should read:



"RAID 1 and RAID 10, for example, each generate one additional write operation for each write operation."

Buffer cache calculations incorrect
On pages 47 and 48, the last sentence of page 47 and the first sentence of page 48 reads:



"In this example, Query A requires approximately 120 MB in the buffer cache, Query B requires 60 MB, and Query C requires 50 MB. Thus, the total requirements of all three queries are equal to 230 MB."



It should read:



"In this example, Query A requires approximately 12 MB in the buffer cache, Query B requires 6 MB, and Query C requires 5 MB. Thus, the total requirements of all three queries are equal to 23 MB."

The formatting of questions 3 and 4 is incorrect
On pages 160-161, Starting with question 3, the formatting and numbering is wrong:



Items A, B, and C under question 3 should be bullets, not possible answers. The text of question 4 belongs to question 3, so that questions 5 and 6 need to be renumbered 4 and 5, respectively. Currently questions 3 and 4 read:



"3. The Human Resources department in your company is deploying a new SQL Server 2005 database server. The HRDB server requires the following features:

A. Capability to host three databases and respond to queries

B. Capability to back up the database with the features of VSS enabled

C. Capability to automate administrative tasks



4. You want to reduce the attack surface of HRDB. Which of the following services should be disabled?

A. SQL Server

B. SQL Server Agent

C. SQL Server Browser

D. SQL Writer"



Question 4 should be combined with question 3 and it should read:



"3. The Human Resources department in your company is deploying a new SQL Server 2005 database server. The HRDB server requires the following features:

• Capability to host three databases and respond to queries

• Capability to back up the database with the features of VSS enabled

• Capability to automate administrative tasks

You want to reduce the attack surface of HRDB. Which of the following services should be disabled?

A. SQL Server

B. SQL Server Agent

C. SQL Server Browser

D. SQL Writer"

SCHEMAS should be SCHEMA
On page 226, the code sample in step 3 of Exercise 2 is incorrect.



Change:

"GRANT EXECUTE ON SCHEMAS::dbo TO sqltest"



To:

"GRANT EXECUTE ON SCHEMA::dbo TO sqltest"

Incorrect wording of answer D of question 3
On page 433, Answer D of Question 3 reads:



"RAID 1 + 0 (mirror of stripes)"



It should read:



"RAID 1 + 0 (stripe of mirrors)"

NOTE needs to be added under the RULES subheading
On page 464, under the RULES subheading a NOTE needs to be added with the following text:



"NOTE: CREATE RULE will be removed in a future version of Microsoft SQL Server. Avoid using CREATE RULE in new development work, and plan to modify applications that currently use it. We recommend that you use check constraints instead. Check constraints are created by using the CHECK keyword of CREATE TABLE or ALTER TABLE."

Incorrect SQL Server edition referenced in the explanation of answer B to question 3
On page 615, the explanation for answer B of question 3 reads:



"The replacement server is required to support failover clustering and it must be able to use more than 4 GB of RAM. SQL Server 2005 Standard Edition (32-bit) supports 2-node failover clustering and can use more than 4 GB of RAM."



It should read:



"The replacement server is required to support failover clustering and it must be able to use more than 4 GB of RAM. SQL Server 2005 Standard Edition (64-bit) supports 2-node failover clustering and can use more than 4 GB of RAM."

Incorrect word usage in Answer B of Question 4
On page 647, the first sentence of Answer B of Question 4 reads:



"A database DDL trigger fires on when the specified action is issued within the database."



It should read:



"A database DDL trigger fires when the specified action is issued within the database."

Microsoft Press is committed to providing informative and accurate

books. All comments and corrections listed above are ready for

inclusion in future printings of this book. If you have a later printing

of this book, it may already contain most or all of the above corrections.

Incorrect RAID number used in Figure 1-7 Page 32, Figure 1-7, the description for D: RAID reads: " D: RAID 1, 01, or 10 Log Files" It should read: "D: RAID 1 or 10 Log Files"

Incorrect space requirement given for Analysis Services and data files On page 38, the second row of table 1-7 reads: "Analysis Services and data files 35 KB" It should read: "Analysis Services and data files 35 MB"

Incorrect item circled in Figure 4-6 On page 139, in Figure 4-6 the link "Web Browser Certificate" is incorrectly circled. The correct phrase that should be circled is "Or, submit an advanced certificate request."

Incorrect code in answer A On page 187, the 6th line of answer A reads: PORTS = (SSL),It should read: PORTS = (CLEAR),

Incorrect punctuation and server name On page 377, the first sentence in the 5th paragraph reads: "Data within the existing Products, Customer, Orders, Flights, Cruises, Excursions, and Car Rental databases can be exposed to the Internet through applications running on WEB" It should read: "Data within the existing Products, Customer, Orders, Flights, Cruises, Excursions, and Car Rental databases can be exposed to the Internet through applications running on WEB 1."

Explanation of the size declaration of character data types is incorrect On page 451, the second and third sentence of the third paragraph in the Unicode box reads: "When defining a character data type, you specify the maximum number of bytes the column is allowed to store. For example, a char(10) can store a maximum of 10 characters because each character requires one byte of storage, whereas an nchar(10) can store a maximum of five characters because each Unicode character requires two bytes of storage." It should read: "When defining a character data type, you specify the maximum number of characters the column is allowed to store."

Missing letter from the explanation of answer C to question 1 of Lesson 4 On page 613, the last sentence of answer C to question 1 of Lesson 4 reads: "If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several G." It should read: "If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several GB."

5 GB should be 4 GB and 5 GB should be 6 GB On page 617, the space requirements listed in Lesson 2, Question 2, Answer B is incorrect. Change: "The databases currently stored on other servers require approximately 5 GB (2 + .5 + 1.5) of space. Therefore, if you use DBSRV2 as the consolidation server, it would leave 5 GB of free space." To: "The databases currently stored on other servers require approximately 4 GB (2 + .5 + 1.5) of space. Therefore, if you use DBSRV2 as the consolidation server, it would leave 6 GB of free space."