Top critical review
5 people found this helpful
Useful theory let down by error strewn examples
on 18 November 2013
As someone with a background in the SQL Server BI Stack I was hoping to use this book to learn a bit more of the theory behind the practice, get to grips with the new features in SQL Server 2012 and pass exam 70-463.
Whilst the theoretical content is good, covering everything from DW schema basics to optimising your SSIS packages, the example code is poor, often offering incomplete (or just plain incorrect) advice.
It unfortunately appears that no one proof-read the examples, or actually tried them out for themselves, otherwise the obvious errors would have been spotted.
A few examples of errors in the book include:
Creating table schemas and then inserting values larger than the column size without encountering a failure
Constantly switching between singular and plural table names (in the same example). This occurs so often, you often actually have to check back to the example code to see what you actually called the table...
Asking the user to 'connect the output' fro a transformation to another transformation, without specifying if you should connect the 'success' or 'failure' output.
However, if you can get past the issues in the examples, there is a lot of helpful information here and the exam questions are good basic preparation for taking the final exam.