Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

Errata for Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases




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
Page xxii
Step 2 of section Prepare Fourth Member Server

Step 2 reads: Log on to the third computer on which... Should read Log on to the fourth computer on which...

Note from the Author or Editor:
Page xxii Change Log on to the third computer to Log on to the fourth computer

Frieda Weigle  Jul 20, 2012  Oct 19, 2012
Printed
Page xxiii
2nd line down

static IP address should be 10.10.10.60 not 10.10.10.40

Note from the Author or Editor:
Page xxiii Change 10.10.10.40 to 10.10.10.60

Ian Cooper  Oct 05, 2012  Oct 19, 2012
Printed, PDF
Page I
Objective Maps

In the Objective Maps it says: "Manage and configure databases Chapter 3 Lesson 3" The 3rd Chapter has no Lesson 3. It must be Lesson 2.

Note from the Author or Editor:
Page (ii) Change Manage and configure databases. 3 3 to Manage and configure databases. 3 2

Anonymous  Oct 23, 2012  Feb 08, 2013
Printed
Page 3
3rd sentence down on page 3

The sentence reads "Windows Vista SP2 x86 is a 32-bit operating system that supports only the x86 versions of SQL Server 2012 Developer and SQL Server 2012 Express editions." The chart below the sentence states Windows Vista SP2 x86 also supports SQL Server 2012 x86 Standard. Also confirmed on the following URL: http://msdn.microsoft.com/en-us/library/ms143506.aspx

Note from the Author or Editor:
Page 3 change "Windows Vista SP2 x86 is a 32-bit operating system that supports only the x86 versions of SQL Server 2012 Developer and SQL Server 2012 Express editions." to "Windows Vista SP2 x86 is a 32-bit operating system that supports only the x86 versions of SQL Server 2012 Developer and SQL Server 2012 Express editions.

Daniel McDonald  Sep 03, 2013 
Printed, PDF
Page 18
Bullet #13: SQL Client Connectivity SDK

The component is certainly supported on Windows Server Core according to the reference provided on page 17: http://msdn.microsoft.com/en-us/library/hh231669(v=sql.110).aspx

Note from the Author or Editor:
Delete bullet SQL Client Connectivity SDK

Hector Rocha  Mar 10, 2013  May 24, 2013
Printed
Page 19
Line 6

There seems to be a general error throughout the early part of the book with the Domain name. Should it be Contso.com or Contoso.com ? This error reappears in multiple places. The Domain Controller instructions use 'Contso.com'. So what should it be ?

Note from the Author or Editor:
Global Change contso to contoso

Ian Cooper  Oct 05, 2012  Oct 19, 2012
Printed, PDF
Page 23
Lesson Summary

In the summary point begining "SQL Server 2012 Enterprise", replace the text "using SQL Server 2012 Datacenter, Enterprise, Standard, and Web editions" with "using Windows Server Datacenter, Enterprise, Standard, and Web editions"

Note from the Author or Editor:
Page 23 Change SQL Server 2012 Enterprise, Business Intelligence, and Web editions of SQL Server 2012 can be run only on Windows Server 2008 R2 SP1 and Windows Server 2008 SP2 operating systems using SQL Server 2012 Datacenter, Enterprise, Standard, and Web to SQL Server 2012 Enterprise, Business Intelligence, and Web editions can be run on the Windows Server 2008 R2 SP1 and Windows Server 2008 SP2 operating system.

Malcolm Wynden  Aug 30, 2012  Oct 19, 2012
Printed, PDF
Page 24
Lesson Summary

"Intel EM64T" was rebranded as "Intel 64" "EMT54" is a typo as well, and should be corrected and updated to "Intel 64"

Note from the Author or Editor:
Page 24 Change EMT54 to EMT64

Malcolm Wynden  Aug 30, 2012  Oct 19, 2012
Printed
Page 34
1st paragraph

"For example, to install the SQL Server Database Engine, Replication, and Full-Text Search features, use the following syntax: Setup.exe /q /ACTION=Install /FEATURES=SQL..." By using FEATURES=SQL it would also install the Data Quality Server feature as stated on the previous page and confirmed on http://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature

Note from the Author or Editor:
page 34 Change "to install the SQL Server Database Engine, Replication, and Full-Text Search features" to "to install the SQL Server Database Engine, Replication, Data Quality Server and Full-Text Search features"

David Mischick  Sep 14, 2012  Oct 19, 2012
PDF
Page 38
1st sentence

Sentence reads "You can use the setup.com command-line ..." The context of the sentence would suggest it should read "setup.exe command-line...

Note from the Author or Editor:
Page 38 Change You can use the Setup.com to You can use the Setup.exe

Dennis Baker  Jul 30, 2012  Oct 19, 2012
Printed
Page 43
Table 1-4, Item Column, 5th row

SQK Server instance running over an HTTP endpoint should read: SQL Server instance running over an HTTP endpoint

Note from the Author or Editor:
Page 43 Change SQP Server to SQL Server

Frieda Weigle  Aug 02, 2012  Oct 19, 2012
Printed
Page 47
Point number 9

At the ninth point there is a refer to Figure1-29 about the Database Engine Configuration, but the figure refers to the Server Configuration.

Note from the Author or Editor:
Page 47 Change Database Engine Configuration page shown in Figure 1-29, to Server Configuration page shown in Figure 1-29,

Marco Tarantino  Nov 13, 2012  Feb 08, 2013
PDF
Page 47
Points 8 and 9

