Pro SQL Server 2012 Integration Services

Overview

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012.You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration ...

See more details below
Paperback (New)
$42.42
BN.com price
(Save 15%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (17) from $37.80   
  • New (15) from $37.80   
  • Used (2) from $41.37   
Pro SQL Server 2012 Integration Services

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012.You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates anunprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.

  • Helps you design and develop robust, efficient, scalable ETL solutions
  • Walks you through using the built-in, stock components
  • Shows how to programmatically extend the power of SSIS to cover any possible scenario

What you’ll learn

  • Create an SSIS package from scratch
  • Deploy an SSIS package to any environment
  • Benchmark the performance of SSIS packages using common tools
  • Optimize SSIS data flows to achieve maximum performance
  • Use .NET to extend the power of the stock SSIS toolkit
  • Profile and scrub data during the ETL process

Who this book is for

Pro SQL Server 2012 Integration Services is for ETL developers, SQL developers, and database administrators at all levels of experience who want to harness the power of SSIS on SQL Server 2012. Whether you are using SSIS to build small, one-off ETL packages in a small shop, or building enterprise-wide ETL solutions in a Fortune 500 company, this book gives you the information you'll need to build powerful, scalable, and efficient ETL solutions at any level of complexity.

Table of Contents

  1. Introducing Integration Services
  2. BIDS and SSMS
  3. “Hello World!”—Your First SSIS 2012 Package
  4. Connection Managers
  5. Control Flow Basics
  6. Advanced Control Flow Tasks
  7. Source and Destination Adapters
  8. Data Flow Transformations
  9. Variables, Parameters, and Expressions
  10. Scripting
  11. Events and Error Handling
  12. Data Profiling and Scrubbing
  13. Logging, Auditing and Data Lineage
  14. Heterogeneous Sources and Destinations
  15. Data Flow Tuning and Optimization
  16. Parent-Child Design Pattern
  17. Dimensional Data ETL
  18. Building Robust Solutions
  19. Deployment Model
Read More Show Less

Product Details

  • ISBN-13: 9781430236924
  • Publisher: Apress
  • Publication date: 6/27/2012
  • Edition description: New
  • Edition number: 1
  • Pages: 636
  • Sales rank: 1,037,434
  • Product dimensions: 17.60 (w) x 9.20 (h) x 1.50 (d)

Meet the Author

Francis Rodrigues is a business intelligence consultant based out of New York City. A computer science graduate of Loyola College in Maryland, he is an expert developer of enterprise business intelligence projects. His specialties include extract, transfer, load (ETL) solutions based on SQL Server, SQL Server Integration Services (SSIS), and Oracle.

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

David Dye is a Microsoft SQL Server MVP, instructor, and author specializing in relational database management systems, business intelligence systems, reporting solutions, and Microsoft SharePoint. For the past 9 years David's expertise has been focused on Microsoft SQL Server development and administration. His work has earned him recognition as: a Microsoft MVP in 2009 and 2010, a moderator for the Microsoft Developer Network for SQL Server forums, Innovator of the Year runner-up in 2009 by SQL Server Magazine, and in the Training Associates Technical Trainer Spotlight in April 2011. David currently serves as a technical reviewer and co-author with APress Publishing in the SQL Server 2012 series, and as an author with Packt Publishing.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)