Errata for Microsoft SQL Server 2012 Step by Step
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed, PDF |
Page back cover
bullet points |
- last point on cover's back reads: "Build your first Windows® Store app" - there is nothing in this book about Windows Store
Note from the Author or Editor:
You are correct. I will have that fixed. |
AdamZ |
Apr 29, 2013 |
|
| Printed |
Page 28
step 3&7 |
I have followed the instructions through the book so far, and in step 3, "SQL Server Development Settings" is not an option available to me. I do have the other 4 depicted in the screen grab. In step 7, "SQL Server Database Project" is also not available. Is it possible that the authors installed some additional software options, not mentioned in the previous steps?
Note from the Author or Editor:
Thank you for catching that. A not will be added to this section. The first time using SQL Server Data tools you will need to install the Database Project from the Web. Therefore, in step 3 you may not see SQL Server Development Settings. Also, in step 7 you will select Microsoft SQL Server Data Tools (Web Install). This will install the database project template. Once complete restart SQL Server Data Tools and you should be able to create a database project. If you have any further questions please feel free to email me at pleblanc@sqllunch.com. Thanks for buying the book. |
Adam C |
May 05, 2013 |
|
| Printed |
Page 40
step 13 |
I resolved the error I previously mentioned... I attempted to create a different kind of SQL project, (some kind of "online" template). It then prompted me to install some component of SQL Data Tools. I then restarted SQL Data tools, and was able to follow the book at that point.
On page 40:
Step 12 tells you to click OK, thereby closing the dialog box. Step 13 then tells you to select an option in the dialog that you just closed.
Minor comments about the next section:
(a) Step 1 is a bit vague. "Open the query editor"... I was unsure whether you wanted me to click "New Query", or save a new script in the "Queries" folder, as on page 27. Perhaps we need a little more hand-holding this early in the book, while we are unfamiliar with SSMS. That seems to be the MS Press SBS style.
(b) After entering the query, do you want us to execute it? After flipping forward in the book, I see that your usual pattern is to say "Enter and Execute," so I'll assume that from now on. But since this was the first script in your book, that minor ommission caused me some confusion.
(c) page 41 refers to an argument "database_name" that is not explicitly mentioned in the query.
Note from the Author or Editor:
I have sent in the updates. Thanks for providing the information
On page 40, step 13 should be removed
Step 1 on page 40 should read Click the button labeled New Query to open the query editor in SSMS
Step 2 on page 30 should read Enter and execute the following T-SQL code: |
Adam C |
May 05, 2013 |
|
| Printed |
Page 67
between printed steps 14 and 15 |
An important step is missing on page 67 between printed steps 14 and 15 regarding adding unique constraints to an existing table. In my understanding, the following step should be added:
14b. Locate and click on the Columns property and then click on the ellipsis next to EmployeeID (ASC). On the next window, select SocialSecurityNumber under the Column Name drop-down list. Click OK.
Note from the Author or Editor:
This should be added directly in the middle of 14 and 15.
15. Locate and click on the Columns property and then click on the ellipsis next to EmployeeID (ASC). On the next window, select SocialSecurityNumber under the Column Name drop-down list. Click OK.
Please adjust numbering. |
mrSQL |
May 09, 2013 |
|
|
| |
