Customer Reviews

4
4.0 out of 5 stars
5 star
0
4 star
4
3 star
0
2 star
0
1 star
0
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
Format: PaperbackChange
Price:£27.99+Free shipping with Amazon Prime

Your rating(Clear)Rate this item
Share your thoughts with other customers

There was a problem filtering reviews right now. Please try again later.

1 of 1 people found the following review helpful
on 15 July 2012
Nice Cookbook for the experienced SSIS developer. It has useful recipes which I feel do encompass most scenarios one would encounter in the "world" of SSIS development. It will be an asset in any SSIS Library.

I think this book could be used by Learners of SSIS (2012) as well as by experienced SSIS developers, in as much the best way to learn a product is by practical experience and some of the "cook book" recipes tend to be on basics and useful for gaining practical experience.

However (experienced and beginners alike) be aware that I found it difficult to follow some of the recipes from scratch in my test lab; I feel that a certain assumptions have be made on how things work in SSIS and some of the recipes have been written by someone with very knowledgeable SSIS experience, so no "dumbing down" and I think certain steps in the recipes were omitted or not explained clearly. I marked it down to 4 stars because of this factor. A saving grace is they do provide their downloadable solutions from the PACKT publishing site so at least you can get at a correct solution and this I found useful as I could re-engineer the recipes.

Over all, very pleased with the book and I am glad it is in my Library.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on 27 July 2012
As someone who has only previously used SSIS 2008 for very simple ETL's I found this book insightful and useful. The early chapters do a good job of explaining Control Flow and Data Flow tasks, their purposes and how to use them. It also explains the basics of SSDT and what has changed since BIDS and SSIS 2008.

I did not dwell on the mid chapters 6-8 as they walk through some of the more complex parts of SSIS that are very useful to ETL developers and good things to understand for the rest of us. Instead I skipped ahead and found Chapter 9 usefully explains the various ways that can now be employed to deploy SSIS packages through environments. The new Project Deployment Model differs from the older Package Deployment Model you may have been familiar with and Chapter 9 does a very good of explaining this and how to use the new model and the SSIS Catalog. The examples do a good job of demonstrating this and will be of great help when trying to decide which method you want or need to standardise your release processes for.

Chapters 10 and 13 are definitely ones I will be coming back to as and when I have SQL 2012 servers going live and will need to be able to migrate older 2008 packages to them. They also give good examples on how to ensure that packages are in a supportable state with decent error handling.

Overall a very good book and definitely a good addition to the book shelf that I would recommend for DBA's as well as ETL developers.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on 30 July 2012
This cookbook is well illustrated, written and informative with step by step examples for real world solutions, In depth explanations are provided at the end of each example.

The book includes performance tips, best advised practises and new features in SSIS 2012 (Upsert, Change Data Capture, Undo/Redo,Shared Connection Managers etc).

The Bottom Line: An excellent go to resource for the new BIDS Developer or experienced Bids Developer / DBA looking to explore new features or improve current package performance this book has something for you.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on 23 January 2013
Bought this book while I was preparing for my "70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012" certification. It does not cover all the topics(such as DQS, MDS) required for the exam, but all the SSIS 2012 features are explained clearly with Step by step examples. Enjoyed reading through and practicing.

E-book was given free when hard copy was bought from "PACKT publishing" website. Hard copy arrived after I finished my exam(3 weeks after ordering). It was the e-book that I had read through.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
     
 
Customers who viewed this item also viewed

Professional Microsoft SQL Server 2012 Integration Services
Professional Microsoft SQL Server 2012 Integration Services by Brian Knight (Paperback - 23 Mar. 2012)
£20.75

 
     

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)
  -  
Customized Service, U.S. Based DBAs Reduce Admin Costs by 40%-Get Quote
  -  
Set SQL Server Wait Event Alerts. Catch SLA Violations. Free Trial!
  -  
Data Access & Integration Boost Enterprise Agility. Free Evaluation