A previous errata regarding point 9 on page 47 has a solution of changing the text on point nine. However the solution make no sense as the remainder of the 9th point still refers to Database Engine configuration screen, not the pictured Server Configuration screen. A better solution is: Change the start of point 8 from: On the Server Configuration Page, accept the... to: On the Server Configuration Pageshown in figure 1-29, accept the... Then change the start of point 9 from: On the Database Engine Configuration page shown in Figure 1-29, click Add... to: On the Database Engine Configuration page, click Add...

Note from the Author or Editor:
Page 47 Change 8. On the Server Configuration page, accept the default Service Accounts settings. 9. On the Server Configuration page shown in Figure 1-29, click Add Current User and ensure that Windows Authentication Mode is selected. to 8. On the Server Configuration page shown in Figure 1-29, accept the default Service Accounts settings. 9. On the Database Engine Configuration page, click Add Current User and ensure that Windows Authentication Mode is selected.

Jon Watts  Jul 02, 2013 
Printed
Page 49
Exercise 4 - description of exercise

The exercise description states that "... you add features to the existing SQL Server 2012 instances on servers SQL-A and SQL-B..." however, the exercise only guides you through adding features to SQL-B with no instructions for doing anything with SQL-A.

Note from the Author or Editor:
Page 49 Change In this exercise, you add features to the existing SQL Server 2012 instances on servers SQL-A and SQL-B. to In this exercise, you add features to the existing SQL Server 2012 instance on server SQL-B.

Anonymous  Apr 19, 2013  May 24, 2013
Printed, PDF
Page 52
Bullet #5

I wonder how "You can add features to an existing installation by using Windows Explorer" ?

Note from the Author or Editor:
Change You can add features to an existing installation by using Windows Explorer, by using Setup.exe from the command line, or by invoking SQL Server Setup through SQL Server Installation Center. To You can add features to an existing installation by using Setup.exe from the command line, or by invoking SQL Server Setup through SQL Server Installation Center.

Hector Rocha  Mar 10, 2013  May 24, 2013
Printed
Page 56
1st question

Lesson 1 Question 1 lists the correct answer as B, e.g. B. Correct: The Enterprise edition requires a minimum of 1 GB of RAM. The question on page 24 reads "What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?" The correct answer should be for recommended (4 GB), not required (1 GB). The correct answer is D. Either the question should be changed to replace "recommended" with "required", or the answer should be updated with correct information.

Note from the Author or Editor:
Page 24 change: "What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?" to "What is the minimum required amount of RAM for SQL Server 2012 Enterprise?"

Bruce Hendry  Sep 03, 2013 
Printed
Page 64-65
End of page, start of next page

The sentence, "For example, to configure an instance to use a minimum of 1024MB of memory and a maximum of 8096 MB of memory, use the following query:" should read "For example, to configure an instance to use a minimum of 1024MB of memory and a maximum of 4096 MB of memory, use the following query:" so that it matches the query code on the next page.

Note from the Author or Editor:
page 65 Change EXEC sys.sp_configure 'max server memory', 4096; to EXEC sys.sp_configure 'max server memory', 8096;

Frieda Weigle  Aug 03, 2012  Oct 19, 2012
PDF
Page 64
Above Figure 2.2

The sentence "When SQL Server 2012 is run on a 32-bit operating system, the lowest minimum memory value you can allocate is 64 MB" should read "When SQL Server 2012 is run on a 32-bit operating system, the lowest maximum memory value you can allocate is 64 MB" The sentence "If SQL Server 2012 is run on a 64-bit operating system, the lowest minimum memory value you can allocate is 128 MB" should read "If SQL Server 2012 is run on a 64-bit operating system, the lowest maximum memory value you can allocate is 128 MB"

Note from the Author or Editor:
Page 64 Change "When SQL Server 2012 is run on a 32-bit operating system, the lowest minimum memory value you can allocate is 64 MB" to "When SQL Server 2012 is run on a 32-bit operating system, the lowest maximum memory value you can allocate is 64 MB" & Change "If SQL Server 2012 is run on a 64-bit operating system, the lowest minimum memory value you can allocate is 128 MB" to "If SQL Server 2012 is run on a 64-bit operating system, the lowest maximum memory value you can allocate is 128 MB"

Malcolm Wynden  Aug 08, 2012  Oct 19, 2012
PDF
Page 79
question 2

Question 2: Currently: ...so that the maximum amount of memory the instance uses does not exceed 4,096 GB. (4TB) Should be changed to: ...so that the maximum amount of memory the instance uses does not exceed 4,096 MB. (4GB) Reason: none of the answers would be correct if it was GB as that would be 4096000MB. Question should be changed to reflect the values used in the potential answers.

Note from the Author or Editor:
Page 79 Change instance uses does not exceed 4,096 GB? to instance uses does not exceed 4,096 MB?

Nathan A  Dec 24, 2012  Feb 08, 2013
Printed
Page 85
Last sentence

/sq in last command at bottom of page should be /qs

Note from the Author or Editor:
Page 85 <package_name>.exe /sq to <package_name>.exe /qs

Polly Burton  Jul 31, 2012  Oct 19, 2012
Printed
Page 88
Create a resource pool, step 2

The book states 'click on the column labeled with an asterix (*)'. This should read 'click on the row labeled with an asterix (*)'

Note from the Author or Editor:
Page 88 Change 'click on the column labeled with an asterix (*) to 'click on the row labeled with an asterix (*)

Steph Fuller  Oct 10, 2012  Oct 19, 2012
Printed
Page 91
First paragraph underneath Figure 2-16

Unnecessary comma in the sentence "WSRM allows you, to manage processor resources by using percent CPU targets or processor affinity rules"

