Microsoft SQL Server 2012 Step by Step

Errata for Microsoft SQL Server 2012 Step by Step




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.

Adam Zaremba  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 29
Step 22

We are told to select "Deploy" from the menu after right-clicking the project in the Solutions Explorer. But "deploy" isn't an option in that menu.

Note from the Author or Editor:
Instead of deploy it should have been publish. Thanks for pointing this out. Please email me at pleblanc@sqllunch.com if you have any questions or concerns regarding the book.

Anonymous  May 24, 2013 
Printed
Page 29
Step 23

Right clicking on the project does NOT display the Deploy option...many other options are displayed including Publish but NOT Deploy

Note from the Author or Editor:
Instead of deploy it should have been publish. Thanks for pointing this out. Please email me at pleblanc@sqllunch.com if you have any questions or concerns regarding the book.

Nicolas Lira  Jun 06, 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 52
Figure 5-2

Table name of the Departments table should be Department to remain consistent with the other tables and to maintain the stated standard.

Note from the Author or Editor:
Correct again. We will get the image updated to Department

Anonymous  Aug 01, 2013 
Printed
Page 64
Step 2

Comment reads --Use this code to add the Gender column to the Employee table. The comment should read --Use this code to add the FullName column to the Employee table

Note from the Author or Editor:
You are correct and it will be updated to FullName. Thanks again

Anonymous  Aug 01, 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.

Motiar Rahman  May 09, 2013 
Printed
Page 67
Step 20

The instructions state ([Gender='Female' OR [Gender]='Male'). Note: bracket after first instance of Gender is missing; the field size for the Gender field is 1. Should be written as ([Gender]='F' OR [Gender]='M')

Note from the Author or Editor:
Thanks, text will be changed to ([Gender]='F' OR [Gender]='M')

Anonymous  Aug 01, 2013 
Printed
Page 67
Subhead between 22. and 1.

The subhead reads: Add a computer column using T-SQL. The subhead should read: Add constraints using T-SQL.

Note from the Author or Editor:
You are correct. The subheading will be updated to constraints instead of computed columns

Anonymous  Aug 01, 2013 
Printed
Page 91
Between steps 7 and 8

The Disable Indexes dialog box opens. Should we select the Indexes to disable before clicking OK?

Note from the Author or Editor:
In step seven on page 91 it states to right-click a specific index and select Disable. A step you have been added prior to that step indicating the selection of the index.

Anonymous  Aug 02, 2013 
Printed, PDF
Page 201
3rd paragraph from top

QUOTED_INDENTIFIER option - obviously should be QUOTED_IDENTIFIER

Note from the Author or Editor:
You are correct. Should be QUOTED_IDENTIFIER. Thanks for pointing this out. Thanks for reading the book. Please feel free to email me at pleblanc@sqllunch.com if you have any for questions or concerns.

Marek Wlodarz  May 25, 2013