|
Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution (Wrox Programmer to Programmer) |  | Authors: Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney
Publisher: Wrox
Category: Book
List Price: $49.99
Buy New: $26.60
as of 7/29/2010 05:26 CDT details
You Save: $23.39 (47%)
New (26) Used (9) from $26.60
Seller: indoobestsellers
Rating:  6 reviews
Sales Rank: 43040
Media: Paperback
Pages: 480
Number Of Items: 1
Shipping Weight (lbs): 1.9
Dimensions (in): 9.1 x 7.2 x 1
ISBN: 0470525762
Dewey Decimal Number: 005.7585
EAN: 9780470525760
ASIN: 0470525762
Publication Date: November 2, 2009
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them. - Shows you how to design SSIS solutions for data cleansing, ETL and file management
- Demonstrates how to integrate data from a variety of data sources,
- Shows how to monitor SSIS performance,
- Demonstrates how to avoid common pitfalls involved with SSIS deployment
- Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
- The companion Web site provides sample code and database scripts that readers can directly implement
This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.
|
| Customer Reviews:
Showing reviews 1-5 of 6
 Good job, keep it up April 24, 2010
Shahzad Khan (Charlotte, NC USA)
Not a beginner's book. Target audience is medium to expert level professionals.
Simply put, should I write code or architect a process flow (package) with minimum code effort to solve business problem? If architecting is a choice then this book is for you.
The book covers package framework, design and development. It walks you through design patterns for developing effective SSIS packages. There is a nice section on package's performance with comparison to memory and disk I/O bottlenecks.
The book also covers physical infrastructure and deployment by focusing on package deployment on single/multiple computers and talk about processor capacity, RAM and physical disk size.
Indispensable for Serious ETL Developers April 23, 2010
Anthony Cheng (Vancouver, BC, Canada)
I echo the comments of the other reviewers. I bought this book, despite it only had one reviewer comment,largely because the authors. It turned out it was best decision I ever made. Unlike other SSIS books which teach you on how to use the software, this book instead focused on real world common issues faced by ETL developers. I specifically love the logging, and chapter 7 and 8 for dimension and fact. Regardles of your SSIS level, you will definitely learn something new from this. I highly recommend this book.
SQL Server Integration Services: Problem - Design - Solution April 15, 2010
Tim D. Mitchell (Dallas, TX)
1 out of 1 found this review helpful
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I really get a lot out of, I don't mind sharing my experience. Such was the case with a book I finished recently. SQL Server 2008 Integration Services: Problem - Design - Solution is a concise guide to becoming a better ETL developer, written by four highly experienced industry experts. After reading this book, I can recommend it without hesitation!
From the first few pages, it's obvious that this book is different from many other SSIS books. Rather than trying to teach the reader how to use the software, this book instead focuses on common business problems and the methodology behind solving them. The authors assume some familiarity with SSIS, so you won't find a comprehensive how-to manual if you've never created a package before. That being said, the concepts presented here are not so complex that only highly seasoned ETL developers will understand them; to the contrary, the book illustrates a number of simple yet practical approaches, along with relevant examples, that audiences of various skill levels will get something out of it.
One of the most relevant topics covered was the concept of building an SSIS management framework, which was my favorite part of the book. Having recently moved from an environment with a relatively small number of packages to a consulting role where I might interact with hundreds of packages a month, I found that a solid ETL framework is a critical component of success. Chapter 2 of the Problem - Design - Solution book explains why, and illustrates how, one would build an SSIS management framework. For anyone that has struggled with a large number of packages or has wrestled with the shortcomings of the built-in SSIS logging tools, this chapter should prove useful as both a guide and a best practices reference. Further into the book, the authors cover other topics essential to data warehousing ETL, including data cleansing and fact and dimension table ETL. The authors go on to cover scripting in SSIS, one of my favorite topics, and do a good job of addressing scripting patterns in both the script task and script component. Finally, the book reviews ways to monitor and improve SSIS performance.
I consider a technical book to be successful if it contains the right mix of information so that I can immediately apply what I've learned to legitimate problems and situation. To that end, this book is a winner in my opinion; even though I have been developing ETL processes in SSIS for years, I was able to walk away with some practical techniques that I began using almost immediately. Experienced ETL developers, as well as those with only a little SSIS experience, will likely find this book very useful.
Great book! April 9, 2010
C. Staffieri (Richmond, VA USA)
First off, let me say that this is a great book and I highly recommend reading it. I have been developing in SSIS on and off for the past 5 years and this book opened me up to new approaches on solving every day problems. Having the book broken down between Problem/Design/Solution is great because as a developer sometimes it is hard to envision when it would be the right time to use certain technologies over others.
Advanced SSIS, Thank You! March 23, 2010
James T. Cooke
2 out of 2 found this review helpful
This book is really good for more advanced users. If you have developed SSIS packages in the past, and want to take the next step to make your systems better, then get this book. I am a developer for a big company and I rarely see advanced "real world" examples of SSIS solutions. I love the first chapter on SSIS logging. Download the code from the website, and it will create your logging tables and procs with just minor modifications to the scripts.
I initially put off buying this book for a week because it only had one review at the time (even though it was 5 stars).
This is an excellent Book!
Showing reviews 1-5 of 6
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
