- Series: Expert's Voice in SQL Server
- Paperback: 456 pages
- Publisher: Apress; 1st ed. edition (September 4, 2012)
- Language: English
- ISBN-10: 1430237716
- ISBN-13: 978-1430237716
- Product Dimensions: 7 x 1 x 10 inches
- Shipping Weight: 2.1 pounds (View shipping rates and policies)
- Average Customer Review: 13 customer reviews
- Amazon Best Sellers Rank: #1,548,082 in Books (See Top 100 in Books)
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.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who viewed this item also viewed
About the Author
Andy Leonard is an SSIS trainer and consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQL Server "Most Valuable Professional", SQLBlog.com blogger, and engineer. He is co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, Visual Basic, ASP, SQL Server Integration Services (SSIS), and data warehouse development using SQL Server 2000, 2005 and 2008.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
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. A screenshot of the completed package is displayed in Figure 1-1.
Fortunately, my staff are all fairly adept at reading Klingon and have been able to work their way through this, but they should not have to spend time translating when they are reading a $40 technical book. I agree whole heartedly with M Noreen's review. The book should be recalled by the publisher and buyers of this book should receive a refund.