Errata

Introducing Microsoft SQL Server 2012

Errata for Introducing Microsoft SQL Server 2012

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
PDF Page 18-19
Figures 1-8 and 1-9

Figures 1-8 and 1-9 are out of order. Figure 1-8 should be Figure 1-9, and Figure 1-9 should be Figure 1-8.

 devonm  Mar 17, 2012 
PDF Page 18
Figure 1.8

The graphic in figures 1.8 and 1.9 are the wrong way around. 1.8 shows a side-by side migration but is captioned as an in-place migration, whereas 1.9 shows an in-place migration.

 Anonymous  Mar 21, 2012 
PDF Page 18,19
Figure 1-8 and Figure 1-9

I see in Page 17,18,19 we discuss about "Installation, Upgrade, and Migration Strategies" and according to the book, it is printed as below:

Fig 1-8 on Page 18 -> In-place Upgrade.
Fig 1-9 on Page 19 -> Side-by-Side Migration.

I doubt that it should be printed this way:

Fig 1-8 -> Side-by-Side Migration.
Fig 1-9 -> In-place Upgrade.

 Durai Murugan  Mar 29, 2012 
PDF Page 40
first paragraph (Online Operations), 2nd sentence

In the Online Operations section, LOB reindexing is described as "Line-of-business". This should be "Large Object"

 Kevin Martin  May 18, 2012 
PDF Page 44
1st paragraph, 8th line

When describing compression benefits of ColumnStore indexes, incorrectly refers to the compression algorithm as "VertiPag". This should be "VertiPaq" as mentioned earlier in the same paragraph.

 Anonymous  May 18, 2012 
PDF Page 62
last paragraph (bottom of page)

Describing audit log failure behavior options, the heading for the first option says "On Audit Shut Down Server". This should say "On Audit Log Failure: Shut down server".

I would also recommend changing the order that the options are listed in the text so that they match the order presented in the "Create Audit" dialog.

The options are listed in book as:
On Audit Shut Down Server (note typo as described above)
On Audit Log Failure: Continue
On Audit Log Failure: Fail Operation

The options are listed in the "Create Audit" dialog as:
On Audit Log Failure: Continue
On Audit Log Failure: Shut down server
On Audit Log Failure: Fail operation

 Anonymous  May 18, 2012 
PDF Page 64
Step 5

"If you select File as your Audit Log Failure option" should be "If you select File as your Audit Destination"

 Anonymous  Mar 22, 2012 
PDF Page 64
Figure 4-2

The description of figure 4-2 mentions that "Fail Operation" was selected, while the screenshot has "Continue" highlighted.

 Anonymous  Aug 09, 2012 
PDF Page 65
User-Defined Audit Event

The line that starts with "CREATE PROCEDURE" should be the first statement in a query file.

 Anonymous  Jul 12, 2012 
PDF Page 66
near top, in sample code

In sample code for user-defined audit, missing apostrophe in unicode string; causes error executing statement.

SELECT @additionalInfo = NTech webuser=' + @name;

should be
SELECT @additionalInfo = N'Tech webuser=' + @name;

 Anonymous  May 21, 2012 
PDF Page 66
Code

I got an error that begins, "The variable name '@authOK' has already been declared." The code says, for the second time, "DECLARE @authOK bit". It probably should not say that.

 Anonymous  Jul 12, 2012 
PDF Page 99
Last boxed element

Disable Run64BitRunTime SSIS project property is no longer needed on 64-bit computers.

 Everton B. Gomes  Mar 20, 2013