Note from the Author or Editor:
Change "WSRM allows you, to manage processor resources by using percent CPU targets or processor affinity rules." to "WSRM allows you to manage processor resources by using percent CPU targets or processor affinity rules."

Anonymous  Apr 26, 2013  May 24, 2013
PDF
Page 95
Exercise 1, Step 7

Location for rule described in exercise as "Computer Configuration\Windows Settings\Security Settings node" This should read as "Computer Configuration\Policies\Windows Settings\Security Settings node"

Note from the Author or Editor:
Page 95 Change "Computer Configuration\Windows Settings\Security Settings node" to "Computer Configuration\Policies\Windows Settings\Security Settings node"

Malcolm Wynden  Aug 09, 2012  Oct 19, 2012
Printed
Page 101
#5 answer

Answer to #5 shows "A" using sp_configure but page 79 has that option under "B" so don't match.

Note from the Author or Editor:
Page 79 Change 5. Which stored procedure do you use to enable Database Mail on an instance? A. sp_monitor B. sp_configure C. sp_rename D. sp_depends to 5. Which stored procedure do you use to enable Database Mail on an instance? A. sp_configure B. sp_rename C. sp_monitor D. sp_depends

Polly Burton  Jul 30, 2012  Oct 19, 2012
PDF
Page 106
Bottom of the page

configuring the Analysis Services service account as contoso\asaccount, and with contoso\kim_akers as the Analysis Services Administrator account Setup.exe /q /IAcceptSQLServerLicenseTerms /Action=install /Features=AS /ASSERVERMODE=MULTIDIMENSIONAL /INSTANCENAME=ASMulti /ASSVCACCOUNT=NetworkService /ASSYSADMINACCOUNTS=contoso\kim_akers The service account requested is contoso\asaccount. The statement use NetworkService as service account.

Note from the Author or Editor:
Page 106 Change /ASSVCACCOUNT=NetworkService to /ASSVCACCOUNT=Contoso\kim_akers

Rachel Van den Berg  Nov 12, 2012  Feb 08, 2013
Printed, PDF
Page 120
Step 7

Missing close parenthesis before "TO FILEGROUP FileStreamFileGroup" USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM' TO FILEGROUP FileStreamFileGroup

Note from the Author or Editor:
Page 120 Change USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM' TO FILEGROUP FileStreamFileGroup to USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM' TO FILEGROUP FileStreamFileGroup )

Johnny Wyskiel  Sep 05, 2012  Oct 19, 2012
Printed, PDF
Page 120
para 7.

There is an errata entry already but the correction itself is wrong: USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM' TO FILEGROUP FileStreamFileGroup ) *SHOULD BE* USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM') <--------- *NOTE THE CLOSING PARENT* TO FILEGROUP FileStreamFileGroup

Note from the Author or Editor:
Change: USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM' TO FILEGROUP FileStreamFileGroup ) to USE master GO ALTER DATABASE Litware2012 ADD FILE ( NAME = FileStrmFile, FILENAME = 'C:\FSTRM') TO FILEGROUP FileStreamFileGroup

Peter Gratzinger  Jan 01, 2013  Feb 08, 2013
Printed
Page 123
Exercise 2

Exercise does not specify which SQL Server virtual machine to install Reporting Services on...

Note from the Author or Editor:
Page 123 Change Open an elevated PowerShell prompt and run the following command: to On SQL-A open an elevated PowerShell prompt and run the following command:

Frieda Weigle  Aug 14, 2012  Oct 19, 2012
PDF
Page 130
3rd paragraph

In SQL Server 2012 the contained database feature is currently available only in a partially contained state http://msdn.microsoft.com/en-us/library/ff929071.aspx

Note from the Author or Editor:
Page 129 Change "SQL Server 2012 supports contained databases and Partially Contained Databases (Partial-CDBs)," to "SQL Server 2012 supports Partially Contained Databases (Partial-CDBs),

prad  Jul 01, 2013 
PDF
Page 132
On top, second row

ALTER INDEX indexName ON tableName REBUILD PARTITION ALL WITH (DATA_COMPRESSION=ROW) Should be: ( missing ' = ' ) ALTER INDEX indexName ON tableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION=ROW) Thank you!

Note from the Author or Editor:
Page 132 Change "ALTER INDEX indexName ON tableName REBUILD PARTITION ALL WITH (DATA_COMPRESSION=ROW)" to "ALTER INDEX indexName ON tableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION=ROW)"

Edo Polimac  Jul 15, 2013 
Printed
Page 143
2nd bullet point

DBCC PROCACHE should read DBCC PROCCACHE.

Note from the Author or Editor:
Page 143 Change DBCC PROCACHE to DBCC PROCCACHE

Frieda Weigle  Sep 12, 2012  Oct 19, 2012
Printed
Page 143
DBCC SHOWCONFIG

This statement should be 'DBCC SHOWCONTIG', not 'DBCC SHOWCONFIG'.

Note from the Author or Editor:
Page 143 Change DBCC SHOWCONFIG to DBCC SHOWCONTIG

Steph Fuller  Oct 10, 2012  Oct 19, 2012
PDF
Page 153
Heading titled Lessons in this chapter

Page number references for Chapter 4: Lessons 1 and 2 are incorrect.

Note from the Author or Editor:
Change Lesson 1: Migrating to SQL Server 2012 142 to Lesson 1: Migrating to SQL Server 2012 154 & Lesson 2: Importing and Exporting Data 162 to Lesson 2: Importing and Exporting Data 175

Malcolm Wynden  Aug 10, 2012  Oct 19, 2012
PDF
Page 154
Last paragraph

