Errata
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted by | Date submitted |
---|---|---|---|---|
ePub | Page Practice Exam: question about restoring a database United States |
The correct answer says that you must restore the full backup from Sunday, then the differential backup from Monday, then the differential backup from Tuesday, then the logs. I think the correct answer should be that you restore the full backup, then the differential backup from Tuesday (no need to restore more than one diff backup), then the logs. |
James Hatcher | Dec 28, 2013 |
Printed | Page 95 After step 8 |
Also you need to add another inbound rule in addition to the rule specified in steps 7 and 8. SQL Server named instances (not the default instance) all like to use dynamic ports. SQL Server Browser will take care of the dynamic port mapping so you need to created a GPO for UDP 1434 (SQL Server Browser). Basically following steps 7 and 8 but use a port rule rather than an program rule. Otherwise I was not able to connect to the ALTERNATE instances on either SQL-B or SQL-CORE. After I added the additional inbound rule to the SQL-POLICY GPO (I called the rule SQL-Server-Browser) I was able to connect to both SQL-B\ALTERNATE and SQL-CORE\ALTERNATE without any problems. I was using Windows 8.1 Professional Microsoft Hyper-V for my virtual machine setup. |
David Hicks | Mar 10, 2014 |
Page 157 Canada |
The link in the More Info - Supported Edition and Version Upgrades doesn't work. I was able to find this information at: http://technet.microsoft.com/en-us/library/ms143393.aspx |
Andy Binning | Oct 21, 2013 | |
Printed | Page 220 Exercises 1.2 and 2.4 |
In chapter 5, Lesson 2, Exercise 1, Part 2 you are instructed to create the user "sql_user_c" |
Anonymous | Nov 28, 2013 |
Printed | Page 268 towards the bottom |
syspolicy_policy_group_subscriptions |
Anonymous | Oct 21, 2013 |
Printed | Page 343 Exercise 4.3 |
The third bullet point in exercise 4.3 says to set the Cluster Network Configuration IP address to 10.0.0.120. With this value the SQL Server Installation Center gives an error and won't let you proceed. The correct address needs to be on the same subnet as the Cluster IP Address and therefor should be 10.10.10.120. |
Anonymous | Dec 04, 2013 |
Page 429 last paragraph |
"There are several specific dynamic management views (DMVs) that can be used to retrieve information about indexes. One such DMV is sys.dm_db_index_physical_stats." |
Anonymous | Mar 13, 2014 | |
Page 435 The first step of adding a maintenance plan |
"In SSMS, expand the Instance node and then expand the Maintenance node." |
Anonymous | Mar 13, 2014 | |
Printed | Page 462 Lesson 1, Question 5, Answer B |
Executing the UPDATE STATISTICS command on the table specifying the WITH SAMPLE 20 PERCENT option will not fix the out-of-data statistics. |
Steve Hood | Feb 11, 2014 |
Page 463 answer 4 |
In order to meet the requirement "You need to remove the blocking" , you must issue the KILL 57 command. |
Sal Young | Nov 19, 2013 |