Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) 1st ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
Within a few hours of reading this book, it stood out that none of the authors were trying to impress by showing what they all know in SSIS. Instead, they focused on describing solutions and patterns in a great detail (exactly why i paid for).
Each chapter is a collection of solutions and best practices to common data integration problems. For loading flat files go to chapter 7, for data warehouse patterns go to chapter 11. Each solution is written in detail with lots of pictures and step by step instructions. You could have the book open at work and follow through each step to solve a problem without running into any issues.
It is fun to read as well. I smiled when page 30 said VCR play button (referring to the debug button).Literature in the book is plain, clear, and casually written. It was like reading a blog post - simple and refreshing.
If you're on a mission to learn everything about SSIS, this book alone won't probably cut it for you. This isn't a know-all-SSIS book. Authors didn't hide this fact either. Cover of the book says "Improve your efficiency as a data integration developer". This focuses on patterns to data integration problems. If your job involves moving data using SSIS, this is a must have.
SSIS 2012 Design Patterns teaches building faster, efficient, and reusable packages for your data integration needs.
I'm @SamuelVanga on Twitter.
I was contacted by the authors and publisher of this book and advised that the terrible type-setting mentioned in my review and in my uploaded photo only existed in an early batch of books sent to Amazon. The publisher provided me with a replacement free of charge which has none of the previously mentioned problems.
I was greatly impressed by the efforts that the authors and publishers went to in order to track me down and insure my satisfaction.
Rating changed from ** to ***** due to good content and excellent customer service.
While the content of the book is fairly good (probably worthy of **** instead of **), the book has horrible text formatting and editing mishaps through out. I'll upload a photo of part of one page so you know I'm not making this up, but here is a text excerpt from Chapter 1 on Metadata Collection:
3. Create a table for each of the data elements we wish to monitor (unused indexes and databaseg rowth).
In Integration Services, we will do the following:
1. Createa n ewI ntegrationS ervicesp ackage.
2. Retrieve a list of SQL Server instances and store the list in a variable.
3. Create an OLE DB connection with a dynamically populated server name.
4. Iteratet hroughe achd atabasea nd
a. Retrievec urrentd atabasea ndl og files izesf orh istoricalm onitoring.
b. Retrieve a list of index candidates for potential redesign or dropping.
c. Update the Last Monitored value for each SQL Server instance.
This is a very flexible model that can easily be expanded to include many more monitoring tasks.Read more ›
The chapter on BIML alone is worth the price of this book. This is the only book I have come across so far that mentions BIML and provides a thorough walk-through to get you up and running very quickly. BIML is truly game-changing and has saved me hundreds of hours of development time. If you develop many ETLs using the same pattern, I recommend you read the chapter on BIML.
Most Recent Customer Reviews
I worked through this book and enjoyed the exercises. I thought the book was thorough and I learned a few new tricks of the trade.Published 18 months ago by Amazon Customer
The book's second edition has come out, so you can get that one - or, since the revisions are minimal, go with the first edition if you find a bargain. I did not like either. Read morePublished 19 months ago by Dimitri Shvorob
Not much meat here. Lots of talk but not much substance. Might be good for someone wanting a 20000 ft view but not much good for someone trying to use SSIS. Read morePublished on July 19, 2013 by John M Higdon
it's a bit dificult for a beginner like me. and i am not familar with the title words...not sure they do it on purpose or what. Read morePublished on December 14, 2012 by Zheng