Last sentence should start "If you have a database hosted on an Itanium-architecture SQL Server instance..." rather than "If you have a database hosted on an Itanium-architecture SQL Server 2012 instance..." It is not possible to have an Itanium-architecture SQL Server 2012 instance.

Note from the Author or Editor:
Page 154 Change "If you have a database hosted on an Itanium-architecture SQL Server 2012 instance," to "If you have a database hosted on an Itanium-architecture SQL Server instance,"

Malcolm Wynden  Aug 10, 2012  Oct 19, 2012
PDF
Page 162
code sample below Figure 4.4

Code sample for sp_detach_db to detach the Planets database uses the database name [SpaceElevator], not [Planets]

Note from the Author or Editor:
Page 162 Change For example, to detach the Planets database to For example, to detach the SpaceElevator database

Malcolm Wynden  Aug 10, 2012  Oct 19, 2012
PDF
Page 181
6th bullet point

ADMINISTER BULK OPERATIONS is a permission associated with the login, rather than the file, so the bullet point is not correct. "A user performing the bulk operation needs read access to the file on the file system and the ADMINISTER BULK OPERATIONS permission on the file" Perhaps it should read :- "A user performing the bulk operation needs read access to the file on the file system and the ADMINISTER BULK OPERATIONS login permission"

Note from the Author or Editor:
Change A user performing the bulk operation needs read access to the file on the file system and the ADMINISTER BULK OPERATIONS permission on the file. to A user performing the bulk operation needs read access to the file on the file system and the ADMINISTER BULK OPERATIONS permission.

Anonymous  Mar 26, 2013  May 24, 2013
PDF
Page 182
More Info link

Broken link. MORE INFO: IMPROVING BULK IMPORT PERFORMANCE You can learn more about improving the performance of bulk import operations at http://msdn.microsoft.com/en-us/library/ms190421(SQL.110).aspx.

Note from the Author or Editor:
Page 182 Change http://msdn.microsoft.com/en-us/library/ms190421(SQL.110).aspx to http://msdn.microsoft.com/en-us/library/ms190421(SQL.105).aspx

Malcolm Wynden  Aug 12, 2012  Oct 19, 2012
PDF
Page 184
Exercise 2.5

"5. Use the bcp utility to export data from the Person.Contact table in the AdventureWorks2012 database..." There is no such table in that database. The reference is likely to the Person.Person table.

Note from the Author or Editor:
Page 184 Change export data from the Person.Contact table to export data from the Person.Person table

Malcolm Wynden  Aug 13, 2012  Oct 19, 2012
Printed, PDF
Page 199
Examples in lines 7 and 11

In lines 4 and 5 the text specifies: "For example, to create an asymmetric key named sql_user_5 by using ...". However the command in lines 7 and 11 show a different user: "sql_user_e". In line 7: "CREATE ASYMMETRIC KEY sql_user_5 WITH ALGORITHM = RSA_2048" Instead "CREATE ASYMMETRIC KEY sql_user_e WITH ALGORITHM = RSA_2048" And in line 11: "CREATE LOGIN sql_user_5 FROM ASYMMETRIC KEY sql_user_5" Instead "CREATE LOGIN sql_user_e FROM ASYMMETRIC KEY sql_user_e" and in line 11:

Note from the Author or Editor:
Change For example, to create an asymmetric key named sql_user_5 by using the RSA_2048 algorithm on a database that has an existing master key, issue the following Transact-SQL statement to For example, to create an asymmetric key named sql_user_e by using the RSA_2048 algorithm on a database that has an existing master key, issue the following Transact-SQL statement

Hector Rocha  Mar 16, 2013  May 24, 2013
PDF
Page 200
MORE INFO SYS.SQL_LOGINS

In the pdf file, the text "You can learn more about the sys.sql_logins catalog view at http://msdn.microsoft.com/en-us/library/ms174355(SQL.110).aspx" has an incorrect hyperlink associated to the html page. If you place your mouse pointer over the text "http://msdn.microsoft.com/en-us/library/ms174355(SQL.110).aspx" you will see that the hyperlink points to a different web page: "http://msdn.microsoft.com/en-us/library/hh231722(SQL.110).aspx". And if you click the hyperlink, your browser will open a "Install Analysis Services in Tabular Mode" web page, which is not related to the context of this topic

Note from the Author or Editor:
Page 200 Fix url mapped in PDF in SYS.SQL_LOGINS to http://msdn.microsoft.com/en-us/library/ms174355(SQL.110).aspx

Hector Rocha  Mar 15, 2013  May 24, 2013
PDF
Page 201
1st paragraph

"DENY CONNECT SQL "contoso\domain_user_b";" should be "DENY CONNECT SQL TO "contoso\domain_user_b";"

Note from the Author or Editor:
Page 201 Change DENY CONNECT SQL "contoso\domain_user_b"; to DENY CONNECT SQL TO "contoso\domain_user_b";

Henrik  Mar 13, 2013  May 24, 2013
Printed
Page 205
Exercise 1 Step 5

Mentions to create SQL Server authenticated login, but doesn't state to also enter a password as other steps in the practice do. You must designate a password for a SQL Server account.

Note from the Author or Editor:
Page 205 Change: Use SQL Server Management Studio to create a SQL Server–authenticated login named sql_user_b. to Use SQL Server Management Studio to create a SQL Server–authenticated login named sql_user_b with the password Pa$$w0rd

Frieda Weigle  Jan 13, 2013  Feb 08, 2013
Printed, PDF
Page 206
Lesson Summary

Bullet point beginning "SQL Server logins allow" has repeated word "to to". Please consider using a comma in this sentence to logically group the 4 items linked by "or" into the two pairs of items.

Note from the Author or Editor:
Page 206 Change "user accounts or to to local" to "user accounts or to local"

Malcolm Wynden  Aug 30, 2012  Oct 19, 2012
PDF
Page 213
Link near top of page

Link for FIXED DATABASE-LEVEL ROLES is broken. Likely should be changed to http://msdn.microsoft.com/en-us/library/ms189121(SQL.110).aspx

Note from the Author or Editor:
Page 213 Change http://msdn.microsoft.com/en-us/library/ms189612(SQL.110).aspx. to http://msdn.microsoft.com/en-us/library/ms189121.aspx

Malcolm Wynden  Aug 14, 2012  Oct 19, 2012
Printed
Page 215
EXAM TIP

Statement "You cannot use the ALTER ROLE statement to add role members" is not true. It can be used to ADD MEMBER and DROP MEMBER.

Note from the Author or Editor:
Page 215 Delete Exam Tip

Polly Burton  Aug 10, 2012  Oct 19, 2012
Printed
Page 220
Exercise 2, Step 4.

"Use the appropriate stored procedure to add the sql-c user..." should read "Use the appropriate stored procedure to add the sql_user_c user..."

Note from the Author or Editor:
Page 220 Change "Use the appropriate stored procedure to add the sql-c user to the TableAdmin flexible database role." to "Use the appropriate stored procedure to add the sql_user_c user to the TableAdmin flexible database role.

John Eiford  Jun 17, 2013 
PDF
Page 227
Answer to question 3.

"3. Correct Answer: C" should read "3. Correct Answers: B and C" The section answer for B should be corrected to: "Correct: The ALTER ROLE statement enables you to add members to a flexible database role."

Note from the Author or Editor:
Page 227 Change 3. Correct Answer: C to 3. Correct Answers: B and C & B. Incorrect: The ALTER ROLE statement enables you to change the name of a flexible database role but does not enable you to alter the membership of a flexible database role. to B. Correct: The ALTER ROLE statement enables you to change the name of a flexible database role and allows you to alter the membership of a flexible database role.

Malcolm Wynden  Aug 14, 2012  Oct 19, 2012
PDF
Page 227
Answer to question 2.

"2. Correct Answer: A" should read "2. Correct Answers: A and C" The section answer for A incorrectly implies that CREATE ROLE can be also be used to add members. The section answer for C should be corrected to: "Correct: To add members to an existing database role, use ALTER ROLE"

Note from the Author or Editor:
Page 227 Change 2. Correct Answer: A to 2. Correct Answers: A and C & A. Correct: You use the CREATE ROLE statement to create a flexible database role. You can add existing database users to a flexible database role and assign permissions to that role. to A. Correct: You use the CREATE ROLE statement to create a flexible database role and assign permissions to that role. & C. Incorrect: You use the ALTER ROLE statement to rename an existing flexible server role. to C. Correct. You use the ALTER ROLE statement to add and remove members from a database role.

Malcolm Wynden  Aug 14, 2012  Oct 19, 2012
PDF
Page 234
1st paragraph

First code sample: misspelling This: EXEC sp_addrolemenber [db_datawriter], [Chicken]; Change to this: EXEC sp_addrolemember [db_datawriter], [Chicken];

Note from the Author or Editor:
Page 432 Change EXEC sp_addrolemenber [db_datawriter], [Chicken]; to EXEC sp_addrolemember [db_datawriter], [Chicken];

truncheon411  Apr 22, 2013  May 24, 2013
PDF
Page 236
Code sample, middle of page

The statement "When granting, denying, or revoking permissions from a securable, you must perform one operation at a time." is not correct. The code sample supplied to demonstrate this DENY ALTER ON [Person].[Address] TO [GAMMA-ROLE] DENY INSERT ON [Person].[Address] TO [GAMMA-ROLE] DENY UPDATE ON [Person].[Address] TO [GAMMA-ROLE] can be replaced with the combined operation DENY ALTER,INSERT,UPDATE ON [Person].[Address] TO [GAMMA-ROLE]

Note from the Author or Editor:
Page 236 Change "When granting, denying, or revoking permissions from a securable, you must perform one operation at a time." to "When granting, denying, or revoking permissions from a securable, you should perform one operation at a time."

Malcolm Wynden  Aug 14, 2012  Oct 19, 2012
Printed, PDF
Page 238
Practice - Exercise 1

Exercise does not specify which SQL Server virtual machine to create the scheme, roles and permissions on...

Note from the Author or Editor:
Page 238 Change Log on to the default instance with the Kim_Akers user account. to Log on to the default instance on SQL-A with the Kim_Akers user account.

Daniel Dittenhafer  Dec 30, 2012  Feb 08, 2013
Printed, PDF
Page 261
Last paragraph

Typo: sys.server_audit_specifications_details should be sys.server_audit_specification_details (one 's' less).

Note from the Author or Editor:
Page 261 Change "sys.server_audit_specifications_details" to "sys.server_audit_specification_details"

Ronny Gutermuth  May 30, 2013 
Printed
Page 264
bottom of page

Category A collection of categories that should be enforced together... Should be Category A collection of policies that should be enforced together...

Note from the Author or Editor:
Page 264 Change Category A collection of categories that should be enforced together... to Category A collection of policies that should be enforced together...

Anonymous  Oct 09, 2012  Oct 19, 2012
Printed, PDF
Page 270
Excercise 3 item 5, third sub-item

sys.server_audit_specification_detail should be sys.server_audit_specification_details (missing trailing S).

Note from the Author or Editor:
Page 270 Change sys.server_audit_specification_detail should be sys.server_audit_specification_details

Bodhi Densmore  Apr 16, 2013  May 24, 2013
Printed, PDF
Page 271
Question 4

"Each correct answer presents a complete solution" Should be "Each correct answer presents part of a complete solution"

Note from the Author or Editor:
Page 271 Question 4 Change (Each correct answer presents a complete solution. Choose all that apply.) to (Each correct answer presents part of a complete solution. Choose all that apply.)

Arik  Jan 27, 2013  Feb 08, 2013
PDF
Page 275
2nd paragraph

Answer Lesson 2, Question 2: Answer is incomplete Item A. is also correct. The sys.sql_logins catalog view inherits the is_disabled column from sys.server_principals. http://technet.microsoft.com/en-us/library/ms174355.aspx This: "A. Incorrect. You can use the sys.sql_logins catalog view to determine whether a SQL Server–authenticated login is configured to use a password policy and has an expiration date. You cannot use this catalog view to determine whether a login is disabled" Change to this: "A. Correct. You can query the sys.sql_logins catalog view to determine whether a login is disabled."

Note from the Author or Editor:
Page 275 Change 2. Correct Answer: C to 2. Correct Answer: A and C Change A. Incorrect. You can use the sys.sql_logins catalog view to determine whether a SQL Server–authenticated login is configured to use a password policy and has an expiration date. You cannot use this catalog view to determine whether a login is disabled. to A. Correct. You can use the sys.sql_logins catalog view to determine whether a SQL Server–authenticated login is configured to use a password policy and has an expiration date. Through inheritance this view also displays whether a login is disabled.

truncheon411  Apr 22, 2013  May 24, 2013
PDF
Page 277
Case Scenario 3.2

The question for 3.2 reads: "2. Which step should you take to ensure that both successful and failed audits are logged on the default instance on SYD-SQL-A?" This question is about logging both success and failure in audits, an important feature of auditing that is enabled through configuring the Audit Object Access policy for both Success and Failure. However, the answer is about auditing both success and failure in LOGINS, which is not the question as asked.

Note from the Author or Editor:
Page 272 Change "Which step should you take to ensure that both successful and failed audits are logged on the default instance on SYD-SQL-A?" to "Which step should you take to ensure that both successful and failed logins are audited on the default instance on SYD-SQL-A?"

Malcolm Wynden  Aug 16, 2012  Oct 19, 2012
PDF
Page 284
Link middle of page

MORE INFO PREPARE MIRROR DATABASE FOR MIRRORING Link is incorrect, should be http://msdn.microsoft.com/en-us/library/ms189053(v=sql.110).aspx

Note from the Author or Editor:
Page 284 Change http://msdn.microsoft.com/en-us/library/ms189047(SQL.110).aspx to http://msdn.microsoft.com/en-us/library/ms189053(v=sql.110).aspx

Malcolm Wynden  Aug 16, 2012  Oct 19, 2012
PDF
Page 290
More Info link

MORE INFO DATABASE MIRRORING OPERATING MODES link is to wrong page, should be http://msdn.microsoft.com/en-us/library/dd207006.aspx

Note from the Author or Editor:
Page 290 Change http://msdn.microsoft.com/en-us/library/ms190430(SQL.110).aspx to http://msdn.microsoft.com/en-us/library/dd207006.aspx

Malcolm Wynden  Aug 16, 2012  Oct 19, 2012
PDF
Page 295
3rd bullet point

"3. Run DBCC CHECKDB on the new principal server": there is no "new" principal server as no upgrade nor failover has occured yet.

Note from the Author or Editor:
Page 295 change Run DBCC CHECKDB on the new principal server. to Run DBCC CHECKDB on the principal server.

VASCO  May 11, 2013  May 24, 2013
PDF
Page 298
Question 2

Points A, C and D refers to SQL Server Agent account, but mirroring use SQL Server Service accounts. The same is for answers to this question

Note from the Author or Editor:
Page 298 In Question 2 change three instances of SQL Server Agent service account to SQL Server service account Page 324 In the answers to question 2, change SQL Server Agent account (A) and SQL Server Agent service account (B) and (D) to SQL Server service account.

marekwlodarz  Jan 08, 2013  Feb 08, 2013
PDF
Page 326
Scenario 1, point 1

"You must create logins for accounts cohovineyard\syd-sql-a and cohovineyard\syd-sql-b so that the principal instance and the witness instance can be granted permissions on the endpoint" Scenario says, that witness should be Sydney-SQL-C, so login is needed for account cohovineyard\syd-sql-c, not ...-b

Note from the Author or Editor:
Page 326 Change cohovineyard\syd-sql-a and cohovineyard\syd-sql-b to cohovineyard\syd-sql-a and cohovineyard\syd-sql-c

marekwlodarz  Jan 09, 2013  Feb 08, 2013
PDF
Page 343
step 3 (top of page)

instruction says: Cluster resource group name: SQL2012CRG, but in step 4 there is SQLCRG as resource name (and the same on screen below).

Note from the Author or Editor:
Page 343 Change Cluster resource group name: SQL2012CRG to Cluster resource group name: SQLCRG

marekwlodarz  Jan 12, 2013  Feb 08, 2013
PDF
Page 354
Enabling AlwaysOn Availability Groups point #3

"Right-click the SQL Server service related to the instance on which you want to enable AlwaysOn Availability Groups." SHOULD READ "Right-click the SQL Server service related to the instance on which you want to enable AlwaysOn Availability Groups and select Properties."

Note from the Author or Editor:
Page 354 Change "Right-click the SQL Server service related to the instance on which you want to enable AlwaysOn Availability Groups." To "Right-click the SQL Server service related to the instance on which you want to enable AlwaysOn Availability Groups and select Properties."

Nakis Ioannides  Jun 12, 2013 
Printed
Page 364
Lesson Summary

"You can have only one listener per availability group." This contradicts what is stated on page 358: "If you need more than one listener for an availability group, it is possible to create additional listeners by using Windows PowerShell or the Failover Cluster Manager console."

Note from the Author or Editor:
Page 364 Change You can have only one listener per availability group. to Each availability group listener must have a unique DNS name

Microsoft Press  Jul 03, 2013 
Printed
Page 373
4th paragraph

The first sentence reads "Every counter has one or more instances associated with it." Later, in the Lesson Summary on page 377 it reads "A counter can have zero or more instances.". A counter can indeed have zero or more instances. Page 373 is incorrect and page 377 is correct.

Note from the Author or Editor:
Page 373 Change Every counter has one or more instances associated with it. to Every counter has zero or more instances associated with it.

Eric Riddle  Nov 08, 2012  Feb 08, 2013
Printed, PDF
Page 387,411
Question 2 Question and Answer

Question on page 387 has SQL:StmtCompleted as A Answer on page 411 has SQL:StmtCompleted as C

Note from the Author or Editor:
Page 387 and 388 Change A. SQL:StmtCompleted C. SQL:BatchComplete to A. SQL:BatchComplete C. SQL:StmtCompleted

Jeremie Roberts  Dec 30, 2012  Feb 08, 2013
Printed, PDF
Page 390
Table 9-3

In the last table entry, sys_db_db_* should be sys_dm_db_*

Note from the Author or Editor:
Page 390 Change sys_db_db_* to sys_dm_db_*

Bodhi Densmore  Apr 17, 2013  May 24, 2013
PDF
Page 398
Exam Tip

"EXAM TIP - A user must be a member of the mdw_reader role to access the reports and the collected data and to upload data." A "read" role typically cannot upload data - that is (typically) a "write" role. Please clarify.

Note from the Author or Editor:
Page 398 Delete exam tip

Malcolm Wynden  Aug 23, 2012  Oct 19, 2012
Printed, PDF
Page 411
Lesson 2, answer to question 2

This issue was previously addressed in another confirmed errata. However, I feel the statement on page 411: "2. Correct Answers: C and D" is incorrect. The correct statement should be: "2. Correct Answers: A and C" where: A. SQL:BatchComplete B. SQL:StmtStarting C: SQL:StmtCompleted D: RPC: Completed Are the alternative options.

Note from the Author or Editor:
Page 411 Change 2. Correct Answers: C and D to 2. Correct Answers: A and B Change the answers for A, B, C and D so that A and B are listed as correct and C and D are listed as incorrect.

Hector Rocha  Mar 24, 2013  May 24, 2013
PDF
Page 424
Table 10-1

Table 10-1 lists Lvalue twice. Once at the end of 424 and again after the page break on 425.

Note from the Author or Editor:
Page 425 Delete duplicate in table Lvalue long node value (pointer) nvarchar(max)

Brian Velji  Apr 08, 2013  May 24, 2013
PDF
Page 426
first paragraph

The last sentence reads "Online transaction processing (OLAP) cubes..." It should be online analytical processing

Note from the Author or Editor:
Page 426 Change "Online transaction processing (OLAP) cubes are commonly used to provide the performance levels required by businesses" to Online analytical processing (OLAP) cubes are commonly used to provide the performance levels required by businesses.

Brian Velji  Apr 08, 2013  May 24, 2013
PDF
Page 441
Last paragraph

Lesson Review, question 5, choice D.: Misspelling. This: "Execute the UDPATE STATISTICS command..." Change to this: "Execute the UPDATE STATISTICS command..."

Note from the Author or Editor:
Page 441 Change "Execute the UDPATE STATISTICS command..." to "Execute the UPDATE STATISTICS command..."

truncheon411  Apr 22, 2013  May 24, 2013
PDF
Page 442
More info box near the bottom

The link in the box is wrong. It doesn't lead to a page about ACID but to a page about isoloation levels (identical to the link on page 446 btw)

Note from the Author or Editor:
Page 442 Change http://msdn.microsoft.com/en-us/library/ms378149(v=sql.110).aspx to http://technet.microsoft.com/en-us/magazine/hh750281.aspx

Dan Reving  May 30, 2013 
PDF
Page 445
More Info link

MORE INFO LOCK COMPATIBILITY MATRIX link is broken

Note from the Author or Editor:
The URL is broken across two lines, but does reference the correct page on MSDN.

Malcolm Wynden  Aug 23, 2012  Oct 19, 2012
PDF
Page 446
More Info link

MORE INFO ISOLATION LEVELS broken link, should be http://msdn.microsoft.com/en-us/library/ms378149(sql110).aspx

Note from the Author or Editor:
The link as listed just goes to the SQL 2008 R2 version of the topic. It has identical content. However for completeness it should point to the SQL 2012 page which can be found at http://msdn.microsoft.com/en-us/library/ms378149(sql110).aspx

Malcolm Wynden  Aug 23, 2012  Oct 19, 2012
PDF
Page 446
First line

The sentence ends with "... and then release all the READ Locks". Has to be "... and then release all the ROW Locks" to make any sense.

Note from the Author or Editor:
Page 446 Change "take a table lock and then release all the read locks." to "take a table lock and then release all the row locks."

Dan Reving  May 30, 2013 
Printed, PDF
Page 447
Code sample

The code sample is intended to demonstrate how to set the transaction isolation level to SNAPSHOT. However, the line SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; sets it to REPEATABLE READ, the default value. This line should be SET TRANSACTION ISOLATION LEVEL SNAPSHOT;

Note from the Author or Editor:
The terms REPEATABLE READ; should be changed to read SNAPSHOT;

Malcolm Wynden  Aug 23, 2012  Oct 19, 2012
PDF
Page 449
1st paragraph

"Alternatively, if the blocking_session_id column of sys.dm_waiting_tasks or sys.dm_exec_requests has a value greater than zero, this indicates blocking and also indicates which session is blocking." There is no such DMV sys.dm_waiting_tasks. Perhaps you mean sys.dm_os_waiting_tasks.

Note from the Author or Editor:
Page 449 Change sys.dm_waiting_tasks to sys.dm_os_waiting_tasks

Anonymous  Mar 26, 2013  May 24, 2013
Printed
Page 457
exercise 2

Two issues: 1. There is no 'status' column in the sys.dm_os_waiting_tasks DMV.. This column is present in the dm_exec_requests DMV, and possibly others. 2. The phrasing could be better, i.e., 'the blocking_session_id column of the sys.dm_exec_requests DMV' instead of 'the sys.dm_exec_requests blocking_session_id column'

Note from the Author or Editor:
Page 457 Change "the sys.dm_os_waiting_tasks status column" to "the sys.dm_os_waiting_tasks DMV"

Ed  Aug 13, 2013 
Printed
Page 459
2nd Paragraph

It is stated "You cannot create an index at this time." however the answer on page 463 says to look at the missing index view to ensure all appropriate indexes are created.

Note from the Author or Editor:
Page 459 Remove sentence You cannot create an index at this time.

Anthony MAttas  Feb 11, 2013  May 24, 2013
PDF
Page 462
Last paragraph

Lesson 2 Answers, Question 3, item B: typo, extra period This: "The blocking_session_id column of .sys.dm_exec_requests enables..." Change to this: "The blocking_session_id column of sys.dm_exec_requests enables..."

Note from the Author or Editor:
Page 462 Change Correct: The blocking_session_id column of .sys.dm_exec_requests enables you to determine where blocking is occurring. to Correct: The blocking_session_id column of sys.dm_exec_requests enables you to determine where blocking is occurring.

truncheon411  Apr 22, 2013  May 24, 2013
PDF
Page 463
Case Scenario 1

This Case Scenario poses 4 questions, but only three questions are explicitly answered. Please clarify.

Note from the Author or Editor:
On page 459 remove item number 2 and renumbered the existing 3 and 4 to 2 and 3 respectively

Malcolm Wynden  Aug 23, 2012  Oct 19, 2012
Printed
Page 488
Line 8 - File and filegroup backups

Truncate Log On Checkpoint no longer exists in SQL Server 2012. You should use Simple Recovery Model instead.

Note from the Author or Editor:
Page 488 Delete "You cannot use this method if the Truncate Log On Checkpoint option is enabled."

Carlos Cipriano  Feb 14, 2013  May 24, 2013
Printed, PDF
Page 524
Case Study 1, Line 32

CREATE USER contained user WITH PASSWORD = 'Pa$$w0rd'; should read CREATE USER contained_user WITH PASSWORD = 'Pa$$w0rd';

Note from the Author or Editor:
Page 524 Change CREATE USER contained user WITH PASSWORD = 'Pa$$w0rd'; to CREATE USER contained_user WITH PASSWORD = 'Pa$$w0rd';

Malcolm Wynden  Aug 27, 2012  Oct 19, 2012
Printed, PDF
Page 532
Question 15

B. The principal "Modify_Databases" is mistakenly refered to as "ModifyDatabases".

Note from the Author or Editor:
Page 532 Change B. ModifyDatabases to B. Modify_Databases

Malcolm Wynden  Aug 27, 2012  Oct 19, 2012
Printed
Page 553
Question 16 - Answers A and C

The Modify_Databases is a server role not a database-level role, besides you can´t add a server login to a database-level role.

Note from the Author or Editor:
Page 553 Change QUESTION 15 Correct Answers: A and B to QUESTION 15 Correct Answer: A Change B. Correct. You can add a flexible database role to another flexible database role. to B. Incorrect. You cannot add a server role to a flexible database role.

Carlos Cipriano  Feb 17, 2013  May 24, 2013
Printed, PDF
Page 555
Question 3

The correct answer is actually C, not B. The text explanation for B is also incorrect - it should read "The ALTER DATABASE AUDIT SPECIFICATION [DATABASE_SPEC] statement configures auditing for backup and restore operations at the database level" The text explanation for C is accuate and correct, but it needs to be identified as the correct answer.

Note from the Author or Editor:
Page 555 Change Question 3 Correct Answer: B to Question 3 Correct Answer: C & B. Correct. The ALTER DATABASE AUDIT SPECIFICATION [DATABASE_SPEC] statement configures auditing for backup and restore operations at the instance level. to B. Incorrect. The ALTER DATABASE AUDIT SPECIFICATION [DATABASE_SPEC] statement configures auditing for backup and restore operations at the database level. & C. Incorrect. The ALTER SERVER AUDIT SPECIFICATION [INSTANCE_SPEC] statement configures auditing for backup and restore operations at the instance level. to C. Correct. The ALTER SERVER AUDIT SPECIFICATION [INSTANCE_SPEC] statement configures auditing for backup and restore operations at the instance level.

Malcolm Wynden  Aug 27, 2012  Oct 19, 2012